Posted today · be early

Offshore Data Modeler

EXL

IndiaremotePosted today

Skill Required

Data-ManagementData-ModelingData-ArchitectureInsurance-Data-ManagementDatabase-DesignData-ModelerData-Modeling-SpecialistData-Modeling-EngineerData-ModellerData-Model-ArchitectData-Modelling-ConsultantData-Model-Designerrelated fieldanalyticaletc.)designAzureCloudETLSQLAWSGCPandFulltime

Role overview

This role is a Data Modeler focused on the insurance industry, responsible for designing, developing, and maintaining conceptual, logical, and physical data models across insurance applications such as claims, policy administration, underwriting, billing, and reinsurance. The position requires strong collaboration with business analysts, data architects, developers, actuaries, and compliance teams to ensure data solutions align with both business needs and regulatory standards.

Responsibilities

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

Requirements

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)
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
Understanding of data governance, metadata management, and lineage tracking
Bachelor's or master's degree in computer science, Information Systems, Data Management, or a related field
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