Senior Data Modeler

EY; Chennai; On-site; INR 1,500,000 - 2,300,000; Full time

Job summary

EY is hiring an experienced Techno-Functional Data Consultant to bridge business stakeholders and technical teams in Chennai. The role focuses on Insurance Data Management, Data Modelling, Reporting & Analytics, and Data Migration, with hands-on data vault and dimensional modelling work.

Responsibilities include requirements gathering, data profiling, mapping, governance, and coordinating SIT/UAT validation alongside Data Engineering and Analytics teams.

Qualifications

• Strong understanding of insurance business processes and data structures.

Responsibilities

• Collaborate with business users, SMEs, architects, and delivery teams to gather and document functional and data requirements.

Skills

Data Vault 2.0

Dimensional Modelling

Relational Modelling

Data Warehousing

ERwin

ER/Studio

SAP PowerDesigner

Visio

Lucidchart

Insurance Domain Expertise

Data & Business Analysis

Data Modelling

Tools

ERwin

ER/Studio

SAP PowerDesigner

Visio

Lucidchart

Job description

Job Summary

We are seeking an experienced Techno-Functional Data Consultant with strong expertise in Insurance Data Management, Data Modelling, Business Analysis, Reporting & Analytics, and Data Migration. The ideal candidate will act as a bridge between business stakeholders and technical teams, translating business requirements into scalable data solutions that support operational, analytical, and reporting needs.

The role requires hands-on experience in Data Vault modelling, dimensional modelling, data analysis, reporting tools, and insurance data domains. Experience working within the UK Insurance Market is highly desirable.

Your Key Responsibilities

Business Analysis & Stakeholder Management

• Collaborate with business users, SMEs, architects, and delivery teams to gather and document functional and data requirements.
• Conduct workshops to understand business processes, reporting needs, and data challenges.
• Translate business requirements into functional specifications, data models, and reporting solutions.
• Perform impact assessments and support change management activities.
• Act as the key liaison between business and technology teams.

Data Analysis & Data Management

• Perform data profiling, gap analysis, and source-to-target data mapping.
• Analyse large and complex datasets to identify data quality issues and transformation requirements.
• Define business rules, validation rules, and reconciliation requirements.
• Support data governance, metadata management, and data lineage initiatives.
• Ensure consistency and integrity of data across operational and analytical platforms.

Data Modelling

• Design and maintain Conceptual Data Models, Logical Data Models and Physical Data Models
• Develop and maintain enterprise data models and data dictionaries.
• Design scalable data structures for operational and analytical solutions.
• Implement best practices in:
• Data Vault 2.0 Modelling (Hubs, Links, Satellites)
• Dimensional Modelling (Star Schema, Snowflake Schema)
• Canonical Data Models
• Enterprise Data Models
• Collaborate with Data Architects and Engineering teams to ensure alignment with enterprise architecture standards.

Reporting & Analytics

• Gather and define reporting and dashboard requirements from business stakeholders.
• Design reporting data models and analytical datasets.
• Support development and optimization of business intelligence solutions.
• Work closely with analytics teams to ensure accurate and meaningful reporting outputs.
• Define KPIs, metrics, and reporting standards.

Data Migration & Integration

• Support large-scale data migration and transformation programmes.
• Develop source-to-target mapping specifications.
• Define migration and reconciliation rules.
• Support SIT, UAT, and production validation activities.
• Work alongside Data Engineering and Integration teams to ensure successful delivery.

Mandatory Skills & Experience

Insurance Domain Expertise

• Strong understanding of insurance business processes and data structures.
• Experience in Policy Administration, Underwriting, Claims, Billing & Finance, Customer Management, Broker Management and Reinsurance

Data & Business Analysis

• Strong business and data analysis skills.
• Experience gathering and documenting business requirements.
• Expertise in data mapping, profiling, and validation.
• Strong understanding of data governance and data quality frameworks.

Data Modelling (Mandatory)

• Minimum 5 years of hands-on data modelling experience.
• Strong expertise in:
• Data Vault 2.0
• Dimensional Modelling
• Relational Data Modelling
• Data Warehousing Concepts
• Experience using modelling tools such as:
• ERwin
• ER/Studio
• SAP PowerDesigner
• Visio
• Lucidchart