Senior Analyst - Methodology & Assumption

Mands Consulting Com; Mumbai; On-site; INR 600,000 - 900,000; Full time

Job summary

M&G India is seeking a data analytics professional to join the Methodology & Assumption (M&A) Actuarial Policyholder Data Team within the Actuarial Modelling & Valuation Centre of Excellence in Finance. You will work on a new data-validation and transformation solution for policyholder data used in actuarial modelling and setting assumptions.

The role involves operating, maintaining, and performing BAU updates to data pipelines, validating, transforming, and enriching data for

Qualifications

• Strong analytical capability with the ability to interpret and translate data into meaningful insights.
• Proficiency in data analysis tools, reporting platforms, and structured query languages.
• Understanding of data governance, data quality, and validation practices.
• Ability to communicate complex information in a clear, structured, and engaging way.
• Strong attention to detail and commitment to delivering accurate, high-quality work.

Responsibilities

• Ensure data integrity by applying validation, quality checks, and governance standards.
• Collaborate with stakeholders to understand data requirements and translate them into transformation logic and code that into the pipeline.
• Support internal and external audit queries with timely and comprehensive responses
• Apply data analysis techniques to answer queries raised by users of the data.
• Ensure all enhancements are appropriately documented and meet business requirements before implementation.
• Maintain process documentation, data dictionaries, and operational procedures

Skills

Analytical skills

Data analysis tools

Data governance

Data quality

Clear communication

Detail-oriented

Cross-functional collaboration

Task prioritization

Auditability & controls

Excel

Power BI

Python

Power Query

Dashboards

Education

Bachelor's Degree

Tools

Excel

Power BI

Python

Databricks

Spark

Spark SQL

Power Query

Job description

About M&G India

We are M&G India, the strategic innovation and digital hub for M&G. Established in 2003, we have offices in Mumbai and Pune.

Our teams work closely with colleagues across the Group worldwide to drive transformation, build digital capability, and support sustainable growth. By leveraging technology, AI, automation, and process excellence, we bring new ways of thinking to improve outcomes for both customers and colleagues.

Grounded in a vibrant culture with strong foundations, we are central to how M&G is transforming as a business.

About M&G

Our purpose is to give everyone real confidence to put their money to work. With a heritage dating back more than 175 years, we have a long history of innovation in savings and investments, combining asset management and insurance expertise to offer a wide range of solutions.

Our two distinct operating segments, Asset Management and Life, work together to provide access to balanced, long-term investment and savings solutions.

Through telling it like it is, owning it now, and moving it forward together with care and integrity; we are creating an exceptional place to work for exceptional talent.

Overall Job Purpose

Individual would be part of the Methodology & Assumption (M&A) Actuarial Policyholder Data Team within the Actuarial Modelling & Valuation Centre of Excellence in Finance.

A new solution for the validation and transformation of policyholder data used in actuarial modelling and assumption setting is being built.

This role will operate, maintain and make BAU updates to the new data pipelines which will validate, transform and enrich data for use in actuarial modelling and assumption setting. It will use its strong data analysis skills to investigate and resolve data issues found pre-emptively or those raised by stakeholders.

The role contributes to the continuous improvement of data processes, ensuring accuracy, consistency, and clarity in outputs while working within defined guidelines. Communication of findings is clear, escalating issues within the team.

Individual is accountable and responsible for the Model Points Data Production and Experience Analysis related tasks as assigned by the Team Manager. The person would act as necessary support to the team by carrying the tasks for the process with an acceptable standard of quality and within agreed timelines.

Primary Key Responsibilities

• Ensure data integrity by applying validation, quality checks, and governance standards.
• Collaborate with stakeholders to understand data requirements and translate them into transformation logic and code that into the pipeline.
• Support internal and external audit queries with timely and comprehensive responses
• Apply data analysis techniques to answer queries raised by users of the data.
• Ensure all enhancements are appropriately documented and meet business requirements before implementation.
• Maintain process documentation, data dictionaries, and operational procedures

Additional Responsibilities

• Produce clear and accurate reports, dashboards, and visualisations to support business decisions.
• Support the development and refinement of data processes, tools, and methodologies.
• Communicate findings in a concise, structured, and accessible way to both technical and non-technical audiences.
• Work with support from experience colleagues in the team within established frameworks, managing own workload and delivering high-quality outputs.
• Deliver high-quality outputs with strong attention to detail, ensuring accuracy, consistency, and compliance with agreed standards.

Key Stakeholder Management

Internal

M&G India Team manager

UK Team manager

Other senior stakeholders

Risk Team

External

Diligenta

PwC

WTW

Knowledge, Skills, Experience & Educational Qualification

Knowledge & Skills (Must Have) :

• Strong analytical capability with the ability to interpret and translate data into meaningful insights.
• Proficiency in data analysis tools, reporting platforms, and structured query languages,
• Understanding of data governance, data quality, and validation practices.
• Ability to communicate complex information in a clear, structured, and engaging way.
• Strong attention to detail and commitment to delivering accurate, high-quality work.
• Collaborative approach, with the ability to build effective working relationships across teams.
• Ability to prioritise tasks and manage workload effectively within defined processes.
• Time and workload management
• Continuous improvement mindset
• Experience maintaining documentation, controls, and governance evidence to support auditability and operational resilience
• Experience using Excel, Power BI, and/or Python to analyse data, automate checks, and produce reports or dashboards.
• Advanced Excel skills, including formulas, pivot tables, lookups, data validation, Power Query, and reconciliation techniques

Knowledge & Skills (Additional) :

• UK Life Insurance experience
• Databricks, Spark, Spark SQL and Python/PySpark
• Experience working in Financial Services or a similar heavily audited environment with an understanding of operating controls and producing audit evidence

Experience:

• 1-3 years of relevant Data Analytics experience (depending on role level)
• Financial services experience is very helpful

Educational Qualification:

• Bachelor s Degree / Master s Degree
• Any Data Analyst Certifications would be an advantage.