Data Analyst (Actuarial Modelling) in Edinburgh

At 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. We will consider flexible working arrangements for any of our roles and offer workplace adjustments to ensure you have the support you need to succeed in your role.

The Role:

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, structured, and tailored to support stakeholders in progressing with confidence.

Main 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.
• 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 independently within established frameworks, managing own workload and delivering high-quality outputs.

Key Knowledge, Skills and Experience:

• 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, in particular Databricks, Spark, Spark SQL and Python/pyspark.
• 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.
• Experience working in Financial Services or a similar heavily audited environment with an understanding of operating controls and producing audit evidence.
• Ability to prioritise tasks and manage workload effectively within defined processes.

Essential Skills:

• Financial Services experience.
• Data validation.
• Programming/scripting for data analysis.
• Data visualisation and reporting.
• Problem-solving and critical thinking.
• Attention to detail.
• People management.
• Communication and storytelling with data.
• Stakeholder engagement.
• Time and workload management.
• Continuous improvement mindset.

Desirable Skills:

• UK Life Insurance experience.
• Databricks, Spark, Spark SQL and Python/pyspark.

What we offer:

We’re dedicated to supporting your wellbeing and helping you thrive, both at work and beyond. Our benefits are designed to help you balance your professional and personal life, and financially plan for the future. Our UK benefits include:

• A valuable pension scheme of up to 18% (13% made up of employer contributions and 5% employee contributions).
• Access to our Share Save and Share Incentive Plan, alongside financial wellbeing and support services to help give you real confidence to put your money to work.
• Enjoy 38 days annual leave (including bank holidays), with the opportunity to purchase up to five extra days. Our Time Off When You Need It policy gives you the flexibility - to balance work and personal commitments.
• Our market-leading Inspiring Families policy includes comprehensive support and paid parental leave covering maternity, adoption, surrogacy, and paternity leave - because supporting families is an important part of our inclusive culture.
• Health & Protection cover includes Private Healthcare, Critical Illness cover and Life Assurance for you, with additional family options - for peace of mind.

At M&G we strive to have a diverse workforce and an inclusive culture, underpinned by our policies and employee-led networks that offer networking, support and development opportunities for the diverse communities our colleagues represent. We welcome applications from people of all backgrounds – across gender, ethnicity, age, disability, sexual orientation and more – including neurodivergent individuals, career returners and those with military service experience. M&G is proud to be Level 3: Disability Confident Leader under the UK Government Disability Confident employer scheme, and we welcome applications from candidates with disabilities and long-term health conditions. If you would like to participate in the initiative, you will have the opportunity to indicate this on your application. We are committed to providing an inclusive recruitment process. All candidates have the opportunity to request reasonable adjustments when applying. If you need any additional support at any stage, please contact us.