Impress employers and recruiters.
Choose from hundreds of resume examples.

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

This role involves supporting various aspects of the overall BPA and Reinsurance implementation journeys by analyzing scheme benefit specifications and large pension datasets to identify system development requirements.

Responsibilities

• Assist in analyzing scheme benefit specifications and large pension datasets to identify system development requirements for our outsourced administrator’s framework.
• Provide support to the BPA implementation process by assisting in the data and payroll reconciliation process, analyzing data migration reports, replicating the process, and challenging any differences.
• Support the validation of scheme data during implementation and data cleanse processes, ensuring all data sets are complete, accurate, and in line with benefit specifications, querying any differences.
• Update models to align with benefit specifications for bulk validations and payroll projections, and investigate/query any discrepancies.
• Support the Transition Manager at Trustee and Scheme Administrator meetings by discussing data issues found and seeing them through to rectification during data cleanse.
• Build and maintain relationships with internal stakeholders, Phoenix’s outsourced administrator, scheme administrators, and Trustees.
• Assist in the production of detailed and accurate management information to support the oversight of BPA and Reinsurance performance.

Requirements

• Knowledge of Defined Benefit (DB) pensions, Bulk Purchase Annuities (BPA), or similar long-term savings products, or the willingness and ability to develop expertise in these areas.
• Experience analyzing, manipulating, and validating large datasets, ideally within a pensions, insurance, or financial services environment.
• Strong Microsoft Excel skills, including formulas, lookups, pivot tables, reconciliations, and data quality checks.
• Experience performing data validation, cleansing, and quality assurance activities to ensure data accuracy and integrity.
• Ability to investigate data discrepancies, exceptions, and anomalies, supporting issue resolution and root cause analysis.
• Experience producing and documenting data analysis, reports, reconciliations, and findings to support business, customer, and regulatory requirements.

Skills

• Microsoft Excel
• Formulas
• Lookups
• Pivot tables
• Reconciliations
• Data quality checks
• Data validation
• Data cleansing
• Data analysis
• Reporting
• Issue resolution
• Root cause analysis

Location

• London

Work Type

• Permanent
• Hybrid
• Part-time
• Job-share

Experience Level

• Depending on experience

Salary/Compensations

• From £33,500

Benefits

• Discretionary bonus
• Private medical cover
• 38 days annual leave
• Excellent pension
• 12x salary life assurance
• Career breaks
• Income protection
• 3x volunteering days

About the Company

• Standard Life is a retirement specialist focused entirely on retirement savings and income.
• We champion the belief that everyone’s journey to and through retirement can be better.
• For more than 200 years, we’ve been helping our customers plan and prepare for their financial futures.
• Life today is increasingly complicated, uncertain and unpredictable.
• We offer our colleagues flexibility, trust, and benefits that work for whatever life brings.
• In return we expect curiosity, connection, accountability, and high standards.
• We make room for what matters - so you can bring your best, every day.

Equal Opportunity

• We are committed to ensuring that everyone feels accepted and welcome applicants from all backgrounds.
• If your experience looks different from what we’ve advertised and you believe that you can bring value to the role, we’d love to hear from you.
• If you require any adjustments to the recruitment process, please let us know so we can help you to be at your best.