In short
Senior Data Engineer at a growing Lloyd's MGA in London, working hands-on alongside underwriting to build and fix data pipelines (SQL, Python, dbt, Snowflake), improve policy/premium/claims/exposure data quality, and deliver underwriting KPIs that reconcile back to Finance.
About the role
JSS is partnering with a growing Lloyd’s MGA to hire a Senior Data Engineer into a small, high-impact team working directly alongside underwriting.
This isn’t a role where you’ll spend months designing a future-state architecture. The mandate is much more immediate: identify what is preventing underwriting leadership from hitting their KPIs, fix it, and deliver something useful within weeks.
The initial focus will be on the Marine business, with genuinely broad scope across data, systems, integration and process.
The role
You’ll take ownership of the underwriting data model across policy, premium, claims and exposure, improving the quality, consistency and usability of the data underpinning underwriting decisions.
You’ll be expected to remain highly hands-on, including:
- Building and improving data pipelines using SQL, Python and dbt
- Working extensively within Snowflake
- Troubleshooting and fixing data quality and reconciliation issues
- Bringing together policy, premium, claims and exposure data
- Working with bordereaux and London Market insurance data
- Connecting claims data accurately back to policies
- Working directly with underwriting, Finance and the wider business to understand problems and deliver solutions quickly
- A key initial deliverable will be to establish reliable underwriting KPIs that reconcile back to Finance.
What we’re looking for:
This role will suit someone who combines strong engineering capability with enough insurance knowledge to understand the data they are working with.
You’ll ideally bring:
- Strong SQL and Python
- Hands-on dbt and Snowflake experience
- Experience building and fixing production data pipelines
- Strong understanding of London Market insurance data
- Experience working with policy, premium, claims and/or exposure datasets
- Knowledge of bordereaux and the challenges of linking claims back to policies
- The ability to work directly with underwriters and senior stakeholders
- A delivery mindset: able to find problems yourself rather than wait for a detailed specification
You’ll need to be comfortable spending meaningful time in the London office and alongside the underwriting team.
Interested? Please apply or get in touch with JSS for a confidential conversation.