Data Modeller_P&C Insurance

Crescendo Global Leadership Hiring India; Gurugram District; Hybrid; INR 2,800,000 - 6,000,000; Full time

Job summary

Crescendo Global Leadership Hiring India is seeking an experienced Data Modeller (8–12 years) with deep domain expertise in Property & Casualty Insurance and the London Market (Lloyd’s of London). You will design, build, and maintain enterprise data models across policy, claims, billing, underwriting, and reinsurance to power data warehouses and analytics.

The role requires strong ER and relational modelling (3NF), dimensional modelling (Kimball), and advanced SQL, plus hands-on experience with

Qualifications

• 8–12 years of core hands-on data modelling in enterprise data warehouses.
• In-depth knowledge of Property & Casualty insurance domains: policy, claims, billing, underwriting.
• London Market (Lloyd's) knowledge and market operations exposure.
• Proficiency in ER modelling, relational modelling (3NF), and dimensional modelling (Kimball).
• Advanced SQL for complex queries, profiling, and source analysis.
• Experience with enterprise data modelling tools (Erwin, ER/Studio, PowerDesigner, Hackolade).
• Bachelor’s or Master’s degree in CS/IS/Statistics or related field.

Responsibilities

• Design, develop, and maintain conceptual, logical, and physical data models across core insurance domains.
• Build high-performance dimensional models (star/snowflake) for BI and regulatory reporting.
• Architect end-to-end data pipelines and mapping structures across policy, underwriting, claims, billing, and accounting.
• Translate Lloyd's market constructs into robust data frameworks (Bordereaux, MGAs, syndicates).
• Define source-to-target mappings, transformation rules, relationships, and lineage.
• Collaborate with underwriters, claims specialists, actuarial teams, and business analysts to translate requirements into scalable architectures.
• Support governance efforts with data dictionaries, glossaries, and standard data quality rules.

Skills

SQL

ER modelling

3NF modelling

Dimensional modelling

Kimball methodology

Data warehousing

Governance & lineage

Education

Bachelor’s or Master’s in Computer Science or related field

Tools

Erwin Data Modeler

ER/Studio

PowerDesigner

Hackolade

Job description

Job Title: Data Modeller (P&C Insurance / Lloyd's Market)

Experience Level: 812 Years

Domain: Property & Casualty (P&C) Insurance / London Market (Lloyd’s)

Employment Type: Full-Time

Role Summary

We are seeking an experienced Data Modeller (8–12 Years) with deep domain expertise in Property & Casualty (P&C) Insurance and the London Market (Lloyd’s of London). In this role, you will be responsible for designing, building, and maintaining enterprise conceptual, logical, and physical data models across core insurance subject areas—including Policy, Claims, Billing, Underwriting, and Reinsurance—to power modern data warehouses and analytical reporting platforms.

Key Responsibilities

• Enterprise Data Modelling: Design, develop, and maintain conceptual, logical, and physical data models (3NF, ER modelling) aligned with industry standard insurance canonical models.
• Dimensional Design: Build high-performance dimensional models (star/snowflake schemas), conformed dimensions, and aggregate fact tables tailored for business intelligence and regulatory reporting.
• Core Insurance Lifecycle Alignment: Architect end-to-end data pipelines and mapping structures covering Policy Administration, Underwriting, Claims Adjudication, Billing, and Accounting workflows.
• Lloyd's & London Market Integration: Translate specialized Lloyd's market constructs—such as Bordereaux processing (premiums and claims), Managing General Agents (MGAs), syndicate structures, and broker transactions—into robust data frameworks.
• Data Mapping & Source-to-Target Specifications: Define comprehensive source-to-target data mappings, transformation business rules, relationship cardinalities, and lineage documentation.
• Business & SME Collaboration: Partner directly with underwriters, claims specialists, actuarial teams, and business analysts to translate complex business requirements into scalable technical data architectures.
• Governance & Data Standardization: Collaborate with data governance teams to enforce standard business glossaries, enterprise data dictionaries, naming conventions, and data quality rules.

Required Skills & Experience

• Experience: 8 to 12 years of core hands-on data modelling experience within enterprise data warehouse environments.
• Domain Expertise: In-depth functional knowledge of Property & Casualty (P&C) Insurance core domains: Policy, Claims, Billing, and Underwriting.
• London Market Knowledge: Practical exposure to the Lloyd’s Market ecosystem, London market messaging standards, and market operations.
• Modelling Methodologies: Deep proficiency in Entity-Relationship (ER) modelling, relational modelling (3NF), dimensional modelling (Kimball methodology), and canonical schema creation.
• Technical Skills: Advanced SQL capabilities for complex data querying, schema profiling, performance tuning, and source analysis.
• Modelling Tools: Proven experience with enterprise data modelling tools (e.g., Erwin Data Modeler, ER/Studio, PowerDesigner, or Hackolade).
• Education: Bachelor’s or Master’s degree in Computer Science, Information Systems, Statistics, or a related field.

Preferred Skills & Qualifications

• Reinsurance & Exposure: Experience handling Treaty, Facultative, and Reinsurance accounting data structures.
• Delegated Authority & Bordereaux: Working knowledge of MGA, TPA, and Lloyd's delegated authority processing, including Bordereaux ingestion and validation rules.
• Cloud Modern Data Platforms: Hands-on exposure to modern cloud data warehouses and lakehouse architectures such as Snowflake or Databricks.
• Insurance Standards: Familiarity with industry reference models like ACORD or standard insurance data frameworks