Key Responsibilities

Data Modeling & Design

- Design, develop, and maintain conceptual, logical, and physical data models for insurance applications and systems (claims, policy, underwriting, billing, reinsurance, etc.).

- Build and maintain enterprise data models aligned with insurance industry standards (e.g., ACORD).

- Define data dictionaries, metadata, and relationships to support data governance and consistency.

- Ensure data models are optimized for both transactional (OLTP) and analytical (OLAP) systems.

Insurance Domain Expertise

- Translate business requirements from claims, policy administration, underwriting, actuarial, and finance teams into scalable data solutions.

- Support regulatory and compliance reporting requirements (e.g., IRDAI, IFRS, Solvency II).

- Ensure models capture core insurance processes such as claims intake, adjudication, settlement, renewals, endorsements, and cancellations.

Collaboration & Stakeholder Engagement

- Partner with business analysts, data architects, and developers to deliver insurance-specific data solutions.

- Work with data warehouse, ETL, and BI teams to ensure seamless integration of insurance data.

- Collaborate with actuaries, claims specialists, and policy teams to validate data definitions and usage.

Governance & Standards

- Enforce data governance and quality standards across insurance systems.

- Document business rules, lineage, and data definitions for core insurance entities.





- Conduct impact analysis for changes in insurance processes and data flows.

Qualifications

Experience

- 4 years of experience as a Data Modeler or Data Architect, preferably in the insurance industry.

- Solid hands-on experience with Erwin Data Modeler (or equivalent data modeling tools).

- Proven expertise in modeling insurance data entities such as Policy, Customer, Premiums, Claims, Payments, Underwriting, Reinsurance, and Agents/Brokers.

- Experience working with data warehouses, data lakes, and cloud platforms (AWS, Azure, or GCP).

Skills

- Strong knowledge of insurance domain data flows and regulatory needs.

- Expertise in conceptual, logical, and physical modeling.

- Proficiency in SQL for data analysis and validation.

- Familiarity with insurance standards (e.g., ACORD, ISO) is a plus.

- Understanding of data governance, metadata management, and lineage tracking.

Education

- Bachelor's or master's degree in computer science, Information Systems, Data Management, or a related field.

Preferred Certifications (not Mandatory)

- Erwin Data Modeler Certification.

- Insurance certifications (e.g., AINS, CPCU) are highly desirable.

- Data management certifications (e.g., CDMP).

Key Attributes

- Strong analytical and problem-solving skills.

- Excellent communication and stakeholder management abilities.

- Detail-oriented with a focus on accuracy and compliance.

- Ability to thrive in a fast-paced insurance environment with multiple priorities.

📌 Offshore Data Modeler (Pune)
🏢 EXL
📍 Pune