ea Change
Data Engineer
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
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
- IR35: Inside IR35 via an umbrella company
- Length: 12 months initial
- Location: fully remote, 5 days
- Start: ASAP
- Structure: 3-week sprints, daily stand-ups, reporting into the Data Engineer Lead
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
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
- Strong SQL, Azure Data Factory, enterprise ETL/ELT
- Dimensional and star schema modelling
- DevOps/CI-CD for Snowflake deployments
Get help with your application
Your very own career expert that helps elevate your application to the next level.
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.
Message me directly or apply here.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location