Senior Data Engineer – SQL, SSIS & Fabric (London, Hybrid)

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

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.