Senior Data Engineer

Pioneer Search Ltd; City Of London; Hybrid; GBP 75,000 - 80,000; Full time

Benefits offered by this job

Hybrid work (3 days in London)

Job summary

Pioneer Search Ltd in London is seeking a Senior Data Engineer to join the Data Engineering function as it modernises the data platform with SQL Server, SSIS, and Microsoft Fabric. You will collaborate with the Lead Data Engineer to deliver scalable data solutions and support BI environments.

The role requires strong SQL/T-SQL, ETL development, and experience with data warehousing concepts, in an Agile London team. Hybrid work (3 days in-office) is offered with a £75k–£80k salary range.

Qualifications

• Strong commercial experience with Microsoft SQL Server and advanced T SQL.
• Hands-on experience developing, maintaining and debugging SSIS ETL pipelines.
• Strong understanding of data warehousing, dimensional modelling and Microsoft BI technologies.
• Exposure to Microsoft Fabric or similar modern Azure data platforms, with Fabric implementation desirable.
• Ability to take technical ownership and collaborate with engineers on decisions.
• Experience in Agile delivery environments.
• Experience with SSAS, SSRS, Azure Data Factory or Azure DevOps would be beneficial.
• Insurance or financial services experience advantageous but not required.

Responsibilities

• Develop, maintain and optimise data warehouse solutions using SQL Server and advanced T SQL.
• Develop and troubleshoot SSIS ETL pipelines, investigate production issues and improve performance.
• Play a key role in the planned implementation of Microsoft Fabric, transitioning workloads to the new platform.
• Support the existing Microsoft BI environment alongside the modernisation programme.
• Apply dimensional modelling and data warehousing principles to deliver reliable, 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 growth.

Skills

SQL Server

T SQL

SSIS

SSAS

SSRS

Data Warehousing

ETL

Kimball

Tools

Azure Fabric

Azure Data Factory

Azure DevOps

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 and implementation planned for 2027, you will work closely with the Lead Data Engineer to help deliver the modernisation whilst continuing to develop and support the existing SQL Server and SSIS environment.

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

The Role:

• Develop, maintain and optimise data warehouse solutions using SQL Server and advanced T SQL.
• Develop and troubleshoot SSIS ETL pipelines, investigating production issues, debugging SQL code and improving performance.
• 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 and data warehousing principles to support reliable, scalable data solutions.
• Work closely with the Lead Data Engineer, contributing technical ideas, challenging existing approaches and helping shape engineering decisions.
• Collaborate with stakeholders across the business to understand requirements and 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 and stored procedure development.
• Hands on experience developing, maintaining and debugging SSIS ETL pipelines.
• Strong understanding of data warehousing, dimensional modelling and Microsoft BI technologies.
• Experience optimising SQL queries, troubleshooting complex data issues and supporting production environments.
• 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 and 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 and 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 and the next generation of the data platform.

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

Desired Skills and Experience

• SQL Server
• T SQL
• SSIS
• SSAS
• SSRS
• Data Warehousing
• ETL
• Kimball

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 and industry news and 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

London | Hybrid Working (3 days) | £75,000 to £80,000 | Permanent