Lead Azure Data Consultant

KPMG UK; Manchester; Hybrid; GBP 65,000 - 85,000; Full time

Job summary

A leading consultancy firm in the UK is seeking a Lead Azure Data Consultant to help design and implement scalable data solutions. This role involves working closely with clients, optimizing data pipelines, and utilizing Microsoft Azure technologies. The ideal candidate will have extensive experience in data engineering and strong programming skills in technologies such as Python and Power BI. This position offers a flexible work environment with opportunities for both office and remote work.

Benefits

Flexible hours

Potential for remote work

Support for professional development

Qualifications

• Extensive experience leading client-facing consulting engagements using the Microsoft Azure Data Technology Stack.
• Hands-on Data Engineering experience using services such as Azure Data Factory and Synapse Analytics.
• Microsoft Fabric experience with dataflows, notebooks, and workspace management.

Responsibilities

• 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.
• Design, develop, and maintain robust data pipelines and notebooks.

Skills

Data Engineering

Microsoft Azure data ecosystem

Python

PySpark

Power BI

Tools

Azure Data Factory

Synapse Analytics

Delta Lake

Git

Azure DevOps

Job description

Lead Azure Data Consultant

Base Location

Could be based at any one of our network of 20 offices nationally, but will require travel to client sites.

https://kpmg.com/uk/en/about/offices.html

The KPMG Technology + Data function is a cornerstone of our business. We do work that matters to our local business and communities – supporting technical innovation and adoption of cutting‑edge solutions across the United Kingdom. Working on complex engagements including working closely with clients to design, implement, and manage scalable data solutions, this team is responsible for the delivery of cutting‑edge technical solutions and trusted to get it right first time.

KPMG is one of the world's largest and most respected consultancy businesses, we've supported the UK through times of war and peace, prosperity and recession, political and regulatory upheaval. We've proudly stood beside the institutions and businesses which make the UK what it is.

Why Join KPMG Data and AI Team

We are looking for a skilled and proactive Azure Data Consultant with strong hands on expertise in Data Engineering within the Microsoft Azure data ecosystem, including Microsoft Fabric, Synapse Analytics, and Delta Lake. This role requires hands‑on experience in building and optimising data pipelines and notebooks, transforming large datasets, and enabling data-driven decision‑making across the organisation.

The successful candidate will play a key role in designing and implementing scalable data solutions, collaborating with both technical and non-technical stakeholders, and helping shape our modern data architecture.

What will you be doing?

• 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 through articulating and realizing 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 will you need to do it?

• Extensive experience leading client‑facing consulting engagements using the Microsoft Azure Data Technology Stack.
• Hands‑on Data Engineering experience using services such as 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.

Skills we’d love to see / 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.

To discuss this or wider Technology roles with our recruitment team, all you need to do is apply, create a profile, upload your CV and begin to make your mark with KPMG.

Our Locations

We are open to talk to talent across the country, but the core locations for this team are in the following offices:

• London, Canada Square
• Birmingham
• Manchester
• Leeds

With 20 sites across the UK, we can potentially facilitate office work, working from home, flexible hours, and part‑time options. If you have a need for flexibility, please register and discuss this with our team.

Find out more

Within Tech and Engineering we have a range of divisions and specialisms. Click the links to find out more below:

• Technology and Engineering at KPMG: https://www.kpmgcareers.co.uk/experienced-professional/technology-engineering/
• IT's Her Future Women in Tech programme: https://www.kpmgcareers.co.uk/people-culture/it-s-her-future/
• KPMG Workability and Disability confidence: https://www.kpmgcareers.co.uk/experienced-professional/applying-to-kpmg/need-support-let-us-know/

For any additional support in applying, please click the links to find out more:

• Applying to KPMG: https://www.kpmgcareers.co.uk/experienced-professional/applying-to-kpmg/
• Tips for interview: https://www.kpmgcareers.co.uk/experienced-professional/applying-to-kpmg/application-advice/
• KPMG values: https://www.kpmgcareers.co.uk/experienced-professional/applying-to-kpmg/our-values/
• KPMG Competencies: https://www.kpmgcareers.co.uk/experienced-professional/applying-to-kpmg/kpmg-competencies/
• KPMG Locations and FAQ: https://www.kpmgcareers.co.uk/faq/?category=Experienced+professionals