Technical BI Lead

Open Box Software

Cape Town

On-site

ZAR 900,000 - 1,700,000

Full time

2 days ago
Be an early applicant

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

Open Box Software is seeking a Technical BI Lead to own design and quality of Power BI and Microsoft Fabric solutions on client engagements. You will lead developers, mentor the team, and be the technical voice with clients throughout delivery.

The role is hands-on (roughly 60%), with 25% leading and reviewing, and 15% client interaction. You will work on international projects with US and UK clients, applying strong engineering standards.

Qualifications

  • 7+ years in BI or data platform delivery.
  • 2+ years leading or mentoring developers.
  • 4+ years on the Microsoft data platform with end-to-end Fabric delivery.
  • Expert T-SQL and DAX with Python, Kimball modelling and ETL/ELT design.
  • Git-based source control and CI/CD applied to data development.
  • Strong English communication and client-facing consulting experience.
  • Snowflake experience is a strong advantage.

Responsibilities

  • Own BI solution design on engagements and act as technical reference for the team.
  • Hands-on build of semantic models, DAX measures, pipelines and lakehouse objects.
  • Turn business requirements into Power BI reports with reliable Fabric integration.
  • Lead code reviews and ensure engineering standards are consistently applied.
  • Engage in AI-assisted delivery and validate outputs to clients.
  • Lead technical conversations with clients and translate decisions for non-technical audiences.
  • Mentor developers, allocate work and review team output.
  • Deliver by managing backlog, dependencies and risks, ensuring compliance.

Skills

BI leadership
Team mentoring
Client communication
Data modelling
DAX
T-SQL
Python
Git CI/CD

Education

Relevant degree or equivalent experience
Certifications (DP-600, PL-300, DP-700)

Tools

Power BI
Microsoft Fabric
Snowflake
Databricks
Azure Data Services

Job description

Open Box Software is a global leader in the Proptech market. With a team of experienced technical, analytical and business intelligence experts, Open Box has become a key partner to some of the most effective property companies in the world through our suite of services, solutions and software partnerships. Our Data & Analytics division helps some of the world’s largest real estate businesses make better decisions with their data. We're looking for a Technical BI Lead to own the design and quality of Power BI and Microsoft Fabric solutions on client engagement leading the developers building them, and to be the technical voice to the client throughout delivery.

A hands-on role made up of roughly 60% building (semantic models, DAX, pipelines, lakehouse and warehouse objects), 25% leading and reviewing the team's work, and 15% with clients on requirements and technical decisions. You'll mentor the developers on your engagements, oversee and ensure the engineering standards they work to are consistently applied, estimate the team's tasks and give technical input to proposals. You will work on international projects with leading US and UK clients built around their needs.

Responsibilities
  • Solution design: own the design of BI solutions on your engagements and act as the technical reference for the team, within the patterns set by our Data Architect.
  • Hands-on build: design Kimball dimensional models, including slowly changing dimensions, build semantic models, DAX measures, pipelines and lakehouse or warehouse objects on Microsoft Fabric, tune performance and implement relevant security.
  • Reporting: turn business requirements into clear Power BI reports, on semantic models designed so that Copilot and Fabric Data Agents give reliable answers as well.
  • Engineering practice: lead code review, apply (DevOps) Git-based source control and CI/CD to all relevant assets, and keep code and documentation to a consistent standard.
  • AI-assisted delivery: use AI tools as a normal part of development and documentation, and hold the team to the same validation and review standard however code was produced.
  • Client leadership: lead technical conversations with clients directly, explain technical decisions plainly to non-technical audiences, and know when to say “not yet”.
  • Mentoring: allocate and review the team's work, mentor developers and grow their capability.
  • Delivery: manage the backlog, dependencies and risks on your engagement, estimate at task level, give technical input to proposals as well as classify and handle sensitive data correctly to maintain the requisite compliance requirements.
Tech stack you’ll use
  • Microsoft Fabric: Lakehouse, Warehouse, Data Factory pipelines, Dataflows Gen2, Notebooks, OneLake, Direct Lake & deployment pipelines
  • Power BI: semantic models, DAX, Power Query, row-level security
  • T-SQL, DAX, KQL, Python / PySpark, Azure DevOps and Git
  • Microsoft Azure data services: Data Factory, Data Lake Storage, Azure SQL, Synapse (migration work), Key Vault
  • Power BI Copilot, Fabric Data Agents and AI-assisted development tools (Git Hub Copilot)
  • Snowflake (a strong advantage), Microsoft Purview, Databricks, dbt and Power Platform (beneficial)
Requirements
  • 7+ years in BI or data platform delivery.
  • 2+ years leading or mentoring developers, including allocating and reviewing work.
  • 4+ years on the Microsoft data platform, with end-to-end Fabric delivery on at least one production engagement.
  • Expert T-SQL and DAX skills with working proficiency in Python, solid Kimball dimensional modelling and ETL/ELT design.
  • Git-based source control and CI/CD applied to data development.
  • Evidence of leading technical conversations directly with clients, in excellent written and spoken English. Consulting experience is a strong advantage.
  • Snowflake is a strong advantage: implementing, modelling, tuning, migration.
  • A relevant degree, or equivalent experience with industry certifications being advantageous:
  • DP-600
  • PL-300
  • DP-700 or SnowPro Core an advantage
Personal traits
  • Ownership: you own outcomes on your engagement, not just your tasks.
  • Problem solver: you diagnose before you build and prefer the simple fix that works.
  • Mentor: you make the people around you better and are generous with credit.
  • Plain communicator: ability to explain technical decisions simply to non-technical clients.
  • Organised: you keep several threads moving without dropping quality.
  • Curious: you keep learning without being asked, including AI tooling.
  • Detail-oriented: you care about accuracy and getting things right.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Business Intelligence Developer
Business Intelligence Developer

Watershed Consulting • Johannesburg

Hybrid
ZAR 600,000 - 900,000
Senior Data Fabric Data Engineer
Senior Data Fabric Data Engineer

Belay Talent Solutions • Midrand

Hybrid
ZAR 1,200,000 - 1,900,000
Power BI - Lead Consultant
Power BI - Lead Consultant

Sabenza IT & Recruitment • Cape Town

On-site
ZAR 900,000 - 1,200,000
Senior BI Lead - Power BI & Fabric Solutions
Senior BI Lead - Power BI & Fabric Solutions

Open Box Software • Cape Town

On-site
ZAR 900,000 - 1,700,000
BI Analyst II (Contract)
BI Analyst II (Contract)

The Focus Group • Sandton

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

JVR Software • Pretoria

Remote
ZAR 600,000 - 900,000
BI Analyst
BI Analyst

Korridor Holdings Limited • Centurion

On-site
ZAR 550,000 - 850,000
Senior Analytical Engineer | Bryanston / Centurion | Permanent
Senior Analytical Engineer | Bryanston / Centurion | Permanent

Edge Executive Search Group • Johannesburg

On-site
ZAR 900,000 - 1,500,000
Senior Analytical Engineer | Bryanston / Centurion | Permanent
Senior Analytical Engineer | Bryanston / Centurion | Permanent

Edgexec • Johannesburg

On-site
ZAR 850,000 - 1,250,000
Analytics Engineer (Business Intelligence & Reporting)
Analytics Engineer (Business Intelligence & Reporting)

Network Finance • Gauteng

On-site
ZAR 700,000 - 1,100,000