Job Description

Position Overview

We are seeking a skilled Data Modeler with expertise in designing, implementing, and optimizing data models within the insurance domain . The candidate will be responsible for translating complex business requirements into robust conceptual, logical, and physical data models that support insurance operations, including policy administration, claims, underwriting, billing, and regulatory compliance. The role requires strong experience with Erwin Data Modeler or similar tools, deep knowledge of insurance data processes, and the ability to work closely with business and technical stakeholders to ensure data integrity, scalability, and compliance.

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

• 5+ 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.

EXL Overview

EXL (NASDAQ: EXLS) is a leading operations management and analytics company that designs and enables agile, customer-centric operating models to help clients improve their revenue growth and profitability. Our delivery model provides market-leading business outcomes using EXL’s proprietary Business EXLerator Framework™, cutting-edge analytics, digital transformation, and domain expertise. At EXL, we look deeper to help companies improve global operations, enhance data-driven insights, increase customer satisfaction, and manage risk and compliance. EXL serves the insurance, healthcare, banking and financial services, utilities, travel, transportation, and logistics industries. Headquartered in New York, New York, EXL has more than 32,000 professionals in locations throughout the United States, Europe, Asia (primarily India and Philippines), South America, Australia, and South Africa. For more information, visit

Physical Demands and Working Conditions

Works in a normal office environment requiring light physical effort by handling objects up to 20 pounds occasionally and/or up to 10 pounds frequently. Works with standard office equipment (such as phone, fax, and personal computer). Ability to navigate stairs frequently during the course of a business day in various work locations. Sitting at desk for most of day, and working with computer.

EEO/Minorities/Females/Vets/Disabilities

EXL is an equal opportunity employer and will provide reasonable accommodation to those individuals who are unable to be vaccinated consistent with federal, state, and local law.

*The base salary range represents the low and high end of the EXL base salary range for this position. Actual salaries will vary depending on factors including but not limited to: location and experience. The base salary range listed is just one component of EXL's total compensation package for employees. Other rewards may include bonuses, as well as a Paid Time Off policy, and many region-specific benefits.”

Job Tags

Similar Jobs