Senior Data Engineer

Ignite Digital; Greater London; Hybrid; GBP 60,000 - 70,000; Full time

Job summary

A leading UK financial services company seeks an experienced Senior Data Engineer to take ownership of Azure data solutions and reporting. This role offers significant architectural influence and the chance to shape a cloud-based data platform. Responsibilities include building ETL pipelines, developing data models, and mentoring junior engineers. The position features a flexible hybrid model with only 12 office days per month and excellent benefits, including private medical insurance, pension contributions, and a company bonus.

Benefits

7% employer pension contribution

Private Medical Insurance

Flexible hybrid working

Group Income Protection

Death in Service benefit

Critical Illness Cover

25 days holiday rising to 28

Company bonus of 8%

Qualifications

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

Responsibilities

• Lead the design, build, and optimization of Azure Data Factory ETL pipelines.
• Develop scalable Synapse Analytics data models and SQL workloads.
• Enhance Power BI datasets and reporting standards.
• Shape cloud data architecture across Azure Data Lake.
• Play a key role in the transition to Microsoft Fabric.
• Implement data quality, validation, and monitoring frameworks.
• Work closely with business and technology stakeholders.
• Mentor junior data engineers and support engineering standards.
• Contribute to Agile delivery through Azure DevOps and CI/CD practices.

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%