4Bell Technology

Staffing & Recruiting

Data Modeller (P&C Insurance / Lloyd's Market)(R-2216)

1,400,000.00-1,499,998.00/A

Any Degree

IT (Information Technology)

Contract

Noida,Gurgaon/Gurugram,Bangalore/Bengaluru,Pune,Kolkata

12-Dec-2026

Data Modelling Entity-Relationship (ER) Modelling SQL Data Warehousing P&C Insurance Lloyds / London Market Policy Claims Billing Underwriting

Job Description

Key Responsibilities

  • Design, develop, and maintain conceptual, logical, and physical data models for enterprise insurance data platforms.

  • Create and manage Entity-Relationship (ER) diagrams and define entities, attributes, relationships, primary keys, and foreign keys.

  • Work closely with business stakeholders, business analysts, data engineers, architects, and reporting teams to understand data requirements.

  • Develop data models across key P&C insurance domains, including Policy, Claims, Billing, Underwriting, Reinsurance, Finance, and Reporting.

  • Translate insurance business requirements into scalable and well-structured data models.

  • Analyse complex insurance datasets and establish data relationships, definitions, standards, and business rules.

  • Support data warehousing initiatives, data integration, and analytical/reporting solutions.

  • Use SQL to validate data structures, analyse datasets, and support data quality checks.

  • Ensure data consistency, integrity, scalability, and alignment with enterprise data architecture standards.

  • Document data definitions, metadata, modelling standards, and relationships across insurance business domains.

Mandatory Skills

  • Strong experience in Property & Casualty (P&C) Insurance.

  • Good understanding of the Lloyd’s Market / London Market insurance ecosystem.

  • Hands-on experience in Data Modelling and Entity-Relationship (ER) Modelling.

  • Knowledge of insurance business processes covering Policy, Claims, Billing, and Underwriting.

  • Strong SQL skills and understanding of relational databases.

  • Experience in Data Warehousing and enterprise data structures.

  • Ability to translate complex insurance business requirements into logical and physical data models.