Data Engineer

Ignite Digital; Birmingham; Hybrid; GBP 50,000 - 55,000; Full time

Job summary

A leading UK financial services company seeks a Data Engineer to develop Power BI solutions and enhance its Azure data platform. The role requires expertise in Power BI, Azure Data Factory, and SQL, with a primary focus on developing dashboards and ETL pipelines. Candidates should have a strong background in data engineering or BI development, and experience in a regulated industry is desirable. This position offers hybrid work with only 12 days in the office per month and excellent benefits including competitive salary and pension.

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

8% Company bonus

Qualifications

• Strong experience developing Power BI reports, dashboards, and data models.
• Hands-on expertise with Azure Data Factory ETL pipelines.
• Good SQL skills for analytics and optimisation.
• Experience using Git and Azure DevOps in Agile teams.
• 24 years experience in a Data Engineering or BI Development role.

Responsibilities

• Build and maintain Power BI dashboards and reports using DAX.
• Develop and maintain Azure Data Factory ETL/ELT pipelines.
• Work with Azure Synapse Analytics on modelling and optimisation.
• Support adoption and migration to Microsoft Fabric.
• Write and optimise SQL queries for reporting.

Skills

Power BI

Azure Data Factory

SQL

Azure Synapse

Agile

Git

Job description

Data Engineer Power BI, Azure Data Factory, Synapse

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

A leading and growing UK financial services company is seeking a Data Engineer to build Power BI reporting solutions and support the development of its Azure data platform.
This is an excellent opportunity for a mid-level engineer looking to deepen their Azure Data Factory, Synapse, and SQL experience while contributing to enterprise-wide MI and analytics.

The Role

You will:

• Build and maintain Power BI dashboards, reports, and data models using DAX and Power Query (key focus).
• Develop and maintain Azure Data Factory ETL/ELT pipelines.
• Work with Azure Synapse Analytics on modelling, optimisation, and BI-ready datasets.
• Support early adoption and migration to Microsoft Fabric.
• Write and optimise SQL queriesfor reporting, analysis, and data preparation.
• Collaborate with analysts, senior engineers, and business stakeholders.
• Contribute to data quality, documentation, and continuous improvement.
• Operate within Agile delivery using Azure DevOps and Git.

Key Skills & Experience

Essential

• Strong experience developing Power BI reports, dashboards, and data models.
• Hands-on expertise with Azure Data Factory ETL pipelines.
• Working knowledge of Azure Synapse modelling and performance tuning.
• Good SQL skills for analytics and optimisation.
• Understanding of Azure Data Lake structures.
• Experience using Git and Azure DevOps in Agile teams.
• 24 years experience in a Data Engineering or BI Development role.

Desirable

• Exposure to Microsoft Fabric.
• Experience in cloud-based BI/MI environments.
• Experience working in financial services or another regulated industry.

Why Apply?

• High-impact role combining data engineering and BI development.
• Fast-growing financial services environment with strong investment in data.
• Career progression within a modern Azure data ecosystem.
• Only 12 days per monthrequired in the office.

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
• 8% Company bonus