About the position
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.
RequirementsKey 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.
Desired Skills:
- Power BI
- DAX
- Power Query (M)
- Data modelling
- Databricks
- Semantic models
- Microsoft Fabric
Desired Qualification Level:
About The Employer:
