Design and maintain conceptual, logical, and physical data models for insurance systems (claims, policy, underwriting, billing, reinsurance). Translate business requirements into scalable data solutions, support regulatory reporting, ensure OLTP/OLAP optimization, enforce data governance, document lineage and business rules, and collaborate with data warehouse, ETL, BI, actuarial, and policy teams.
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.
- Strong 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.
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.
- Strong 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.
EXL Chennai, Tamil Nadu, IND Office
Chennai, India
Similar Jobs
Automotive • Hardware • Robotics • Software • Transportation • Manufacturing
Graduate Engineer Trainee responsible for designing and developing automotive parts using CATIA V5 or UG NX. The role performs 3D and 2D CAD modeling, reads engineering drawings, applies plastics fundamentals, follows Magna Steyr processes and customer standards, meets daily delivery targets, and completes quality checks. Candidates collaborate with engineering leads, clarify requirements, and demonstrate communication, teamwork, willingness to learn, and proficiency in English, Hindi, or Marathi.
Top Skills:
CadCatia V5Ug Nx
Artificial Intelligence • Fintech • Software
Lead design and execution of performance, load, stress, endurance, and scalability testing for cloud-based SaaS. Build automated testing frameworks integrated with CI/CD, analyze metrics across application, database, API, and infrastructure, guide capacity planning, create monitoring dashboards, validate releases, lead root-cause analysis, and mentor engineers on performance best practices.
Top Skills:
AWSCi/CdDatadogGatlingGoGrafanaJavaJavaScriptJmeterK6LoadrunnerLocustNew RelicPrometheusPythonSplunkSQL
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Lead complex, multi-geography payments transformation projects; engage senior stakeholders; manage cross-product deployment of customer journeys; perform project sizing, create detailed plans, business cases and benefit sizing; and independently lead transformation interventions.
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
