Power BI - Lead Consultant

Sabenza IT & Recruitment

Cape Town

On-site

ZAR 900,000 - 1,200,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Sabenza IT & Recruitment in Cape Town seeks a Power BI Lead Consultant to design and deliver high-performance semantic models and reports. You will craft enterprise-scale data models using DAX and Power Query, connect Power BI to Databricks, and drive governance, efficiency, and cost optimisation.

The role emphasizes advanced modelling, query folding, and capacity planning, with responsibility for security, deployment pipelines, and lifecycle management.

Qualifications

  • Degree in Computer Science, Information Systems, Engineering or related field.
  • Microsoft Fabric Analytics Engineer knowledge is a plus.
  • Databricks certification is advantageous.

Responsibilities

  • Design, build and maintain Power BI semantic models and reports with a focus on performance and cost.
  • Develop data models using DAX and Power Query (M) with well-structured star schemas.
  • Optimize models via aggregations, incremental refresh, and storage-mode choices.
  • Connect Power BI to Databricks and other large-scale sources; ensure reliability and governance.
  • Enforce modelling standards, security (row-level) and deployment pipelines.
  • Review and improve models for performance, cost, and technical consistency.

Skills

Power BI
Advanced DAX
Power Query
Star Schema
Databricks

Education

BSc in CS/IS/Engineering

Tools

Databricks
Power BI Desktop

Job description

Cape Town, South Africa | Posted on 10/11/2026

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: Fabric Analytics Engineer Associate (exam DP-600) is an advantage.
  • A Databricks certification, such as Databricks Certified Data Engineer Associate, is an advantage.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Power BI Consultant
Power BI Consultant

Sabenza IT & Recruitment • Cape Town

On-site
ZAR 600,000 - 900,000
Power BI Consultant
Power BI Consultant

Sabenza IT & Recruitment • Wes-Kaap

On-site
ZAR 600,000 - 900,000
Power BI Lead Architect: Performance & Scale
Power BI Lead Architect: Performance & Scale

Sabenza IT & Recruitment • Cape Town

On-site
ZAR 900,000 - 1,200,000
Power Bi Developer / Specialist (Contract)
Power Bi Developer / Specialist (Contract)

PBT Group • Johannesburg

Hybrid
ZAR 600,000 - 900,000
Power BI Developer
Power BI Developer

Synergy AI (Pty) Ltd • Stellenbosch

On-site
ZAR 334,800 - 446,400
Data / Bi Engineer
Data / Bi Engineer

Sabenza It & Recruitment • Cape Town

On-site
ZAR 600,000 - 800,000
Analytics Engineer (Business Intelligence & Reporting)
Analytics Engineer (Business Intelligence & Reporting)

JVR Software • Pretoria

Remote
ZAR 600,000 - 900,000
Power Bi Developer
Power Bi Developer

PBT Group • Johannesburg

On-site
ZAR 480,000 - 780,000
Power BI Consultant: Data Models & User Enablement
Power BI Consultant: Data Models & User Enablement

Sabenza IT & Recruitment • Cape Town

On-site
ZAR 600,000 - 900,000
Power BI Analyst/ Developer
Power BI Analyst/ Developer

PTY • Centurion

Hybrid
ZAR 765,000 - 935,000