Power BI - Lead Consultant
Cape Town, South Africa1w ago
Key details
- Location
- Cape Town, South Africa
- Work style
- Hybrid
- Level
- Senior
- Job type
- Full-time
- Function
- Operations & Strategy
- Focus area
- other
- Posted
- 1w ago
Skills
cost controldata modelingdatabricksdatabricks certifiedmicrosoft fabricpower bipower query
About the role
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.
Requirements
Key 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.
How well do you match this job?
Skills
Experience
Level
Title
Location
Salary
Freshness
Similarity
Free account needed to apply or save. It takes a minute, and we'll bring you right back to this job.