Power BI Consultant

  • altius
  • London, UK
  • Apr 24, 2020
Full time Consultant Information Technology Software Engineering Technology

Job Description

Altius is a leading data focused technology consultancy specialising in data, performance management and data science solutions. We’re leading the UK market in delivering Microsoft Azure based data platforms and our data science team is at the cutting edge of delivering machine and deep learning solutions. The business has an average annual growth of over 50% and employ 380 people across the UK, The Netherlands and India. Altius brings industry expertise in multiple industry sectors predominately for the retail, travel and transport, infrastructure, and public sectors.

In March 2020, Avanade, the leading digital innovator on the Microsoft ecosystem announced its acquisition of Altius. Combining Altius’ blend of in-depth technical knowledge and advanced architecture skills with Avanade’s breadth of offerings and its close partnership with Microsoft will enable clients to realise the true value of their business data. In addition, Altius’ expertise in enterprise performance management is a valuable addition to Avanade’s technology capabilities.

We’re a dynamic group of bright and talented people who are passionate about their work and offer clients the best thinking through a collaborative culture that honours diversity and reflects the communities in which we operate. This is a fantastic opportunity to operate at the forefront of technology and once the business has transitioned to Avanade, work on a global platform with 29,000 digitally connected people across 23 countries.

More details on Altius and Avanade can be found on https://www.altiusdata.com and https://www.avanade.com

Job Description

We are recruiting for a skilled Power BI Consultant to join a bright & talented team, consisting of Microsoft Valued Professionals (MVPs) and globally recognised experts in the field.  

The role of a Power BI Consultant is a mixture of consulting skills and technical data modelling/visualisation skills.

Our Power BI reporting solutions are often backed by a data platform in Azure that we will also build for the client. Our overall solutions therefore include use of tools such as Azure SQL Data Warehouse (ADW), Azure Data Lake (ADL), Cosmos DB, Stream Analytics and Azure Analysis Services (AAS). Whilst we have dedicated consultants who specialize in these technologies, you will be expected to develop sufficient knowledge of them in order to work effectively within the broader Microsoft team 

Altius have developed a popular custom visual in the Power BI Marketplace  - Altius Icon Map – and our staff have presented both at global conferences and local meetups. The client base which we have developed data visualisation reporting solutions for include several FTSE 100 Companies in the UK and one of the largest European supermarket chains based in the Netherlands.


  • Ingesting data from a variety of corporate data sources and performing required transformations in the query editor using a mixture of utilizing the UI and writing M code.
  • Data modelling capabilities including designing effective BI data models in line with the Kimble methodology.
  • Developing calculations in DAX which are accurate and performant on large datasets.
  • Designing effective layouts using themes and report grids, working closely with our digital design team.
  • Utilizing the navigation features in Power BI (e.g. bookmarks, drill-throughs) to guide readers through a compelling data-driven story.
  • Working with our testing team to manage the processes around client User Acceptance Testing (UAT) and fixing any defects identified.
  • Publishing reports via the Power BI service, managing them through distribution of apps and monitoring usage/data refreshes/security access (N.B: for large scale deployments this is often undertaken by our managed services team).
  • Working closely with clients, gathering requirements and translating them.
  • Shaping an approach for governance and deployment of Power BI in large organizations, including advising on licensing, distribution/sharing, training and support.

Experience Profile

We are looking for the following experience profile:

  • Experience of designing conceptual and logical data models.
  • Skilled in Power BI and other visualisation tools.
  • Ability to take client requirements, understand them and turn them into a powerful story told through engaging visuals in Power BI.
  • Confident communicating with stakeholders of all levels including the ability to advise, train and support clients where necessary.

Additional Information:

Applications are only invited from candidates with the right to reside and work within the UK. Candidates should be willing to travel for the purposes of client delivery and collaborating with colleagues.

Company Benefits

  • 25 days holiday (plus 8 bank holidays)
  • Competitive pension scheme
  • Private healthcare, critical illness, life & travel insurance and income protection
  • Equal employer who value diversity
  • Fantastic parental leave
  • Flat working structure
  • Friday drinks & monthly team socials
  • A variety of snack foods and a fully stocked kitchen
  • Excellent work-life balance
  • Personal development, training days, and external training