Pension Insurance Corporation (“PIC”) provides secure retirement incomes through comprehensive risk management and excellence in asset and liability management, as well as exceptional customer service. Our purpose is to pay the pensions of our current and future policyholders. We achieve our purpose by setting Companywide strategic objectives and driving a healthy culture based on our PIC Values of Resilient, Adaptable, and Loyal.
Apply (by clicking the relevant button) after checking through all the related job information below.Role purpose
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.
Specific accountabilities assigned to the role of Policy Data Management Analyst within the Customer Operations function:
- Perform scheme and treaty onboarding through analysis of scheme benefit structures, data reconciliation, system preparation and calculation analysis
- Assist with quarterly data updates by preparing data and analysing results of calculations
- Raise and chase data issues with third‑party administrators, Pension Services, Reinsurance Ops and Transitions in relation to the above workstreams
- Raise and chase file delivery issues with third‑party administrators
- Process new scheme and reinsurance business through setting up scheme and treaty details in the PDM system and provide outputs to the New Business Modelling team.
- Respond to queries raised by experience actuaries, often involving in‑depth analysis of the underlying data within the PDM system
- Draft, review and maintain procedure guides for the various PDM Team processes.
- Identify issues with the Policy Reference Numbers in intercepted movements and resolve as appropriate
- Review Policy Reference Numbers and policy statuses for new treaties being loaded to the LISA reinsurance administration system
RequirementsKnowledge
- 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. xwzovoh
- Good working knowledge of Power BI, SQL, VBA and RAFM an advantage.
Skills
- 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
Experience
- 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
…