Quick overview
Job 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.
- 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.
Haystack's AI agent can fill in and submit this application for you. How AI auto apply works
Will your resume get past this employer's screening? Check your resume against this job, free
Similar jobs
- JU

Data Engineer - II (Biometrics)Recently posted Auto Apply
Jumio · Bengaluru · Hybrid · Posted 18 Nov 2026 🇮🇳
SQLAWSETL+5TechnologySalary not listed - CH

Senior Data EngineerRecently posted Auto Apply
Cohere Health · Hyderabad · Hybrid · Posted 17 Nov 2026 🇮🇳
SQLApache SparkAWS+6TechnologySalary not listed - B2
Senior Fabric Lead Data Engineer - R01572945 Auto Apply
Brillio 2 · Bengaluru · Hybrid · Posted 22 Oct 2026 🇮🇳
SQLGitApache Spark+6TechnologySalary not listed - WE
GCP(Big query + SQL) Data EngineerRecently posted Auto Apply
Weekdayworks · Bengaluru · On-site · Posted 16 Nov 2026 🇮🇳
Technology₹1400k - ₹2000k/yr - V1
Senior Oracle Fusion Data Migration ConsultantRecently posted Auto Apply
Version 1 · Bengaluru, KA · Hybrid · Posted 16 Nov 2026 🇮🇳
OraclePL/SQLSQL+6TechnologySalary not listed - WA
GCP(Big query + SQL) Data EngineerRecently posted Auto Apply
Weekday AI · Chennai, Tamil Nadu · On-site · Posted 16 Nov 2026 🇮🇳
GCPSQLAirflow+6TechnologySalary not listed - WA
GCP(Big query + SQL) Data EngineerRecently posted Auto Apply
Weekday AI · Hyderabad, Telangana · On-site · Posted 16 Nov 2026 🇮🇳
GCPSQLAirflow+6TechnologySalary not listed - WA
GCP(Big query + SQL) Data EngineerRecently posted Auto Apply
Weekday AI · Pune, Maharashtra · On-site · Posted 16 Nov 2026 🇮🇳
GCPSQLAirflow+6TechnologySalary not listed - WA
GCP(Big query + SQL) Data EngineerRecently posted Auto Apply
Weekday AI · Bengaluru, Karnataka · On-site · Posted 16 Nov 2026 🇮🇳
GCPSQLAirflow+6TechnologySalary not listed - EX
Technical Data managerRecently posted Auto Apply
Excelya · Bengaluru, Karnataka · Hybrid · Posted 16 Nov 2026 🇮🇳
GCPOracleMicrosoft Excel+2TechnologySalary not listed - BG
KNIME SpecialistRecently posted Auto Apply
Bosch Group · bengaluru · On-site · Posted 13 Nov 2026 🇮🇳
SQLAWSETL+5TechnologySalary not listed - KN

Staff Data Engineer (Position located in Kochi, India)Recently posted Auto Apply
KnowBe4 · Kochi · Hybrid · Posted 13 Nov 2026 🇮🇳
SQLComplianceData Pipeline+1TechnologySalary not listed
