Job Description

Senior Data Engineer Azure, Power BI, ADF, Synapse

Salary: £60,000£70,000 + excellent benefits
Location: Birmingham or London (12 days per month in office)
Employment: Full time

Join a leading and growing UK financial services company as a Senior Data Engineer, taking ownership of enterprise-grade Azure data solutions and advanced Power BI reporting.

This is a high-impact role for an experienced data engineer who wants technical leadership, architectural influence, and the chance to shape a modern cloud-based data platform built on Azure Data Factory, Synapse, Data Lake, and Microsoft Fabric.

The Role

As Senior Data Engineer, you will:

• Lead the design, build, and optimisation of Azure Data Factory (ADF) ETL pipelines
• Develop scalable Synapse Analytics data models and performance-optimised SQL workloads.
• Own and enhance Power BI datasets, semantic models, and reporting standards (major focus).
• Shape cloud data architecture across Azure Data Lake and Synapse environments.
• Play a key role in the organisations transition to Microsoft Fabric
• Implement robust data quality, validation, and monitoring frameworks
• Work closely with business and technology stakeholders to deliver high-value data solutions.
• Mentor junior data engineers and support engineering standards.
• Contribute to Agile delivery through Azure DevOps and CI/CD practices.

Key Skills & Experience

Essential:

• Advanced Power BI
  expertise: datasets, DAX, modelling, governance, performance tuning.
• Expert-level Azure Data Factory (ETL/ELT pipelines, automation, optimisation).
• Strong Azure Synapse experience: warehousing, SQL pools, query tuning, stored procedures.
• Deep proficiency in SQL development and optimisation.
• Solid understanding of Azure Data Lake and cloud storage layers.
• Proven track record delivering Azure-based data engineering solutions.
• Strong communication and stakeholder engagement.
• Demonstrated mentoring or technical leadership experience.

Desirable:

• Exposure to Microsoft Fabric
• Experience with AI/automation tools (Copilot, ChatGPT) or Azure Machine Learning.
• Experience working in financial services or another regulated industry

Why Apply?

• Senior, high-responsibility role with architectural influence.
• Modern Azure stack with Fabric adoption underway.
• Strong progression, visibility, and business impact.
• Flexible hybrid model: only 12 office days per month

Benefits

• Pension: 7% employer / 5% employee
• Private Medical Insurance (optical & dental)
• Flexible hybrid working requiring 1-2 days per month in office
• Group Income Protection (75% salary)
• Death in Service (4x salary)
• Critical Illness Cover (£10k)
• 25 days holiday rising to 28
• Company bonus 8%