Hybrid Actuarial Data Analyst, Pensions Onboarding

at Pension Insurance Corporation plc

• Job title: Actuarial Data Analyst, Pensions Onboarding
• Job type: Full Time
• Experience level: Mid level, Senior
• Salary: Not specified
• Degree requirement: Bachelor's Degree
• Tech skills: SQL, VBA
• Location requirements: Hybrid, London, United Kingdom

About the role

• Actuarial Data Analyst managing onboarding processes for pensions at Pension Insurance Corporation. Collaborating with stakeholders to ensure data integrity and seamless transitions in the PDM system.

Responsibilities

• This role sits within the Policy Data Management (PDM) Team, whose responsibility forms part of the end-to-end transition of new business into PIC's operating model.
• The PDM team works closely with many stakeholders (namely third-party administrators, Originations, Transitions, Pension Services and Reinsurance Operations, Finance Actuarial and Finance Accounts) to identify and validate all necessary data to support its operations and all downstream systems and processes.
• Effectively collaborate with all stakeholders to secure their buy-in and implement improvements to systems, processes, and technology, as appropriate.
• Apply knowledge and insights concerning the onboarding of new pension schemes and reinsurance treaties to the Policy Data Management (PDM) system and how this impacts our policyholders.
• Deliver strong business outcomes relating to capital, profitability, the Company brand and market reputation whilst achieving positive outcomes to our policyholders and internal customers on a consistent basis.
• Performing scheme and treaty onboarding through analysis of scheme benefit structures, data reconciliation, system preparation and calculation analysis.
• Assisting with quarterly data updates by preparing data and analysing results of calculations.
• Raising and chasing data issues with third-party administrators, Pension Services, Reinsurance Ops and Transitions in relation to the above 2 workstreams.
• Raising and chasing file delivery issues with third-party administrators.
• Processing new scheme and reinsurance business through setting up scheme and treaty details in the PDM system and providing outputs to the New Business Modelling team.
• Responding to queries raised by experience actuaries, often involving in-depth analysis of the underlying data within the PDM system.
• Drafting, reviewing and maintaining procedure guides for the various PDM Team processes.
• Identifying issues with the Policy Reference Numbers in intercepted movements and resolving as appropriate.
• Reviewing Policy Reference Numbers and policy statuses for new treaties being loaded to the LISA reinsurance administration system.

Requirements

• Good knowledge of Defined Benefit Pension Schemes preferred.
• Basic knowledge of data analysis techniques used for data migration and data reconciliation.
• Knowledge of pension buy-ins and buy-outs.
• Advanced knowledge of MS Excel and MS Word a necessity.
• Good working knowledge of Power BI, SQL, VBA and RAFM an advantage.
• Strong organisational skills
• Strong communication skills
• Effective collaboration with key stakeholders
• Ability to persuade and influence both directly and indirectly
• Ability to manage own time and workload effectively
• Ability to organize work to meet deadlines
• Ability to work within defined procedures as recommended by functional teams
• Strong academic record in Mathematics, Statistics, Economics or Actuarial Science or related field, or working toward an APMI qualification
• Intermediate DB Pension experience
• Experience of complex data analysis work
• Experience working in a corporate or consulting environment.

Benefits

• In addition to a competitive base salary and the opportunity to participate in our annual, performance-related bonus plan, upon joining us here at Pension Insurance Corporation, you will get access to some great benefits, including private medical insurance
• 28 days' annual leave (excluding bank holidays)
• a generous pension scheme
• much more.