Offshore Data Modeler

EXL

IndiaremotePosted 1 month ago

Skill Required

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

Key highlights

Requires 4+ years of experience as a Data Modeler/Data Architect, preferably in insurance
Must have strong hands-on experience with Erwin Data Modeler or equivalent tools
Role focuses on data modeling for core insurance systems (claims, policy, underwriting, etc.)
Must have proven expertise modeling core insurance data entities (Policy, Claims, Premiums, etc.)
Familiarity with insurance standards (ACORD, ISO) is a plus
Preferred certifications include Erwin Data Modeler, AINS/CPCU, and CDMP

Role overview

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