Pension Data Analyst

Alexander Lloyd; London; On-site; GBP 40,000 - 55,000; Full time

Job summary

A leading company is seeking a Pensions Data Analyst to manage complex pension data extraction and analysis. The role involves collaborating on projects, ensuring compliance with regulations, and maintaining client relationships while delivering high-quality service.

Qualifications

• Experience with Defined Benefit (DB) and/or Defined Contribution (DC) pension schemes.
• Strong pension calculations and bulk data analysis skills.

Responsibilities

• Collaborate with Scheme Events Leads and Managers to deliver scheme events.
• Lead the delivery of assigned projects and scheme events.
• Perform complex data processes in Excel.

Skills

Attention to Detail

Project Management

Pension Calculations

Data Analysis

Education

A-level Maths

Degree with Maths Element

Tools

Excel

Job description

Our client is seeking a Pensions Data Analyst to work on complex pension data extraction, analysis, cleansing, and processing. As a Pension Data Analyst, you will be responsible for delivering scheme events and projects in line with client and contractual requirements, ensuring high-quality service and compliance with industry regulations.

Key Responsibilities

1. Collaborate with Scheme Events Leads and Managers to deliver scheme events and projects.
2. Review the work of Pensions Data Technicians, providing feedback and technical support.
3. Ensure accuracy and quality in scheme event processing and project delivery.
4. Maintain strong client relationships and liaise with internal colleagues.
5. Identify and report risks, breaches, and potential business improvements.
6. Adhere to quality management systems and pensions/FCA regulations.
7. Assist the management team with service delivery and business support tasks.

Key Tasks

1. Lead the delivery of assigned projects and scheme events.
2. Perform complex data processes, including extractions, transformations, uploads, and bulk calculations in Excel.
3. Build and enhance Excel templates and macros for efficiency.
4. Maintain audit trails and ensure quality control of communications and calculations.
5. Provide project updates and time estimates to stakeholders.
6. Act as a Subject Matter Expert for internal change initiatives and client projects.

What We're Looking For

Essential Skills & Experience

• Experience with Defined Benefit (DB) and/or Defined Contribution (DC) pension schemes.
• Strong pension calculations and bulk data analysis skills.
• Proficiency in pension administration and work management systems.
• High attention to detail and quality management.
• Advanced Excel skills, including:
• Filters, sorting, and pivot tables.
• Lookups, IF and nested IF statements, date calculations, and formatting.
• Importing data/text files and using data validation.
• Project management skills.
• A-level Maths, a Degree with a maths element, or equivalent experience in complex data analysis.

Please quote 51351 when calling Sarah at Alexander Lloyd or email them at [e-mail]. This is only one of many vacancies we are handling. Alexander Lloyd is a specialist within Financial Services recruitment, covering areas such as Employee Benefits, Compliance, Pensions, Group Risk, Paraplanners, Sales Support, T&C, etc.

Due to the high volume of applications, we cannot respond to each individually. If you do not hear back, you have not been shortlisted. Please check our website www.alexanderlloyd.co.uk for other roles that may interest you.