We are looking for a skilled and proactive Data Engineer with strong expertise in 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.

Key Responsibilities

• 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.

KPMG's Governance, Risk and Compliance Services (GRCS) practice within IGH is an area of the firm with tremendous growth potential. GRCS is an integral part of our Enterprise Risk advisory practice. We provide services relating to internal audit, internal control, corporate governance, risk management and related assurance projects. Clients are based in the public sector and our services deliver added value to clients using modern control assessment, risk management and audit techniques focusing on strategic, management and operational issues as well as financial management and reporting controls. We also work closely with other consulting teams including our colleagues in Technology Risk and Cyber Risk to ensure our clients receive the best possible advice and assurance. 

You will be working on a range of projects in the water and energy network sectors. Your work will focus on cost assessment.

Our clients seek expert advice relating to cost and performance benchmarking. There is no ‘typical project’. You will need to apply a structured strategic approach to problem solving, drawing on established economic principles, while having the capacity to think creatively.

Our approach to benchmarking can involve econometric models comparing costs across companies. We also support clients through cost benefit analysis and other benchmarking approaches, such as unit cost models.

The projects that you will advise on will be high profile and varied. For example, in recent years we have advised nearly every water and energy network company on their price control reviews, been the lead advisor on several CMA appeals, and advised on major transactions within the sectors. We have the skills and capabilities to be involved in every major development within the sector.

The work will include a combination of report drafting, data collection/verification, economic analysis, econometric analysis, and engaging with clients.

You will also take a key role in developing the skills of more junior staff.

We have an exciting opportunity for a Manager to join our rapidly expanding Corporate Treasury Services team. Our team is focused on serving the world's leading Corporate Treasuries with their most complex business challenges. The team offer deep treasury expertise in financial products and markets, risk management, systems, governance, valuation and accounting. We work closely with other high impact functions within KPMG such as Audit, Risk Consulting and Management Consulting to provide a wide range of treasury advisory services.