Data Engineer

Canopius; Manchester; Hybrid; GBP 40,000 - 60,000; Full time

Job summary

A global specialty lines insurer in the UK is seeking a Data Engineer to enhance their data capabilities. The role will involve designing and maintaining data solutions using Azure Data Factory and Databricks. The ideal candidate will have strong T-SQL skills and experience in an Agile environment. This position offers a comprehensive benefits package and a hybrid working model, allowing candidates to thrive in their careers while receiving support for their wellbeing.

Benefits

Hybrid working

Competitive base salary

Non-contributory pension

Discretionary bonus

Health insurance

Dental cover

Qualifications

• Experience in developing data solutions and understanding relational databases.
• Familiarity with Agile delivery environment and CI/CD pipelines.
• Experience in insurance or financial services is desirable.

Responsibilities

• Design and maintain data solutions using Azure and Databricks.
• Provide technical guidance to development team.
• Create and maintain documentation of data transformations.

Skills

Data engineering

Strong T-SQL skills

Azure Data Factory

Azure Databricks

Agile methodologies

Analytical skills

Problem-solving skills

Education

Degree in a relevant field

Tools

Azure SQL Database

SQL Server Integration Services (SSIS)

Python

Job description

We are seeking a Data Engineer to work within our growing Data team to help shape and enhance our data capabilities. The role is to provide data engineering expertise to support delivery of our programme of work. This will include a broad range of initiatives, including Finance and Actuarial, Claims Augmentation utilising AI, and a number of Azure Data Platform and Databricks deliverables.

This role is an opportunity to apply your expertise in Azure, Databricks and data engineering techniques to business projects. It requires an in-depth technical knowledge combined with the ability to engage directly with senior business stakeholders in a range of our business domains.

The role will also involve supporting development activities on our legacy SQL Server data warehouses and aiding in the transition over to the Azure platform. The candidate should have experience of working in an Agile delivery environment.

The candidate will ideally have experience and knowledge of processes within insurance, and the ability to work directly with business stakeholders, understand business problems and deliver effective solutions. They should be comfortable collaborating and working as part of a dynamic multi-disciplinary team.

Responsibilities will include:

• Designing, developing and maintaining data solutions using components such as Azure Data Factory, Databricks, and Azure SQL Database
• Providing technical guidance and support to the development team as a senior member of the project development team.
• Assisting in creating and maintaining comprehensive documentation of data transformations, processes and systems
• Fostering communications and relationships between team members and stakeholders to ensure that expectations are managed and that teams are aligned
• Development of good internal client relationships
• Working to bridge any gaps between the offshore, third-party development team, the internal development team and business stakeholders on the project.
• Keeping abreast of developments and trends in data and reporting technology
• Planning, tracking and managing the progress of development activities in coordination with project managers and scrum masters.

Skills and experience:

• Experience in developing data solutions, demonstrating understanding of relational databases, common data warehousing concepts, ETL processes and data modelling
• Strong T-SQL skills with experience in querying and manipulating data
• Familiarity of working within an Agile delivery environment, leveraging tools including Kanban boards, repositories and CI/CD pipelines
• Strong analytical and problem-solving skills, with a keen eye for detail
• Experience with Azure Data Factory (ADF), or SQL Server Integration Services (SSIS)
• Experience with Azure Databricks and Python
• Experience with Master Data Services (MDS) are beneficial
• Insurance or other financial service experience is desirable, preferably within a Lloyd's Managing Agency

Including the following competencies:

• Stakeholder Engagement: Builds strong internal client relationships and fosters effective communication between team members, stakeholders and third-party partners to ensure expectations are managed and teams remain aligned.
• Collaboration and Teamwork: Works collaboratively within an Agile delivery environment, providing technical guidance to the development team and coordinating effectively with project managers and scrum masters to track and deliver development activity.
• Adapting to Change: Applies strong analytical and problem-solving skills to respond effectively to changing requirements, challenges and technical complexities as they arise.
• Continuous Improvement: Contributes to the ongoing improvement of data solutions by developing robust, well-documented processes and applying a strong understanding of data warehousing, ETL and data modelling best practices.
• Innovation: Designs and develops modern data solutions using Azure and related technologies, applying strong technical expertise to deliver effective, scalable and high-quality data platforms.
• Resilience: Demonstrates resilience by managing technical challenges, coordinating across multiple teams and stakeholders, and maintaining delivery focus within an Agile project environment.
• Future Focused: Maintains awareness of emerging trends and developments in data and reporting technologies, applying this knowledge to support future-ready data solutions.

About Us

Our benefits

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.

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.

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.