Search thousands of fresh jobs

×
This job is expired
DCV Sabenza IT and Recruitment

Power BI - Lead Consultant at Sabenza IT & Recruitment

DCV Sabenza IT and Recruitment

  • R01 - R02 per month
  • Permanent Executive position
  • Cape Town
  • Posted 10 Nov 2026 by DCV Sabenza IT and Recruitment
  • Expires in 24 days
  • Job 2647162 - Ref 878000029577410
Apply Now

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:

  • Degree

About The Employer:


Apply Now

DCV Sabenza IT and Recruitment

About the agency

Dedicated to the recruitment of IT professionals Sabenza iT is a South African registered business focusing on Finance, Engineering, SAP and general iT recruitment. We have over 18 years' experience in recruiting in South Africa, Australia, Europe, South America and Asia and have worked with a number of large companies offering the best service. We at Sabenza iT understands the changing market and we mold our services around each of our client's needs to offer a personal service. Sabenza iT has forged strong relationships with both Clients and Consultants by ensuring both parties get the most out of every placement. Our Head Office is based in South Africa and we have a satellite office in the UK so that we can keep in contact with expats who may consider returning to South Africa and so that we can offer our services globally for Consultants looking to go to South Africa and Consultants who are looking for opportunities abroad. We at Sabenza recognize the difference it makes to maintain good client relationships and we are keeping our client base niche and manageable in order to give the best service possible. We have gained a good reputation in the market place and have built a very large network and database of consultants that we draw from for each role. We are able to send applications within 24 hours of receiving a role profile or spec. We use one of the best Database software tools available to keep our database up to date and very fast to search. Sabenza iT does not only use job-sites, we headhunt and we use our network to find our clients the right Candidates. We have a strong Facebook presence and we have over 12,000 LinkedIn connections. For further information, please visit our website www.sabenzait.co.za or call me at any time on Tel: 0330040131.

Receive a daily digest of all new jobs matching this job. Your information is safe with us and you can cancel any time.

Expires in 24 days

Email me jobs similar to: Power BI - Lead Consultant at Sabenza IT & Recruitment

Receive a daily digest of all new jobs matching this job: Senior IT Auditor. Your information is safe with us and you can cancel at any time.