Senior Data Engineer

Pioneer Search Ltd; Greater London; On-site; GBP 70,000 - 100,000; Full time

Job summary

Pioneer Search Ltd is seeking a Senior Data Engineer in London to join the data engineering function. The role focuses on SQL Server, T-SQL, SSIS, and data warehousing, with a major push to adopt Microsoft Fabric in 2027.

You will work closely with the Lead Data Engineer and cross-functional teams to modernise and support the data platform. The successful candidate will combine strong SQL/data warehousing expertise with hands-on experience in Azure-based data platforms and an Agile delivery

Qualifications

• Strong commercial experience with Microsoft SQL Server, advanced T-SQL & stored procedure development.
• Hands-on experience developing, maintaining & debugging SSIS ETL pipelines.
• Strong understanding of data warehousing, dimensional modelling & Microsoft BI technologies.
• Exposure to Microsoft Fabric or similar modern Azure data platforms, with Fabric implementation experience desirable.
• Ability to take technical ownership and contribute ideas with engineers on decisions.
• Experience working within Agile delivery environments.

Responsibilities

• Develop, maintain & optimize data warehouse solutions using SQL Server & advanced T-SQL.
• Play a key role in planned Microsoft Fabric implementation, transitioning workloads to the new platform.
• Support existing Microsoft BI environment alongside the modernization programme.
• Apply dimensional modelling & data warehousing principles to deliver scalable data solutions.
• Collaborate with the Lead Data Engineer and stakeholders to shape engineering decisions.
• Deliver engineering work within an Agile environment and contribute to London Data Engineering team development.

Skills

SQL Server

T-SQL

Dimensional modelling

Data warehousing

Agile delivery

Stakeholder collaboration

Tools

SSIS

SSAS

SSRS

Azure Data Factory

Azure DevOps

Microsoft Fabric

Job description

Microsoft Fabric | SQL Server | T SQL | SSIS | Data Warehousing

A leading specialist insurance business is looking for a Senior Data Engineer to join its established Data Engineering function as it expands its presence in London.

This is an opportunity to take a senior technical role in a business with a significant investment in its data platform. With Microsoft Fabric selected, budget approved & implementation planned for 2027, you will work closely with the Lead Data Engineer to help deliver the modernisation whilst continuing to develop & support the existing SQL Server & SSIS environment.

The business is looking for someone who combines strong SQL & data warehouse engineering experience with an understanding of modern data platforms, ideally having already contributed to a Microsoft Fabric implementation.

The Role:

Develop, maintain & optimise data warehouse solutions using SQL Server & advanced T SQL.

Play a key role in the planned implementation of Microsoft Fabric, helping transition existing data workloads towards the new platform.

Support the existing Microsoft BI environment alongside the modernisation programme.

Apply dimensional modelling & data warehousing principles to support reliable, scalable data solutions.

Work closely with the Lead Data Engineer, contributing technical ideas, challenging existing approaches & helping shape engineering decisions.

Collaborate with stakeholders across the business to understand requirements & deliver data solutions.

Deliver engineering work within an Agile environment, contributing to the development of the London Data Engineering team.

Experience Required:

Strong commercial experience with Microsoft SQL Server, advanced T SQL & stored procedure development.

Hands on experience developing, maintaining & debugging SSIS ETL pipelines.

Strong understanding of data warehousing, dimensional modelling & Microsoft BI technologies.

Exposure to Microsoft Fabric or similar modern Azure data platforms, with previous hands on Fabric implementation experience particularly desirable.

Ability to take technical ownership, contribute ideas & work closely with other engineers on technical decisions.

Experience working within Agile delivery environments.

Experience with SSAS, SSRS, Azure Data Factory or Azure DevOps would be beneficial.

Insurance or financial services experience would be advantageous, although candidates from other industries with relevant technical experience are equally encouraged to apply.

Why Apply?

This is an opportunity to join a growing London Data Engineering function at an important stage of its development.

Unlike organisations still considering their future data strategy, this business has already secured approval & investment for its Microsoft Fabric implementation in 2027.

You will have a genuine opportunity to contribute to the delivery of that programme, working across both established SQL Server technologies & the next generation of the data platform.

The position offers significant technical responsibility, close involvement in engineering decisions & the opportunity to help shape a growing team.

Data & Application Notice

We process personal data submitted as part of your application for recruitment purposes in line with UK GDPR. All applications are reviewed by a member of our team, we do not use automated decision-making in our selection process.
Your application will be assessed against the requirements of this role.

By applying to this advert, you consent to receiving future relevant roles & industry news & insights from us. To opt out of this, please contact: [e-mail].

For more information on how we use your data, including how long we retain it & your rights, please refer to our Privacy Policy: www.pioneer-search.com/privacy-policy.

Senior Data Engineer • City of London, London