Senior Data Engineer – Insurance - Snowflake, Dbt

Arthur Recruitment; Greater London; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

Arthur Recruitment is seeking a talented Data Engineer to join a well-known Broker in London. This hybrid role involves collaborating across teams, working with modern data tooling, and building scalable data solutions. Key expertise includes Snowflake, dbt, and SQL Server, with a focus on the insurance sector. Candidates should have experience with Azure technologies, data governance, and strong problem-solving skills. The position offers a flexible work model with two days onsite each week.

Qualifications

• Previous experience as a Data Engineer in insurance.
• Hands-on expertise with Snowflake, dbt, Fivetran, Dataiku, and ideally Collibra.
• Working knowledge of Azure technologies such as Synapse and DevOps.
• Experience with Microsoft SQL Server stack including MDS, SSIS, SSAS, and SSRS.
• Familiarity with programming languages like Python and C# (preferred).

Responsibilities

• Collaborate across teams and work with modern data tooling.
• Help shape the data landscape that supports the business.
• Build and maintain data pipelines across varied data sources.
• Troubleshoot discrepancies and performance issues.
• Ensure compliance with data governance and GDPR practices.

Skills

SQL Server Expertise

Data Warehousing & Modelling

ETL / ELT Processes

Problem-Solving

Security & Compliance

Industry Understanding

Tools

Snowflake

dbt

Fivetran

Dataiku

Collibra

Azure Synapse

Azure DevOps

Microsoft SQL Server

MDS

SSIS

SSAS

SSRS

Python

C#

Job description

Hybrid • 2 days onsite (London City office)

Overview

We’re looking for a talented Data Engineer to join a well-known Broker that designs, builds, and delivers robust, scalable data solutions. You’ll collaborate across teams, work with modern data tooling, and help shape the data landscape that underpins our business.

Hands-on expertise with Snowflake and dbt is key for this role.

This position is hybrid and based in the London City office, with two days onsite each week.

How You’ll Make an Impact

SQL Server Expertise

• Deep knowledge of Microsoft SQL Server and SQL
• Ability to query, optimise, and manage large datasets

Data Warehousing & Modelling

• Strong understanding of data warehouse principles
• Skilled in modelling concepts including normalization/denormalization

ETL / ELT Processes

• Experience building and maintaining pipelines across varied data sources

Problem-Solving

• Comfortable troubleshooting discrepancies and performance issues
• Collaborative approach to resolving user data challenges

Security & Compliance

• Awareness of data governance, GDPR, and secure data handling practices

Industry Understanding

• Experience working with data in the insurance sector

About You

You’ll bring:

• Previous experience as a Data Engineer in insurance
• Hands-on expertise with Snowflake, dbt, Fivetran, Dataiku, and ideally Collibra
• Working knowledge of Azure technologies such as Synapse and DevOps
• Experience with Microsoft SQL Server stack including MDS, SSIS, SSAS, and SSRS
• Familiarity with programming languages like Python and C# (preferred)