Senior Data Modeller – Lloyd’s Market (Contract)
Location:
London (Hybrid – 2 days onsite per week)
Rate:
£500 per day (Outside IR35)
Start Date:
Immediate
Duration:
Initial 6 months (extension likely)
Sector:
Insurance / Lloyd’s Market / Data Architecture
Engagement Context
Our client, a leading consultancy delivering strategic data transformation across the Lloyd’s and London Market, is seeking a Senior Data Modeller to support a high-impact programme focused on post-bind insurance data. The successful candidate will play a critical role in designing scalable, compliant data models that underpin operational reporting, financial reconciliation, and regulatory alignment across multiple specialty lines.
This role requires deep familiarity with post-bind insurance constructs—such as premium and claim transactions, aged debt, reserves, bordereaux, and settlement flows. Candidates whose experience is limited to pre-bind or underwriting data will not be suitable for this engagement.
Key Responsibilities
- Lead the design and delivery of conceptual, logical, and physical data models across post-bind domains
- Collaborate with data architects, business analysts, and actuarial teams to translate complex business requirements into structured data assets
- Apply Data Vault 2.0 methodology to support auditability, scalability, and lineage tracking
- Model data for ingestion into Snowflake, ensuring compatibility with cloud-native architecture and downstream analytics
- Ensure models support reconciliation of premium and claims, aged debt tracking, reserve movements, and regulatory reporting
- Document metadata, data dictionaries, and lineage to support governance and compliance
- Engage with stakeholders across finance, operations, and claims to validate model assumptions and ensure business alignment
Required Experience & Skills
- Extensive experience as a Data Modeller within the Lloyd’s or London Market, with demonstrable expertise in post-bind data
- Strong understanding of insurance financial flows:
- Premium transactions (written, earned, settled)
- Claim transactions (paid, outstanding, incurred)
- Aged debt and reserve movements
- Bordereaux processing and reconciliation
- Proficiency in Data Vault 2.0 and dimensional modelling techniques
- Hands-on experience with Snowflake and cloud-based data platforms
- Ability to model across multiple specialty lines (e.g., marine, aviation, cyber)
- Strong stakeholder engagement and documentation skills
- Familiarity with regulatory constructs (e.g., Solvency II, Lloyd’s Minimum Standards) is advantageous
Success Measures
- Delivery of robust, scalable data models that support post-bind reporting and reconciliation
- Clear documentation and stakeholder alignment across finance, operations, and actuarial domains
- Seamless integration of models into Snowflake and downstream analytics pipelines
- Contribution to a broader data transformation programme with measurable impact on operational efficiency and regulatory compliance
