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: 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.
Senior Data Engineer
London | Hybrid Working (3 days) | £75,000 to £80,000 | Permanent
#J-18808-Ljbffr
Senior Data Engineer in City of London employer: Pioneer Search Ltd
Pioneer Search Ltd is an excellent employer, offering a dynamic work culture that fosters innovation and collaboration in the heart of London. Employees benefit from flexible hybrid working arrangements, competitive remuneration, and opportunities for professional growth within a rapidly evolving insurance sector, making it an ideal place for those seeking meaningful and rewarding careers in IT auditing.
