Pensions System Calculation and Data Analyst

London
1 week ago
Create job alert

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

Related Jobs

View all jobs

Analytics Engineering Manager

KS2 Teacher

System Developer

ERP System Analyst

MDM Manager

Application Support Analyst

Get the latest insights and jobs direct. Sign up for our newsletter.

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

Industry Insights

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

Data Engineering Jobs at Newly Funded UK Start-ups: Q3 2025 Investment Tracker

Data. It’s the critical lifeblood of every forward-thinking organisation, fueling everything from strategic decision-making to real-time analytics. As data volumes skyrocket and technologies mature, the UK has distinguished itself as a frontrunner in data innovation. A robust venture capital scene, government-backed initiatives, and a wealth of academic talent have created fertile ground for data-centric start-ups across the country. In this Q3 2025 Investment Tracker, we’ll delve into the newly funded UK start-ups shaping the future of data engineering. More importantly, we’ll explore the rich job opportunities that have emerged alongside these funding announcements. From building scalable ETL (Extract, Transform, Load) pipelines to architecting data warehouses and implementing advanced data governance frameworks, data engineers, architects, and analysts have an incredible array of roles to pursue. If you’re eager to elevate your career in data engineering, read on for insights into the most dynamic start-ups, their fresh capital injections, and the skill sets they’re hungry for.

Portfolio Projects That Get You Hired for Data Engineering Jobs (With Real GitHub Examples)

Data is increasingly the lifeblood of businesses, driving everything from product development to customer experience. At the centre of this revolution are data engineers—professionals responsible for building robust data pipelines, architecting scalable storage solutions, and preparing data for analytics and machine learning. If you’re looking to land a role in this exciting and high-demand field, a strong CV is only part of the puzzle. You also need a compelling data engineering portfolio that shows you can roll up your sleeves and deliver real-world results. In this guide, we’ll cover: Why a data engineering portfolio is crucial for standing out in the job market. Choosing the right projects for your target data engineering roles. Real GitHub examples that demonstrate best practices in data pipeline creation, cloud deployments, and more. Actionable project ideas you can start right now, from building ETL pipelines to implementing real-time streaming solutions. Best practices for structuring your GitHub repositories and showcasing your work effectively. By the end, you’ll know exactly how to build and present a portfolio that resonates with hiring managers—and when you’re ready to take the next step, don’t forget to upload your CV on DataEngineeringJobs.co.uk. Our platform connects top data engineering talent with companies that need your skills, ensuring your portfolio gets the attention it deserves.

Data Engineering Job Interview Warm‑Up: 30 Real Coding & System‑Design Questions

The world of data engineering has rapidly emerged as a critical pillar for businesses, enabling them to extract insights from vast amounts of information and power data-driven decision-making. From building scalable ETL pipelines to designing real-time streaming infrastructures and cloud data warehouses, data engineers are in high demand across every industry—from tech giants to healthcare providers to financial institutions. If you’re seeking a data engineering role, you may already know that interviews can be rigorous, spanning software development, database design, distributed systems, and cloud computing. Many organisations need engineers who can handle both traditional batch processing and cutting-edge real-time analytics frameworks, all while keeping data secure, consistent, and optimised. In this guide, we’ll explore 30 real coding & system-design questions that often come up in data engineering interviews. From classic coding challenges to architecture-focused scenarios, these questions will help you gauge your readiness and build confidence before stepping into that interview room. If you’re actively searching for new data engineering opportunities in the UK, www.dataengineeringjobs.co.uk is a fantastic resource. It features a wide range of vacancies—from junior data engineering positions to senior-level cloud architecture roles. Let’s dive in so you can approach your next interview with insight and poise.