About the position
The Power BI Lead Consultant is a lead-level, hands-on specialist who designs and delivers Power BI semanticmodels and reports, with particular emphasis on performance and cost optimisation. The work covers advancedDAX and Power Query, enterprise-scale data modelling, capacity and refresh design, and connecting Power BI toDatabricks and other large-scale sources.
The lead sets modelling standards, reviews technical quality, andengineers models that remain reliable, efficient and well governed.
RequirementsKey Responsibilities
- Design, build and maintain Power BI semantic models and reports to a high technical standard, with particular emphasis on performance and cost.
- Develop robust data models in Power BI using DAX and Power Query (M), including well-structured star-schemadesigns.
- Optimise model and report performance through aggregations, incremental refresh, composite models, query folding, relationship design and storage-mode choices.
- Optimise Power BI or Fabric capacity usage and cost, including refresh design, capacity metrics, licensing considerations and workload management.
- Connect Power BI to Databricks as a data source, selecting and tuning the appropriate connectivity and storage mode (Import, DirectQuery, Direct Lake or composite) for large datasets.
- Engineer models that handle large datasets reliably, including aggregations, hybrid tables, incremental policies and query reduction.
- Define and apply Power BI modelling standards, naming conventions, calculation patterns and technical review practices.
- Implement row-level security, deployment pipelines and application lifecycle management for Power BI solutions.
- Use XMLA, tabular model management and version-controlled development where enterprise model managementis required.
- Build and optimise Power Query (M) ingestion, including query folding, parameterisation and efficient refresh against upstream sources.
- Design DAX measures, calculation groups and reusable calculation logic that are both correct and performant.
- Monitor and remediate slow reports, heavy queries, refresh failures and capacity pressure, and implement durable technical fixes.
- Document semantic models, source mappings, refresh design and performance decisions so solutions can be operated and extended.
- Work with Microsoft Fabric capabilities, including Direct Lake and capacity administration, where they form part of the Power BI estate.
- Review and improve existing Power BI models and reports for performance, cost and technical consistency.
Required skills and experience
- Strong Power BI expertise, with particular depth in performance and cost optimisation.
- Advanced DAX, including measures, iterators, evaluation context, calculation groups and performance-consciouscalculation design.
- Advanced Power Query (M), including query folding, incremental and parameterised refresh, and efficient data shaping.
- Strong command of dimensional and star-schema modelling, relationship design, and Power BI semantic-modelstructure.
- Experience building and maintaining enterprise-scale semantic models, including composite and hybrid model patterns.
- Proven experience tuning Power BI models and reports using aggregations, incremental refresh, composite models,query folding, storage-mode selection and capacity optimisation.
- Experience managing or advising on Power BI or Fabric capacity, refresh windows, load behaviour and cost control.
- Experience using Databricks as a Power BI data source, and working with large datasets, is strongly preferred.
- Practical understanding of Import, DirectQuery, Direct Lake and composite connectivity, and of when each isappropriate for volume, latency and cost.
- Experience with row-level security, deployment pipelines, XMLA endpoints and enterprise governance of Power BI.
- Familiarity with Microsoft Fabric, including Direct Lake or Fabric capacity administration, is advantageous.
- A Microsoft certification such as PL-300, or a Fabric equivalent, is advantageous.
Qualifications
- A degree in Computer Science, Information Systems, Engineering, Mathematics or a related field, or equivalentpractical experience.
- Microsoft Certified: Power BI Data Analyst Associate (exam PL-300).
- Microsoft Certified: Fabric Analytics Engineer Associate (exam DP-600) is an advantage.
- A Databricks certification, such as Databricks Certified Data Engineer Associate, is an advantage.
Desired Skills:
- Power BI
- DAX
- Power Query (M)
- Data modelling
- Databricks
- Semantic models
- Microsoft Fabric
Desired Qualification Level:
About The Employer: