Project Actuarial Data Consultant

Intact Insurance (previously RSA); Greater London; Hybrid; GBP 80,000 - 100,000; Full time

Job summary

A leading insurance company is seeking a Project Actuarial Data Consultant to join its Corporate Actuarial team. In this role, you will support data enhancements, ensuring accurate data for the actuarial process. Key responsibilities include operating data extraction processes, data manipulation, and working closely with reserving actuaries. Ideal candidates will have extensive SQL and Excel experience, as well as a strong understanding of data systems. This position offers flexible working, an annual discretionary bonus, and opportunities for career development.

Benefits

Annual discretionary bonus

Up to 11% pension contributions

Hybrid working + flexible hours

25 days annual leave + bank holidays + buy/sell options

Health & wellbeing + virtual GP

Career development and mentoring

Inclusive culture + employee networks

Share investment options

Qualifications

• Extensive experience with SQL and Excel.
• In-depth understanding of data, systems, and infrastructure.
• Experience of manipulating and transforming data.
• Understanding of actuarial analysis requirements.
• Credibility to operate with UK Actuarial Managers.
• Strong relationship and trust-building skills.

Responsibilities

• Support Actuarial Function with data enhancements.
• Enhance processes to extract data from source systems.
• Transform data requirements within Corporate Actuarial.
• Automate processes to improve efficiency and consistency.
• Collaborate with reserving actuaries on data treatment.
• Work with the reserving team on relevant data aspects.

Skills

Extensive experience with SQL

Experience with Excel

Understanding of data systems and infrastructure

Data manipulation and transformation

Actuarial analysis understanding

Relationship building with stakeholders

Job description

Intact Insurance is the new name for RSA in the UK, Ireland, and across Europe. It’s a new name and a new way to do business. Backed by global expertise and a commitment to service that feels different, we’re focused on making insurance simpler, faster, and more responsive.

Shape the future

We’re leading a transformation in insurance helping people, businesses and society prosper in good times and be resilient in bad times. When you join us, you’re not just taking a job, you’re stepping into a career where you can make a real difference.

Grow with us

We’re customer-driven, community-focused, and committed to helping our people grow. Whether you’re early in your journey or bringing years of experience, we’ll support you with the tools, flexibility, and opportunities to thrive.

Win as a Team

We are currently recruiting for a Project Actuarial Data Consultant to join our UK&I Corporate Actuarial team on a 12 month secondment.

You’ll make an impact by:

Your role is to support the Actuarial Function and Operational team in delivering data enhancements to the data responsibilities for the team, ensuring this accurately feeds into the actuarial process. The key purpose of your role is responsibility for extracting, transferring and loading all kinds of data required for the Corporate Actuarial process as well as associated controls and validations. These processes are run monthly, quarterly and annually as required. The outputs are used to generate the base products (such as reporting tables and ResQ input files) that form the foundation of the data inputs to the Corporate Actuarial process (e.g. reserve review analysis, SII/UK, IFRS17, audit, self‑service) and onwards reporting.

Some of the key accountabilities are as follows:

• Operation and enhancement of specific processes that support the extract of data from a variety of source systems or databases, and the provision of required data within the Corporate Actuarial team or to wider stakeholders.
• Manipulate and Transform all data requirements within the Corporate Actuarial function. Act as actuarial custodian of the data we require and operate the system of engagement around how the Corporate Actuarial team access and use that data.
• Enhancement and production of base data & MI products (such as base actuarial data table, ResQ inputs, base results tables, hand‑off viewer tables, Solvency UK TP cubes) required for Corporate Actuarial work.
• Automation of process wherever possible and constant drive to improve efficiency, consistency of data/process and minimise the need for manual steps.
• Understand our data, our multiple systems, and our processes and changes, and how it all needs to consolidate and come together for Corporate Actuarial needs.
• Agreeing treatment in data solutions with the reserving actuaries on relevant matters such as exchange rate treatment, or different claim types.
• Work with the reserving team to help interpret data aspects of systems and environment changes and how these should be considered for actuarial needs.

Your skills and experience:

Skills required to be successful in your role:

• Extensive experience with SQL and Excel
• In depth understanding of data, systems and infrastructure
• Experience of Manipulating and Transforming data
• An understanding of actuarial analysis requirements to ensure data needs are appropriately addressed
• Credibility to operate in support of the UK Actuarial Managers, and senior colleagues from all other functions who are involved with data and systems across the business.
• Relationship and trust building with stakeholders is paramount

Why You’ll Love It Here

Being part of our team means you’ll have the support and freedom to bring your best self to work each day. As a permanent member, here’s what you can look forward to

• Annual discretionary bonus
• Up to 11% pension contributions
• Hybrid working + flexible hours
• 25 days annual leave + bank holidays + buy/sell options
• Health & wellbeing + virtual GP
• Career development and mentoring
• Inclusive culture + employee networks
• Share investment options

Our DEI Commitment

We celebrate individuality and believe our differences make us stronger. We’re proud to foster a culture where everyone feels respected, valued, and empowered to thrive.

As an Equal Opportunity and Disability Confident Employer, we ensure fair consideration for all applicants and offer interviews to all disabled candidates who meet the essential criteria.

We understand that everyone’s circumstances are different and are happy to explore flexible working options such as reduced hours or job shares to support work–life balance.

If you meet the core criteria but not every requirement, we’d still love to hear from you. Let’s explore how this role could support your next career step. If you need adjustments during the recruitment process, just let us know we’re here to support you.