Data Modelling and Business Analysis Manager

Ernst & Young LLP ( EY India ); Chennai; Presencial; INR 3.500.000 - 6.500.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Professional development

Progression plan

Supportive culture

Descripción de la vacante

EY GDS – Data and Analytics (D&A) – Data Modeller and Analyst – Insurance role is based in EY India’s Chennai location. The candidate will lead data modeling efforts, define data standards, and drive governance for insurance projects within EY GDS.

The role emphasizes data transformation, migration, and analytics, with mentoring responsibilities and collaboration across stakeholders, architects, and delivery teams to ensure high-quality data solutions.

Formación

• Insurance domain experience with policy administration, underwriting, claims; data modelling mandatory.
• Minimum 7+ years of hands-on data modelling experience.
• Strong Data Vault 2.0, dimensional modelling, and data warehousing expertise.
• Hands-on experience with one or more reporting/BI platforms (Power BI, MSTR, Tableau).
• Advanced SQL and data integration, ETL/ELT processes; familiarity with cloud platforms.

Responsabilidades

• Lead business analysis and stakeholder management across insurance projects.
• Deliver end-to-end data transformation, migration, and reporting programmes.
• Define data models, data governance, and data quality controls.
• Mentor teams and contribute to EY’s Data & Analytics practice through accelerators and reusable assets.

Conocimientos

Data modelling

Data Vault 2.0

Data warehousing

SQL

ETL/ELT

Power BI

Stakeholder mgmt

Azure

GCP

Herramientas

Erwin

ER/Studio

PowerDesigner

Lucidchart

Descripción del empleo

EY - GDS Consulting - AI And DATA - Data Modeller - Data Vault - Manager At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all. EY GDS – Data and Analytics (D&A) – Functional Data Modeller and Analyst – Insurance (Manager)

The opportunity

As part of our EY-GDS D&A (Data and Analytics) team, we help our clients solve complex business challenges with the help of data and technology. We dive deep into data to extract the greatest value and discover opportunities in key business and functions like Banking, Insurance, Manufacturing, Healthcare, Retail, Manufacturing and Auto, Supply Chain, and Finance

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 Data 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. Technical Skills Advanced SQL (mandatory) Strong understanding of Data Warehousing, ETL/ELT Processes, Data Integration, APIs and Data Interfaces Experience with databases like SQL Server, Oracle, PostgreSQL, Snowflake, Azure SQL Exposure to at least one cloud platforms: Azure, AWS, Google Cloud Platform (GCP). Experience 10-15+ years of experience in Data Consulting, Data Management, Business Analysis, Data Migration, and Analytics. 7+ years of Data Modelling experience, including extensive Data Vault 2.0 implementation experience. Proven experience leading large‑scale data transformation and migration programmes. Experience within the UK Insurance market, including General Insurance, London Market Insurance, Syndicate and MGA environments London Market Insurance. Ideally, you’ll also have Strong project management skills Client management skills Solutioning skills What we look for People with technical experience and enthusiasm to learn new things in this fast‑moving environment

What working at EY offers

At EY, we’re dedicated to helping our clients, from start‑ups to Fortune 500 companies — and the work we do with them is as varied as they are. You get to work with inspiring and meaningful projects. Our focus is education and coaching alongside practical experience to ensure your personal development. We value our employees, and you will be able to control your own development with an individual progression plan. You will quickly grow into a responsible role with challenging and stimulating assignments. Moreover, you will be part of an interdisciplinary environment that emphasizes high quality and knowledge exchange. Plus, we offer:

• Support, coaching and feedback from some of the most engaging colleagues around
• Opportunities to develop new skills and progress your career
• The freedom and flexibility to handle your role in a way that’s right for you EY | Building a better working world EY exists to build a better working world, helping to create long‑term value for clients, people and society and build trust in the capital markets. Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate. Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.

Experience Level

Mid Level