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 and 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 and optimise data warehouse solutions using SQL Server and T SQL.

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

• Support and enhance SSAS cubes and 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 and platform decisions.

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

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

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

Experience Required:

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

• Hands on experience developing complex SSIS ETL solutions.

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

• Strong understanding of data warehousing and Kimball dimensional modelling.

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

• Ability to take technical ownership and 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 and 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 and the prospect of helping shape a growing team.

For an experienced SQL Server and Microsoft BI Engineer looking to broaden their technical responsibilities and 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 and industry news and insights from us. To opt out of this, please contact: [email protected].

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.