Description
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
📌 Offshore Data Modeler (Pune)
🏢 EXL
📍 Pune