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 robust 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
Solid experience in P&C; Insurance / Property & Casualty Insurance.
Hands-on experience with Lloyd's / London Market.
Strong expertise in Data Modelling and ER Modelling.
Valuable 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.

📌 Data Modeler P&c Insurance Experience Mandatory Pune
🏢 Prasha Consultancy Services Private
📍 Pune