Oversee the design, development and maintenance of a modern, scalable and reliable data systems architecture capable of storing large volumes of information. Utilise a variety of techniques to integrate and maintain data from different sources and extract valuable information from large-scale data, supporting decision-making processes effectively and efficiently. About Canopius 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. 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. The purpose of the role is to provide data engineering expertise within a growing Data team, supporting the delivery of a diverse programme of work. This includes initiatives across Finance and Actuarial, Claims Augmentation utilising AI, and a range of Azure Data Platform and Databricks deliverables. This role provides an opportunity to apply strong expertise in Azure, Databricks and modern data engineering techniques to business-led projects. It requires in-depth technical knowledge alongside the ability to engage directly with senior business stakeholders across multiple business domains. While the role primarily focuses on development and delivery within the Azure platform, it will also involve supporting development activities on legacy SQL Server data warehouses and contributing to the ongoing transition and optimisation of these solutions within Azure. Due to the nature of the projects at Canopius, the role is suited to an experienced data engineer who is motivated by technical challenge and enthusiastic about using technology to drive meaningful change within the insurance industry. The ideal candidate will have strong experience and knowledge of insurance processes, with the ability to work closely with business stakeholders to understand problems and deliver effective, data-driven solutions. They will be comfortable collaborating as part of a dynamic, multi-disciplinary team and working within an Agile delivery environment. Responsibilities will include: Developing data solutions on the Microsoft Azure platform. Providing 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. Skills and experience: 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 Including competencies: 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.