Actuarial Systems Consultant – 28921

The Emerald Group; Dorking; On-site; GBP 45,000 - 75,000; Full time

Job summary

The Emerald Group in Dorking, United Kingdom is hiring to develop, maintain and enhance actuarial systems and processes across teams. You will work with SQL, RAFM, Unify and other tools to support external reporting, pricing, reserving and capital calculations.

Requirements include a degree in a numerical subject and proven SQL/Excel proficiency, with RAFM, Unify, Emblem, R or Python familiarity a plus. Excellent communication and analytical skills are essential.

Qualifications

• Degree or other qualification in a numerical or analytical subject.
• Proven experience with SQL and Excel.

Responsibilities

• Develop and maintain SQL code used for reporting to external partners.
• Develop and maintain actuarial systems used for external reporting, pricing, reserving and capital calculations across Solvency II, US GAAP and UK GAAP.
• Ensure model accuracy through rigorous testing and validation.
• Support internal and external audit processes.
• Keep up to date on system and AI developments and share this knowledge with the actuarial teams.

Skills

SQL

Excel

Analytical thinking

Communication

Python

R

PowerQuery

RAFМ

Unify

Emblem

Education

Degree in numerical/analytical subject

Tools

SQL

RAFМ

Unify

Emblem

R

Python

PowerQuery

Job description

The purpose of this role is to develop, maintain and enhance Actuarial Systems and processes used across the actuarial teams, using SQL, RAFM, Unify and other programs.

• Location: Dorking
• Category: Life Actuarial
• Type: Permanent

Key Responsibilities (including but not limited to):

• Develop and maintain SQL code used for reporting to their external partners
• Develop and maintain actuarial systems used for external reporting, pricing, reserving and capital calculations across Solvency II, US GAAP and UK GAAP.
• Ensure model accuracy through rigorous testing and validation
• Support internal and external audit processes
• Keep up to date on system and AI developments and share this knowledge with the actuarial teams
• Embed and contribute to the requirements of Conduct Risk, Solvency II Systems of Governance, Treating Customers Fairly, Consumer Duty and the Risk Management Framework as it applies to the role and divisional activities and drive improvements as required
• Degree or other qualification in a numerical or analytical subject and/or a past or present student member of the Institute and Faculty of Actuaries (who has stopped studying) with proven experience
• Proficient in SQL and Excel, with proven experience. RAFM, Unify, Emblem, R, Python and PowerQuery knowledge or the ability to learn these systems
• Strong analytical and logical skills that can be applied in a systems-based environment
• Good communication and interpersonal skills, with the ability to liaise with other teams, always ensuring excellent levels of verbal and written communication