Senior Data Engineer

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

Job summary

A leading UK financial services company is seeking a Senior Data Engineer to lead the design and optimization of Azure data solutions. This high-impact role offers responsibilities around Azure Data Factory ETL pipelines, Power BI datasets, and mentoring junior engineers. The position promotes a flexible hybrid work model with only 1-2 office days per month. Ideal candidates will have advanced Power BI expertise and strong experience with Azure Synapse and SQL development.

Benefits

Private Medical Insurance (optical & dental)

Flexible hybrid work model

Strong career progression

Qualifications

• Advanced expertise in Power BI including datasets and performance tuning.
• Strong experience with Azure Synapse and query optimization.
• Proficiency in SQL development and optimization.

Responsibilities

• Lead design and optimization of Azure Data Factory ETL pipelines.
• Develop scalable data models and SQL workloads.
• Own and enhance Power BI datasets and reporting standards.
• Shape cloud data architecture across Azure environments.
• Mentor junior data engineers and contribute to Agile delivery.

Skills

Advanced Power BI expertise

Strong Azure Synapse experience

Deep proficiency in SQL development

Understanding of Azure Data Lake

Strong communication skills

Technical leadership experience

Experience with Microsoft Fabric

Experience with AI/automation tools

Experience in financial services

Tools

Azure Data Factory

Azure DevOps

Job description

Overview

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

• Advanced Power BIexpertise: datasets, DAX, modelling, governance, performance tuning.
• 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.
• Strong communication and stakeholder engagement.
• Demonstrated mentoring or technical leadership experience.
• 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.
• Private Medical Insurance (optical & dental