Senior Data Engineer

Join to apply for the Senior Data Engineer role at Canopius Group

The purpose of this role is to bring data engineering expertise to a growing Data team supporting a diverse programme of work. Initiatives span Finance, Actuarial and Claims Augmentation utilising AI, and deliver on Azure Data Platform and Databricks deliverables.

• 
  
• Develop data solutions on the Microsoft Azure platform.
  
• Provide technical guidance and support to the development team as a senior member of the project development team.
  
• Working to bridge any gaps between the offshore, third-party development team, the internal development team and business stakeholders on the project.
  
• Planning, tracking and managing the progress of development activities in coordination with project managers and scrum masters.
  
• Fostering communications and relationships between team members and stakeholders to ensure that expectations are managed and that teams are aligned.
  
• Ensuring that new solutions are tested and documented as required.
  
• Development of good internal client relationships.
  
• Management of own task list and ensuring that plans are agreed.
  

• 
  
• Extensive experience designing, developing and maintaining enterprise-scale data solutions, with a deep understanding of relational databases, data warehousing concepts, ETL processes and data modelling techniques.
  
• Advanced T-SQL expertise, including writing, optimising and maintaining complex queries and stored procedures to support large-scale data transformations.
  
• Proven experience delivering data solutions within an Agile delivery environment, actively contributing to planning, estimation and delivery using tools such as Kanban boards, repositories and CI/CD pipelines.
  
• Strong analytical and problem-solving skills, with the ability to diagnose complex data issues and implement effective, scalable solutions.
  
• Significant experience with Azure Data Factory (ADF) and/or SQL Server Integration Services (SSIS) to build, optimise and support robust data integration pipelines.
  
• Hands‑on experience with Azure Databricks and Python for large‑scale data processing, transformation and analytics workloads.
  
• Experience with Master Data Services (MDS) is beneficial, including contributing to data governance and consistency across enterprise datasets.
  
• Insurance or other financial service experience is desirable, preferably within a Lloyd’s Managing Agency.
  

• 
  
• Stakeholder Engagement: Demonstrates an understanding of London Market insurance data, processes and terminology, and has experience supporting internal Analytics and reporting functions to meet business needs.
  
• Collaboration and Teamwork: Works effectively within Agile and Scrum environments, collaborating with others using Azure DevOps, Git and CI/CD pipelines to support coordinated and reliable delivery.
  
• Adapting to Change: Shows adaptability when working with evolving technologies and requirements, including contributing to projects implementing AI functionality where appropriate.
  
• Continuous Improvement: Applies a thorough understanding of database structures, data warehousing, dimensional modelling and ETL processes to design, optimise and maintain efficient and reliable data solutions.
  
• Innovation: Develops and supports enterprise‑scale data solutions in a cloud‑hosted environment, using Azure technologies such as Databricks and Azure SQL Database to deliver modern, scalable platforms.
  
• Resilience: Demonstrates confidence and positivity when working through technical challenges, maintaining a constructive and professional approach to problem‑solving.
  
• Future Focused: Brings proactive thinking to data projects within Finance and Actuarial domains, contributing to forward‑looking solutions that support evolving business and analytical needs.
  

We offer all employees a comprehensive benefits package that focuses on their whole wellbeing. This includes hybrid working, a competitive base salary, non‑contributory pension, discretionary bonus, insurances including health (family) and dental cover, and many other benefits to enhance financial, physical, social and psychological health.

Canopius is a global specialty lines (re)insurer. We are one of the leading insurers in the Lloyd’s of London insurance market with offices in the UK, US, Singapore, Australia and Bermuda. At Canopius we foster a distinctive, positive culture which enables us to bring our whole selves to work to flourish as people, and build a business which delivers profitable, sustainable results. Based in incredible new offices in the heart of the City of London, Canopius operates a flexible, hybrid working model and is committed to providing an environment that challenges employees to be their best and where everyone's unique contributions are recognised, valued and respected.

We are fully committed to equal employment opportunities for all applicants and providing employees with a work environment free of discrimination and harassment. All employment decisions are made regardless of age, sex, gender identity, ethnicity, disability, sexual orientation, socio‑economic background, religion or beliefs, marital or caring status, or any other status protected by the laws or regulations in the locations where we operate. We encourage and welcome applicants from all diverse backgrounds. We make reasonable adjustments throughout the recruitment process and during employment. Please let us know if you require any information in an alternate format or any other reasonable adjustments.