Job Description

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.