Energy Jobline is the largest and fastest growing global Energy Job Board and Energy Hub. We have an audience reach of over 7 million energy professionals, 400,000+ monthly advertised global energy and engineering jobs, and work with the leading energy companies worldwide.

We focus on the Oil & Gas, Renewables, Engineering, Power, and Nuclear markets as well as emerging technologies in EV, Battery, and Fusion. We are committed to ensuring that we offer the most exciting career opportunities from around the world for our jobseekers.

Job Description

JOB ROLE : Data Architect / Data Modeler – P&C Insurance

LOCATION : London, UK ( 3 days / week onsite )

EXPERIENCE : 10 + Years

ROLE OVERVIEW:

We are seeking an experienced Data Architect / Data Modeler with strong insurance industry standards knowledge and a solid foundation in modern data modelling practices. The ideal candidate will have hands-on experience with modelling tools, data frameworks, and insurance industry data exchange standards. This role involves designing scalable, compliant, and high-quality data structures that support enterprise analytics, regulatory reporting, and operational data needs.

RESPONSIBILITIES:

Design and maintain enterprise-wide data models (conceptual, logical, physical) to support analytics, operational reporting, regulatory compliance, and integration use cases. Own the design of canonical data models for delegated insurance covering Contract, Premium/Risk, and Claims, including full transaction and movement-based constructs (e.g. endorsements, cancellations, reinstatements, claim financial movements. Translate conceptual and logical models into implementation-ready artefacts including JSON/XML schemas and Excel bordereaux templates to support real-time API ingestion from MGA/TPA partner systems and monthly bordereaux submissions Develop data models using Dimensional (Star/Snowflake), Data Vault, and 3NF methodologies. Create and manage metadata and modelling artefacts using Erwin with traceability and governance. Support Medallion Architecture (Bronze, Silver, Gold) across ingestion and curation layers. Collaborate with engineering teams to implement models on Databricks and Unity Catalog. Participate in governance forums to drive standardization across data domains. Conduct model reviews and solution walkthroughs for architectural alignment. Define and govern integration patterns for third-party datasets including geocoding, hazard, valuation, and reference data. Ensure compliance with GDPR, Solvency II, and Lloyd’s reporting and oversight requirements, compliance with MAR/SOX controls through documentation and validation processes when applicable. Interpret and apply ACORD and CSIO data standards for global and Canadian insurance data exchange. Align modelling standards with the GSI Data Target Operating Model (TOM) and Partner Management & Data Intake workstreams acting as the architectural authority for delegated data standards. Lead data modelling workshops and SME councils to drive stakeholder alignment. Provide architectural oversight during partner onboarding including mapping, validation, exception handling, and change control

REQUIRED SKILLS & KNOWLEDGE:

Industry Standards

• Knowledge of ACORD (global, comprehensive insurance data standards).

• Knowledge of CSIO (Canadian insurance standards, including XML, EDI, and JSON formats).

Tools & Platforms

• Erwin Data Modeler – Mandatory

• Familiarity with:

Medallion Data Architecture Databricks & Unity Catalog MAR/SOX data governance and regulatory frameworks GDPR, Solvency II, and Lloyd’s reporting and oversight requirements.

Modelling Techniques

• Dimensional Modelling: Star and Snowflake schemas

• Data Vault Modelling

• Third Normal Form (3NF) relational modelling

• JSON/XML schemas.

Optional / Nice to Have

• Experience with MDM / RDM (Master Data Management / Reference Data Management)

If you are interested in applying for this job please press the Apply Button and follow the application process. Energy Jobline wishes you the very best of luck in your next career move.