Our client requires a Power BI Lead Consultant to support an energy-sector client. This lead-level, hands-on consulting role focused on strong Power BI delivery, with particular emphasis on performance and cost optimisation.

Experience using Databricks as a data source, and working with large datasets, is strongly preferred.

Requirements

Key Responsibilities

• Lead the design and delivery of Power BI solutions for the client, to a high professional standard.
  
• Drive performance and cost optimisation of Power BI semantic models, reports and capacity.
  
• Build and maintain robust data models and semantic models using DAX and Power Query (M).
  
• Connect to and optimise Databricks as a data source, selecting appropriate connectivity and storage modes for large datasets.
  
• Establish and uphold Power BI standards, review the quality of deliverables and mentor other practitioners where required.
  
• Partner with business stakeholders to translate requirements into trusted, reusable reporting.
  
• Advise on Power BI (or Fabric) capacity, licensing and cost management.
  
• Support handover, documentation and the upskilling of client users where needed.
  

Required skills and experience

• Strong Power BI expertise, particularly in performance and cost optimisation.
  
• Advanced DAX and Power Query (M), with a strong command of data modelling (including star-schema design).
  
• Proven experience tuning Power BI models and reports — for example through aggregations, incremental refresh, composite models, query folding and capacity optimisation.
  
• Strongly preferred: experience using Databricks as a data source, and working with large datasets.
  
• The ability to engage stakeholders, gather requirements and explain technical trade-offs clearly.
  
• Comfortable operating as a lead consultant in a client environment.
  

Qualifications

• A relevant tertiary qualification in Computer Science, Information Systems, Commerce, Engineering or a related field, or equivalent practical experience.