Pensions System Calculation and Data Analyst

London
9 months ago
Applications closed

Related Jobs

View all jobs

Lead Data Engineer

Data Engineer (18 Months FTC)

Data Engineer

Senior Data Engineer (AWS, Airflow, Python)

Data Engineer

Data Engineer

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 implementation, scheme data extracts, reporting, pension increases and Benefit Statements) 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.

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

Desirable

Stong knowledge and experience of UK pension arrangements

Essential

Previous systems support experience would be an advantage

Essential

Experience with handling large volumes of personal data

Essential

Strong Microsoft Excel and Word skills

Essential

Strong understanding of manual pension benefit calculations

Essential

Analytical and problem-solving skills

Essential

Strong Microsoft Power BI skills

Desirable

Advanced SQL skills

Desirable

Advanced VBA skills

Desirable

Previous Altair/Axise (heywood) administration system experience

Desirable

Personal skills and key competencies

(including JM behavioural competencies)

Detail oriented and meticulous

Essential

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

Essential

Very good communication skills

Essential

High degree of numeracy

Essential

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

Essential

Able to work to deadlines

Essential

Team orientated individual with good interpersonal skills

Essential

Subscribe to Future Tech Insights for the latest jobs & insights, direct to your inbox.

By subscribing, you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

Careers

How Many Data Engineering Tools Do You Need to Know to Get a Data Engineering Job?

If you’re aiming for a career in data engineering, it can feel like you’re staring at a never-ending list of tools and technologies — SQL, Python, Spark, Kafka, Airflow, dbt, Snowflake, Redshift, Terraform, Kubernetes, and the list goes on. Scroll job boards and LinkedIn, and it’s easy to conclude that unless you have experience with every modern tool in the data stack, you won’t even get a callback. Here’s the honest truth most data engineering hiring managers will quietly agree with: 👉 They don’t hire you because you know every tool — they hire you because you can solve real data problems with the tools you know. Tools matter. But only in service of outcomes. Jobs are won by candidates who know why a technology is used, when to use it, and how to explain their decisions. So how many data engineering tools do you actually need to know to get a job? For most job seekers, the answer is far fewer than you think — but you do need them in the right combination and order. This article breaks down what employers really expect, which tools are core, which are role-specific, and how to focus your learning so you look capable and employable rather than overwhelmed.

Jobs

What Hiring Managers Look for First in Data Engineering Job Applications (UK Guide)

If you’re applying for data engineering jobs in the UK, the first thing to understand is this: Hiring managers don’t read every word of your CV. They scan it. They look for signals of relevance, credibility, delivery and collaboration — and if they don’t see the right signals quickly, your application may never get a second look. In data engineering, hiring managers are especially focused on whether you can build and operate reliable, scalable data systems, handle real-world data challenges and work effectively with analytics, BI, data science and engineering teams. This guide breaks down exactly what they look at first in your application — and how to shape your CV, portfolio and cover letter so you stand out.

Education

The Skills Gap in Data Engineering Jobs: What Universities Aren’t Teaching

Data engineering has quietly become one of the most critical roles in the modern technology stack. While data science and AI often receive the spotlight, data engineers are the professionals who design, build and maintain the systems that make data usable at scale. Across the UK, demand for data engineers continues to rise. Organisations in finance, retail, healthcare, government, media and technology all report difficulty hiring candidates with the right skills. Salaries remain strong, and experienced professionals are in short supply. Yet despite this demand, many graduates with degrees in computer science, data science or related disciplines struggle to secure data engineering roles. The reason is not academic ability. It is a persistent skills gap between university education and real-world data engineering work. This article explores that gap in depth: what universities teach well, what they consistently miss, why the gap exists, what employers actually want, and how jobseekers can bridge the divide to build successful careers in data engineering.

🍪 We use cookies to enhance your browsing experience on our website. By continuing to use this site, you consent to the use of cookies as described in our Cookie Policy. You can review our Cookie Policy for more information.