Techno-Functional Data Consultant - Multiple Teams
No salary listed
Senior, Expert
Chennai, Tamil Nadu, India
In Person
Data & AnalyticsData Management
About the job
Requirements
- Strong understanding of insurance business processes and data structures, including policy administration, underwriting, claims, billing and finance, customer management, broker management, and reinsurance.
- Strong business and data analysis skills, including gathering and documenting business requirements.
- Expertise in data mapping, profiling, and validation, with a strong understanding of data governance and data quality frameworks.
- At least 5 years of hands-on data modelling experience, including Data Vault 2.0, dimensional modelling, relational data modelling, and data warehousing concepts.
- Experience with data modelling tools such as ERwin, ER/Studio, SAP PowerDesigner, Visio, or Lucidchart.
- Hands-on experience with one or more reporting and analytics platforms such as Power BI, MicroStrategy, Tableau, Qlik Sense, QlikView, or SSRS.
- Advanced SQL skills.
- Strong understanding of data warehousing, ETL/ELT processes, data integration, APIs, and data interfaces.
- Experience with databases such as SQL Server, Oracle, PostgreSQL, Snowflake, or Azure SQL.
- Exposure to at least one cloud platform: Azure, AWS, or Google Cloud Platform.
- At least 7 years of experience in data analysis, business analysis, data consulting, and data management, and at least 5 years of data modelling experience, including Data Vault modelling.
- Insurance industry experience is mandatory.
Responsibilities
- Collaborate with business users, subject matter experts, 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.
- Perform data profiling, gap analysis, and source-to-target data mapping.
- Analyze 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, and ensure data consistency and integrity across operational and analytical platforms.
- Design and maintain conceptual, logical, and physical data models; develop and maintain enterprise data models and data dictionaries; and design scalable data structures for operational and analytical solutions.
- Implement Data Vault 2.0 modelling (hubs, links, and satellites), dimensional modelling (star and snowflake schemas), canonical data models, and enterprise data models.
- Collaborate with data architects and engineering teams to align with enterprise architecture standards.
- Gather and define reporting and dashboard requirements, design reporting data models and analytical datasets, and support the development and optimization of business intelligence solutions.
- Work with analytics teams to ensure accurate reporting outputs, and define key performance indicators, metrics, and reporting standards.
- Support large-scale data migration and transformation programmes; develop source-to-target mapping specifications; define migration and reconciliation rules; and support system integration testing, user acceptance testing, and production validation.
- Work alongside data engineering and integration teams to ensure successful delivery.
- Deliver data migration, reporting, or digital transformation programmes.
Desired Qualifications
- Experience within the UK insurance market, including general insurance, London Market Insurance, syndicate, and managing general agent environments.
- Strong project management skills.
- Client management skills.
- Solutioning skills.
About the company
EY is a global professional services firm that offers consulting, assurance (audits), tax, and transaction advisory services to a wide range of clients including corporations, SMEs, and government entities. It earns fees for these services and uses its industry expertise and a worldwide network to help clients optimize operations, manage risk, and achieve sustainable growth. EY differentiates itself through its scale and reach, industry specialization, focus on end-to-end services, strategic alliances, and emphasis on innovation and sustainability, including improving audit quality and addressing digital economy needs and supply chain visibility. The company’s goal is to help clients navigate complex regulatory and business environments, transform finance and tax functions, and drive efficiency and resilience across their operations.
Company Size
1,001-5,000
Company Stage
N/A
Total Funding
N/A
Headquarters
London, United Kingdom
Founded
1991
Get referred to Ernst & Young
See people who can refer or advise you
Simplify's Take
What believers are saying
- EY.ai Agentic for Sales launched March 2, 2026 with Snowflake and Canva.
- EY uses client-zero deployments, scaling Copilot across 400,000 people by May 2026.
- EY’s 2026 AI assurance push monetizes client demand for governance, controls, and risk reviews.
What critics are saying
- Sabah filed RM2.4 billion audit-negligence claims against EY on July 30, 2026.
- EY set aside £188 million in March 2026 after NMC, Shell, and Made.com scrutiny.
- Repeated audit failures can destroy trust, trigger client defections, and shrink the franchise permanently.
What makes Ernst & Young unique
- EY Canvas processes 1.4 trillion journal-entry lines across 160,000 global audits.
- EY-Microsoft invested US$1b+ in May 2026 to industrialize enterprise AI delivery.
- EY launched agentic audit AI on April 7, 2026, spanning Assurance and AI assurance.
Help us improve and share your feedback! Did you find this helpful?
Benefits
- Professional Development Budget
- Flexible Work Hours
- Remote Work Options