Data Modeler ( P&C Insurance Experience Mandatory)

Prasha Consultancy Services Private Limited; Pune District; Hybrid; INR 1,200,000 - 2,400,000; Full time

Job summary

Prasha Consultancy Services Private Limited invites an experienced Data Modeler to join our insurtech team hybrid in Pune. You will design and maintain enterprise data models across policy, claims, billing, underwriting, reinsurance, finance, and reporting within Lloyd’s/London market contexts.

The ideal candidate has 5–12 years in P&C data modelling, ER modelling, and data warehousing, with hands-on SQL and tooling such as ERwin or ER Studio.

Qualifications

• 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.
• Experience with Data Warehousing concepts and architecture.

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.

Job description

A Reputed Insurtech MNC is hiring for Data Modeler.

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.
• Experience with Data Warehousing concepts and architecture.

Preferred Skills

• 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.