Specialty Insurance Data Modeller

Experience: 7 - 12 Years

Domain: Insurance

Preferred Domain: Specialty Insurance / Commercial Insurance / London Market Insurance

Role Overview:

We are looking for an experienced Specialty Insurance Data Modeller with strong expertise in enterprise data modelling and a solid understanding of the Insurance domain. The ideal candidate should have hands-on experience designing Conceptual, Logical and Physical Data Models and translating complex insurance business requirements into scalable, implementation-ready data structures.

The candidate should have a strong understanding of insurance data and relationships across key business areas such as Policy, Coverage, Risk, Insured, Broker, Claims, Reinsurance, Premium and Finance. Experience working within Specialty Insurance or Commercial Insurance environments is strongly preferred, while exposure to the London Market Insurance ecosystem will be highly advantageous.

Key Responsibilities:

- Design and develop Conceptual, Logical and Physical Data Models for enterprise insurance data platforms.

- Work closely with business SMEs, data architects, data engineers and other stakeholders to understand business requirements and translate them into effective data models.

- Design scalable models covering major insurance entities including Policy, Coverage, Risk, Insured, Broker, Claims, Premium, Reinsurance and Finance.

- Develop and maintain enterprise-level models supporting analytical and data warehouse environments.

- Apply Data Vault 2.0 modelling principles, including the design of Hubs, Links, Satellites and Business Vault structures.

- Support the integration and modelling of data coming from multiple insurance source systems.

- Ensure consistency in enterprise data definitions, relationships and modelling standards.

- Support data lineage, metadata management and documentation across the data modelling lifecycle.

- Collaborate with engineering teams to ensure logical models are correctly translated into implementation-ready physical models.

- Work with business stakeholders to ensure complex insurance concepts and relationships are represented accurately within enterprise data models.

Mandatory Skills:

- Strong hands-on experience in Data Modelling

- Conceptual Data Modelling

- Logical Data Modelling

- Physical Data Modelling

- Data Vault 2.0

- Hubs, Links and Satellites

- Business Vault

- Data Lineage

- Metadata Management

- SQL

- Enterprise Data Modelling

- Data Warehouse / Analytical Data Modelling

- Experience with modelling tools such as ERWIN, ER/Studio, Sparx Enterprise Architect or equivalent

Mandatory Domain Experience:

Candidates must have relevant experience within the Insurance domain and a strong understanding of insurance-related data.

Relevant domain knowledge should include areas such as:

- Policy

- Coverage

- Risk

- Insured

- Broker

- Claims

- Premium

- Reinsurance

- Finance

Preferred Domain Experience:

Candidates with experience in the following areas will be strongly preferred:

- Specialty Insurance

- Commercial Insurance

- London Market Insurance

- Complex insurance risks and products