Senior Data Engineer

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

Job summary

A leading UK financial services company seeks a Senior Data Engineer to take ownership of Azure data solutions and Power BI reporting. This high-impact role requires advanced expertise in Power BI and Azure Data Factory, as well as strong SQL skills. The successful candidate will lead the design and optimisation of ETL pipelines, develop scalable data models, and mentor junior engineers. Enjoy a flexible hybrid model with minimal office days (1-2 per month) and competitive benefits including a sector-leading pension and private medical insurance.

Benefits

Pension: 7% employer / 5% employee

Private Medical Insurance (optical & dental)

Group Income Protection (75% salary)

Death in Service (4x salary)

Critical Illness Cover (£10k)

25 days holiday rising to 28

Company bonus 8%

Qualifications

• Advanced Power BI expertise: datasets, DAX, modelling, governance.
• Expert-level Azure Data Factory for ETL/ELT pipelines.
• Strong experience in Azure Synapse with SQL pools.
• Deep proficiency in SQL and performance tuning.
• Track record of delivering Azure-based data engineering solutions.
• Mentoring or technical leadership experience preferred.

Responsibilities

• Lead design and optimisation of ADF ETL pipelines.
• Develop scalable Synapse Analytics data models.
• Own and enhance Power BI datasets and reporting standards.
• Shape cloud architecture across Azure Data Lake.
• Implement robust data quality and monitoring frameworks.
• Mentor junior data engineers and support engineering standards.

Skills

Advanced Power BI expertise

Expert-level Azure Data Factory

Strong Azure Synapse experience

Deep proficiency in SQL development

Solid understanding of Azure Data Lake

Proven track record delivering Azure-based solutions

Strong communication and stakeholder engagement

Demonstrated mentoring experience

Tools

Azure DevOps

Microsoft Fabric

ChatGPT or other automation tools

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 1-2 office days per month.

Benefits

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