Data Modeler ( P&C Insurance Experience Mandatory)

A Reputed Insurtech MNC is hiring for Data Modeler.

Job Location: Gurgaon/Noida/Pune/Bangalore/Kolkata

Work Mode: Hybrid

Experience: 5 - 12 years

Role Summary

We are looking for an experienced Data Modeller with strong expertise in Property & Casualty (P&C) Insurance and the Lloyd's/London Market. The candidate will be responsible for designing and maintaining enterprise data models across key insurance domains including Policy, Claims, Billing, Underwriting, Reinsurance, Finance, and Reporting.

Key Responsibilities

• Design and develop conceptual, logical, and physical data models for insurance business domains.
• Create and maintain ER/Data Models aligned with business and technical requirements.
• Work closely with business analysts, data architects, developers, and insurance SMEs.
• Model data across Policy, Claims, Billing, Underwriting, Reinsurance, Finance, and Reporting.
• Analyze existing data structures and identify opportunities for data standardization and optimization.
• Develop and validate SQL queries for data analysis and model validation.
• Support data warehouse and enterprise data architecture initiatives.
• Ensure data models follow appropriate standards for data quality, governance, and consistency.

Mandatory Skills

• Strong experience in P&C Insurance / Property & Casualty Insurance.
• Hands-on experience with Lloyd's / London Market.
• Strong expertise in Data Modelling and ER Modelling.
• Good understanding of Policy, Claims, Billing, and Underwriting data.
• Strong SQL skills.
• Experience with Data Warehousing concepts and architecture.

Preferred Skills

• Experience in Reinsurance.
• Knowledge of Bordereaux.
• Understanding of MGA / Broker Operations.
• Knowledge of Insurance Accounting.
• Experience with Snowflake and/or Databricks.
• Hands-on experience with ERwin / ER Studio or similar data modelling tools.

Qualifications

Bachelor's or master's degree in computer science, Information Technology, or a related field.