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 Dev Ops, 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.…