Data Modeler

Job Title: Data Modeler Location: London, UK (3 days/week onsite) Experience: 12+ Years Employment: Permanent / Contract Role Overview We are seeking an experienced Data Modeler with expertise in Erwin Data Modeler, Azure Databricks, and the London Market P&C Insurance domain. The role focuses on designing scalable, governed, and compliant enterprise data models supporting analytics, regulatory reporting, and operational data. Key Skills Mandatory • Erwin Data Modeler • Azure Databricks & Unity Catalog • London Market / P&C Insurance • Data Modelling: Dimensional (Star/Snowflake), Data Vault, 3NF • JSON/XML Schema Design • ACORD Data Standards Good to Have • Medallion Architecture (Bronze/Silver/Gold) • CSIO Standards • MDM / RDM • GDPR, Solvency II, Lloyd's Reporting • MAR/SOX Governance Key Responsibilities • Design and maintain conceptual, logical, and physical enterprise data models. • Develop canonical insurance data models covering Contracts, Premium/Risk, and Claims. • Build implementation-ready JSON/XML schemas and data exchange templates. • Develop models using Data Vault, Star/Snowflake, and 3NF methodologies. • Manage metadata and governance using Erwin Data Modeler. • Implement data models on Databricks with Unity Catalog. • Support Medallion Architecture across ingestion and curation layers. • Ensure compliance with GDPR, Solvency II, Lloyd's, and MAR/SOX requirements. • Apply ACORD and CSIO insurance data standards. • Lead data modelling workshops, governance reviews, and stakeholder alignment. Provide architectural oversight for partner onboarding, data mapping, validation, and integration.