Senior Data Engineer

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

SQL Server | SSIS | SSAS | SSRS | Microsoft Fabric

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 for an experienced Microsoft BI & Data Warehouse Engineer to take on a senior technical role, working across an established SQL Server environment whilst helping shape the next stage of the business's data platform modernisation.

With Microsoft Fabric selected as the future platform, you will play a key role in supporting the existing data warehouse infrastructure whilst contributing to its evolution towards Fabric. The business is also investing in building its London Data Engineering team, with further growth planned, prior Fabric experience is not needed however you should be open to be trained on Fabric

The Role:

• Design, develop & optimise data warehouse solutions using SQL Server & T SQL.

• Develop & maintain ETL processes using SSIS, ensuring data quality & performance.

• Support & enhance SSAS cubes & SSRS reporting solutions.

• Apply Kimball dimensional modelling principles to data warehouse development.

• Act as a senior technical point of contact, working closely with the Lead Data Engineer on technical delivery & platform decisions.

• Work with stakeholders across Underwriting, Claims, Finance & MI to deliver data & reporting solutions.

• Contribute to the modernisation of the data platform & its planned transition towards Microsoft Fabric.

• Support the development & growth of the London Data Engineering capability.

Experience Required:

• Strong commercial experience with Microsoft SQL Server & advanced T SQL development.

• Hands on experience developing complex SSIS ETL solutions.

• Experience working with SSAS & SSRS in enterprise reporting environments.

• Strong understanding of data warehousing & Kimball dimensional modelling.

• Experience optimising SQL queries, stored procedures & ETL performance.

• Ability to take technical ownership & contribute to engineering decisions.

Exposure to Microsoft Fabric, Azure or Azure DevOps would be advantageous, although experience with the existing Microsoft BI stack is the immediate priority.

Experience within insurance or financial services would be beneficial, but candidates from other industries with strong Microsoft BI & Data Warehouse 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. You will take on a senior technical position with direct exposure to platform strategy, the opportunity to contribute to the adoption of Microsoft Fabric & the prospect of helping shape a growing team.

For an experienced SQL Server & Microsoft BI Engineer looking to broaden their technical responsibilities & gain exposure to modern cloud data technologies, this offers a strong next step.

Apply now or contact Pioneer Search for further information.

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: compliance@pioneer-search.com.

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.