Overview

Lead Data Engineer - 107311

Base Location: Could be based at any one of our network of 20 offices nationally, but will require travel to client sites. The KPMG Technology + Data function delivers scalable data solutions and trusted to get it right first time.

What you will do

• Support clients in generating business value from digital solutions powered by SAP and Cloud technologies.
• Manage projects and workstreams on complex data cleanse and migration programs from strategy to execution.
• Support senior client stakeholders (CFO, CDO, CIO) to cultivate relationships as a trusted partner by articulating and realising the value of data.
• Design, develop, and maintain robust data pipelines and notebooks using Synapse Analytics and Microsoft Fabric.
• Build and optimise complex data transformation and ingestion logic to support enterprise-level reporting and analytics.
• Leverage Delta Lake architecture to support both batch and streaming data processes.
• Develop high-quality, reusable code in Python and PySpark, following best practices and ensuring maintainability.
• Create insightful, interactive reports and dashboards using Power BI.
• Use Git and Azure DevOps (ADO) for version control and deployment workflows.
• Continuously improve the performance, reliability, and scalability of data systems.
• Advocate for best practices in data governance, data quality, and documentation.

What you will need to do it

• In-depth experience with the Microsoft Azure Data Technology Stack, including Azure Data Factory, Synapse Analytics, Azure Data Lake Storage, and related tools.
• Microsoft Fabric – experience with dataflows, lakehouses, notebooks, and workspace management.
• Azure Synapse Analytics – pipeline and notebook creation, performance tuning, and data transformation logic.
• Power BI – data modelling, DAX, and visualisation development.
• Delta Lake – supporting structured streaming and batch data workloads.
• Python & PySpark – used for scalable data engineering solutions.
• Git / Azure DevOps (ADO) – version control, CI/CD, and collaboration in team-based environments.

Amazing extras

• Microsoft Certified: Azure Data Fundamentals
• Microsoft Certified: Azure Data Engineer Associate
• Microsoft Certified: Microsoft Fabric Analytics Engineer Associate
• Familiarity with real-time data processing using Azure Event Hubs or similar technologies.
• Exposure to data science or machine learning pipelines.
• Understanding of data security, GDPR, and compliance best practices.

Locations

We are open to talking to talent across the country, with core locations in London (Canada Square), Birmingham, Manchester, and Leeds. With 20 sites across the UK, remote, flexible hours, and part-time options may be possible. If you need flexibility, please discuss with our team.

Next steps

To discuss this or wider Technology roles with our recruitment team, please apply, create a profile, and upload your CV.