At a Glance
- Tasks: Design and maintain data models for analytics and reporting in the insurance sector.
- Company: Leading insurance firm focused on innovation and compliance.
- Benefits: Attractive salary, flexible working options, and opportunities for professional growth.
- Other info: Collaborative environment with a focus on career advancement and skill development.
- Why this job: Shape the future of data in insurance while ensuring compliance and quality.
- Qualifications: Experience in data modelling and knowledge of insurance industry standards required.
The predicted salary is between 60000 - 80000 £ per year.
We are seeking an experienced Data Modeler / Architect 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 Modeler/ Architect- P&C Insurance employer: ValueMomentum
Join a forward-thinking company that values innovation and excellence in the insurance sector. As a Data Modeler/Architect, you will thrive in a collaborative work culture that prioritises professional growth and offers extensive training opportunities. Located in a vibrant area, our organisation provides a supportive environment where your expertise in data modelling will directly contribute to impactful enterprise solutions.
