Pension System Calculation and Data Analyst

Guidant Global; London; Remote; GBP 35,000 - 55,000; Full time

Job summary

A leading company in the pension sector seeks a Pension System Calculation and Data Analyst in London. The role encompasses support for the pension administration system, data analysis, and involvement in project-based activities. Ideal candidates will possess strong analytical skills, experience with pension arrangements, and advanced capabilities in Microsoft Excel and SQL, among other relevant competencies.

Qualifications

• Strong knowledge and experience of UK pension arrangements.
• Previous systems support experience is advantageous.
• Experienced in handling large volumes of personal data.

Responsibilities

• Support the maintenance and development of the pension administration system (altair).
• Assist in data projects and ensure timely delivery of data extracts.
• Carry out monthly reconciliations of payroll and HR files.

Skills

Analytical skills

Problem-solving skills

Detail oriented

Strong communication skills

Teamwork

Education

Degree level education

Tools

Microsoft Excel

Microsoft Word

SQL

VBA

Altair administration system

Job description

Social network you want to login/join with:

Pension System Calculation and Data Analyst, London

col-narrow-left

Client:

Location:

London, United Kingdom

Job Category:

Other

-

EU work permit required:

Yes

col-narrow-right

Job Reference:

080046514e80

Job Views:

8

Posted:

29.06.2025

Expiry Date:

13.08.2025

col-wide

Job Description:

Job purpose

To support the Pension & Reward Operations Manager with all aspects of the maintenance and development of the Pensions Administration System (altair).

To assist in production, management and processing of all data extracts and interfaces and to provide ongoing support to pension projects.

Principal accountabilities

• To support the maintenance and development of the pension administration system (altair) ensuring accuracy of all member records, benefit calculations, letters and workflows.
• Assist in the development and testing of pension system workflows, calculations and letters, including issue resolution, software release updates and change request development and implementation.
• Carry-out monthly reconciliations of payroll and HR files ensuring that the pension administration system is maintained and kept up to date.
• Work with the Pensions & Reward Operations Manager on all data projects (e.g. Pension Dashboard, scheme data extracts, data reporting and analysis, pension increases and Benefit Statements exercises) ensuring data is provided on time and in specified formats.
• Assist in production of regular interfaces to external suppliers, resolving any processing queries. Upload interfaces as required.
• Work with Pensions & Reward Operations Manager to ensure that all member records are updated correctly and support the processing of annual membership movement and contribution reconciliations.
• Produce management information within agreed timescales.
• To take on any other duties that are within the employee's skills and abilities whenever reasonably instructed.

Organisational structure

Scope

§ To assist in all aspects of the maintenance and development of the UK pension administration system.

§ Ensure data extracts and interfaces are provided within agreed timescales and format.

§ Contribute to the development of the day-to-day administration of the UK pension scheme, for example changes to process workflows, member communications and improvement in reporting activities, as well as project based activities.

§ To assist in the delivery of all reporting and data analytical requirement.

This describes what is required to do the job, it may not describe the current job holder but should describe the typical attributes or traits needed for success in the position.

Qualifications/ knowledge/ experience

(Technical/ professional knowledge and skills competency)

Educated to degree level

Stong knowledge and experience of UK pension arrangements

Previous systems support experience would be an advantage

Experience with handling large volumes of personal data

Strong Microsoft Excel and Word skills

Strong understanding of manual pension benefit calculations

Analytical and problem-solving skills

Advanced SQL skills

Advanced VBA skills

Previous Altair (heywood) administration system experience

Personal skills and key competencies

Detail oriented and meticulous

Work on own initiative (as role will be primarily home-based)

Very good communication skills

High degree of numeracy

Flexible and committed and willing to take on ad-hoc tasks as required

Able to work to deadlines

Team orientated individual with good interpersonal skills