Senior Data Engineer

Senior Data Engineer – Azure | Power BI | ADF | Synapse

£60,000–£70,000 + excellent benefits

Birmingham or London (1–2 days per month on-site)

Leading & Growing Financial Services Organisation

Are you an experienced Senior Data Engineer looking for a role where you can influence architecture, own enterprise data solutions, and shape the future of Azure analytics across a modern, cloud-first organisation?

A leading and growing financial services company is expanding its data engineering capability and seeking a Senior Data Engineer to take a key role in designing, delivering, and optimising Azure-based data solutions. This position is ideal for someone who wants real impact, technical ownership, and the chance to drive best practice in Power BI, Azure Data Factory, Synapse, and Microsoft Fabric.

Why This Role Stands Out

• You will be the technical lead for enterprise Azure data engineering.
• Power BI, semantic modelling, and reporting strategy form a core, high-visibility part of this role.
• You will shape best practice and mentor engineers in a supportive, growing team.
• Work with a modern Azure platform that is transitioning to Microsoft Fabric .
• Very flexible hybrid model: just 1–2 days per month on-site .

This role is designed for someone who enjoys solving complex data problems, thrives in a highly regulated environment such as financial services, and wants a platform for technical leadership.

What You’ll Be Doing

• Lead the end-to-end design and development of Azure Data Factory pipelines , ensuring scalable and reliable data integration.
• Build and optimise Azure Synapse Analytics models, SQL pools, and data warehousing solutions.
• Govern and enhance enterprise Power BI datasets, semantic models, DAX performance, and reporting standards .
• Influence the data architecture across Azure Data Lake and wider Azure services.
• Play a pivotal role in the organisation’s transition toward Microsoft Fabric .
• Implement best-in-class data validation, monitoring, and quality frameworks .
• Work closely with analysts, business stakeholders, and product teams to translate requirements into high-value data solutions.
• Mentor junior engineers, contribute to engineering standards, and champion continuous improvement.
• Operate within Agile delivery , using Azure DevOps, Git, and CI/CD pipelines.

What You’ll Bring

Essential Expertise:

• Advanced Power BI experience: enterprise modelling, datasets, DAX optimisation, performance tuning.
• Expert knowledge of Azure Data Factory ETL/ELT development.
• Strong proficiency in Azure Synapse Analytics , data warehousing, and SQL pools.
• Excellent SQL engineering capability across complex transformations and optimisation.
• Solid background with Azure Data Lake and cloud data architecture.
• Demonstrable experience delivering production-grade Azure data solutions.
• Clear communication skills and ability to influence technical and business teams.
• Experience mentoring or supporting junior data engineers.

Desirable Expertise:

• Exposure to Microsoft Fabric (pipelines, lakehouse, governance).
• Experience in financial services or another regulated industry .
• Familiarity with AI/automation tooling (Copilot, ChatGPT, Azure ML).

What’s on Offer

• Base salary: £60,000–£70,000
• Pension: 7% employer / 5% employee
• Private Medical Insurance (including optical & dental)
• Group Income Protection (75% of salary)
• Death in Service (4x salary)
• Critical Illness Cover (£10,000)
• 25 days holiday rising to 28
• Annual bonus: 8%
• A mature hybrid model: only 1–2 days required in office each month