Data Modeling Manager

EY; Chennai; On-site; INR 1,800,000 - 2,400,000; Full time

Job summary

EY GDS is seeking a Manager - Techno-Functional Data Modeller & Business Analyst for Insurance to lead data transformation, governance, and analytics initiatives. The role demands hands-on data vault modelling, data strategy, and stakeholder leadership within EY's Data & Analytics practice.

The ideal candidate will drive enterprise data architecture, mentor teams, and collaborate on client engagements across SIT/UAT, cutover, and production deployment phases.

Qualifications

• 7+ years hands-on data modelling experience.
• Strong expertise in Data Vault 2.0, Dimensional Modelling, Relational Modelling, Data Warehousing and Enterprise Data Architecture.

Responsibilities

• Lead end-to-end data transformation, migration, reporting, and modernization programmes.
• Engage with senior stakeholders to define data strategy and governance.
• Translate business requirements into functional specifications and data models.
• Mentor teams of Data Analysts and Data Modellers; contribute to practice accelerators.

Skills

Data Modelling

Data Vault 2.0

Enterprise Data Architecture

Stakeholder Management

Delivery Leadership

Data Governance

Business Analysis

Data Migration

Team Leadership

Tools

Erwin

ER/Studio

SAP PowerDesigner

Lucidchart

Job description

EY GDS Data and Analytics (D&A) Functional Data Modeller and Analyst Insurance (Manager)

Job Summary

We are seeking an experienced Manager - Techno-Functional Data Modeller & Business Analyst with deep expertise in Insurance Data Management, Data Modelling, Business Analysis, Reporting & Analytics, Data Governance, and Data Migration.

The successful candidate will lead complex data transformation initiatives, manage stakeholder relationships across business and technology functions, and provide thought leadership in designing enterprise-scale data solutions. This role requires a blend of consulting, delivery leadership, data architecture understanding, and hands-on data vault modelling expertise.

The individual will be responsible for driving data strategy, ensuring delivery excellence, managing client engagements, mentoring teams, and supporting business growth initiatives within the EY Data and Analytics practice.

Your Key Responsibilities

Business Analysis & Stakeholder Management

• Lead requirements workshops, discovery sessions, and data strategy discussions with senior stakeholders.
• Build and maintain strong relationships with business sponsors, SMEs, architects, and delivery teams.
• Provide strategic recommendations on data platforms, reporting solutions, migration approaches, and governance frameworks.
• Support proposal development, solution design, estimations, and client presentations.

Delivery Leadership & Programme Management

• Lead end-to-end delivery of data transformation, migration, reporting, and modernization programmes.
• Manage multiple workstreams while ensuring alignment with programme objectives, timelines, budgets, and quality standards.
• Proactively identify and mitigate programme risks, issues, and dependencies.
• Ensure successful delivery across SIT, UAT, cutover, and production deployment phases.

Business Analysis & Data Consulting

• Lead business and data discovery activities across insurance projects.
• Translate business requirements into functional specifications, data models, reporting solutions, and transformation requirements.
• Conduct impact assessments, gap analysis, and process improvement initiatives.
• Define business rules, validation frameworks, reconciliation rules, and data quality controls.
• Support operational and strategic decision-making through data-driven insights.

Data Management & Data Governance

• Define and implement enterprise data governance standards and best practices.
• Drive data quality, metadata management, master data management, and lineage initiatives.
• Establish data stewardship processes and governance forums.
• Ensure compliance with regulatory and risk management requirements.
• Support enterprise data strategy and target-state data architecture initiatives.

Reporting & Analytics

• Lead requirements gathering for dashboards, KPIs, scorecards, and analytical solutions.
• Design reporting datasets, semantic layers, and reporting data models.
• Support self-service BI and data democratization initiatives.

Data Migration & Integration

• Create source-to-target mappings, migration strategies, and reconciliation frameworks.
• Drive migration governance, issue management, and stakeholder sign-offs.
• Collaborate with Data Engineering and Integration teams to ensure successful implementation.
• Establish best practices for migration quality, auditability, and controls.

People Leadership & Practice Development

• Lead and mentor teams of Data Analysts, Data Modellers, Consultants, and Senior Consultants.
• Support recruitment, resource planning, capability development, and performance management.
• Provide coaching and technical leadership across client engagements.
• Contribute to EY's Data & Analytics practice through accelerators, methodologies, reusable assets, and thought leadership.
• Support business development activities, RFP responses, and solution architecture proposals.

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 Modelling (Mandatory)

• Minimum 7+ years of hands-on data modelling experience.
• Strong expertise in Data Vault 2.0, Dimensional Modelling, Relational Modelling, Data Warehousing, Enterprise Data Architecture
• Experience with modelling tools at least in one of the following Erwin, ER/Studio, SAP PowerDesigner or Lucidchart

Reporting & BI Tools

• Hands-on experience with one or more reporting and analytics platforms like Power BI, MicroStrategy (MSTR), Tableau, Qlik Sense/QlikView, SSRS