Data Engineer

ea Change; Greater London; Hybrid; GBP 72,000 - 94,000; Full time

Job summary

ea Change is seeking a Senior Snowflake Data Engineer to help expand a Snowflake enterprise data platform for London Market Insurance. This remote UK role runs on 3-week sprints with daily stand-ups and reports to the Data Engineer Lead.

You will design and build Snowflake pipelines, model across layers (Raw, Curated, Gold) and optimise costs while ensuring data quality and governance. Experience in UMRs, bordereaux and Lloyd's vs company market is essential.

Qualifications

• 2+ years hands-on production Snowflake—Tasks and Streams, RBAC, cost optimisation, metadata management.
• 5+ years London Market insurance domain understanding (UMRs, bordereaux, Lloyd's vs company market).
• Dimensional and star schema modelling techniques.
• DevOps/CI-CD for Snowflake deployments and automation.

Responsibilities

• Designing and building Snowflake pipelines and ELT processes.
• Modelling across Raw, Curated and Gold layers and cost optimisation.
• Ingesting policy, premium, claims and finance data via data integration tooling.
• Building data quality, reconciliation and monitoring components.

Skills

Snowflake

London Market insurance

Dimensional modelling

DevOps/CI-CD

Job description

Senior Snowflake Data Engineer — London Market Insurance

12 Months | Fully Remote (UK) | Up to £450/day

A London Market insurer is expanding its Snowflake capability and needs a senior data engineer to help build out the enterprise data platform. This isn't a greenfield-only build or a pure lift-and-shift; it's a mix of both, with real business consumption across Underwriting, Claims, Finance, Portfolio Management, and Delegated Authority.

The details:

• Rate: Up to £450/day
• Length: 12 months initial
• Location: fully remote, 5 days
• Start: ASAP
• Structure: 3-week sprints, daily stand-ups, reporting into the Data Engineer Lead

What you'll actually be doing:

Designing and building Snowflake pipelines and ELT processes. Modelling across Raw, Curated and Gold layers. Performance tuning and cost optimisation. Building automated data quality, reconciliation and monitoring. Ingesting policy, premium, claims, bordereaux, delegated authority and finance data via Azure Data Factory. Supporting the migration and reconciliation off the legacy on-prem warehouse. Semantic models feeding Power BI.

What you will need:

• 2+ years hands-on production Snowflake — Tasks and Streams, secure views, data sharing, RBAC, cost optimisation, metadata management
• 5+ years London Market insurance. This is non-negotiable. You need to understand UMRs, bordereaux, the difference between Lloyd's and company market operations, and how premium and claims data actually behaves
• Dimensional and star schema modelling
• DevOps/CI-CD for Snowflake deployments

Who this suits:

Someone who's done Snowflake engineering inside a syndicate or managing agency and can talk to an underwriter without a translator. If you've got the Snowflake but no London Market, this one isn't for you.