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