Senior/Lead Fabric Data Engineer (Microsoft Fabric, Lakehouse, Data Factory, Power BI/DAX) (Remote – Cape Town preferred)

ENVIRONMENT

• A global digital transformation consultancy and software solutions provider is currently seeking a Data Engineer who works comfortably at both ends of the delivery spectrum.
• You will design the data architecture that an enterprise depends on, and you will also build the pipelines that make it work. The role spans three types of engagement: migrating existing estates onto Microsoft Fabric, modernising platforms that have outgrown their original design, and standing up greenfield Fabric implementations from a blank sheet.
• Microsoft Fabric is a firm requirement for this position. Candidates without demonstrable, hands-on Fabric delivery experience will not be considered.
• You will work directly with client stakeholders, so the ability to explain architectural trade-offs to a technical audience and
• to a business audience is as important as the engineering itself.

DUTIES

• Design and document data architecture for enterprise clients, covering medallion patterns, domain driven design and governance frameworks.
• Build and orchestrate ingestion and transformation pipelines, with a bias towards metadata driven approaches that scale beyond a single project.
• Lead migration and modernisation work, moving workloads from platforms such as Teradata and on premises SQL Server into Fabric and Azure.
• Deliver end to end Fabric implementations across Lakehouse, Warehouse, Data Factory, OneLake and Real Time Intelligence.
• Build and tune Power BI semantic models, including DAX, row level and object level security, and deployment pipelines.
• Establish CI/CD for data platforms, including source control, branching strategy, automated deployment and environment promotion.
• Apply AI native engineering practices to accelerate delivery, including agentic workflows and the Model Context Protocol.
• Set technical standards and review the work of other engineers. At Lead level, this includes owning the technical direction of an engagement and mentoring the delivery team.

REQUIREMENTS

Core skills

• Microsoft Fabric, end to end Lakehouse, Warehouse, Data Factory, OneLake and Real Time Intelligence.
• Power BI Semantic models, DAX, row level security and object level security, deployment pipelines, and performance tuning.
• Data architecture Medallion patterns, domain driven design, and governance frameworks.
• Data engineering Metadata driven ingestion, ETL and ELT orchestration, and CI/CD for data platforms.
• Migration and modernisation Moving Teradata and on premises SQL estates onto Fabric and Azure, including assessment, sequencing, reconciliation and cutover.
• AI native data engineering Agentic workflows, the Model Context Protocol, and the use of Claude Code on Fabric.

Technologies

• Microsoft Fabric · Power BI · Azure Synapse · OneLake · Data Factory · DAX · T SQL · Spark · Azure DevOps · Git · MCP

Nice to have

• Experience designing and delivering training, whether formal client enablement sessions, internal upskilling, or structured handover to a client team at the end of an engagement. This carries real weight for us, because a large part of the value they leave behind is a client team that can operate the platform without us.
• Relevant Microsoft certifications in the Fabric, Azure data or Power BI tracks.
• Experience in a consulting or client facing delivery environment.
• Exposure to data governance tooling such as Microsoft Purview.

What they look for beyond the technology

• Clear written communication. Much of the role is remote, and decisions need to survive being read rather than explained in person.
• Comfort with ambiguity at the start of an engagement, and the discipline to reduce it quickly.
• A willingness to be challenged on architectural decisions, and to challenge others in turn.