Technical BI Lead

Open Box SoftwareCape TownJob.bopublished 11/17/2026
Must-have:PythonGitAzureDevOpsDataCI/CDAISecurityLead

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:
  1. DP-600
  2. PL-300
  3. 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.