Pensions System Calculation and Data Analyst

London
8 months ago
Applications closed

Related Jobs

View all jobs

Head of DevOps and DataOps

Data Engineer

Data Engineer

Data Engineer

Junior SQL DBA

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.

How to Write a Data Engineering Job Ad That Attracts the Right People

Data engineering is the backbone of modern data-driven organisations. From analytics and machine learning to business intelligence and real-time platforms, data engineers build the pipelines, platforms and infrastructure that make data usable at scale. Yet many employers struggle to attract the right data engineering candidates. Job adverts often generate high application volumes, but few applicants have the practical skills needed to build and maintain production-grade data systems. At the same time, experienced data engineers skip over adverts that feel vague, unrealistic or misaligned with real-world data engineering work. In most cases, the issue is not a shortage of talent — it is the quality and clarity of the job advert. Data engineers are pragmatic, technically rigorous and highly selective. A poorly written job ad signals immature data practices and unclear expectations. A well-written one signals strong engineering culture and serious intent. This guide explains how to write a data engineering job ad that attracts the right people, improves applicant quality and positions your organisation as a credible data employer.

Maths for Data Engineering Jobs: The Only Topics You Actually Need (& How to Learn Them)

If you are applying for data engineering jobs in the UK, maths can feel like a vague requirement hiding behind phrases like “strong analytical skills”, “performance mindset” or “ability to reason about systems”. Most of the time, hiring managers are not looking for advanced theory. They want confidence with the handful of maths topics that show up in real pipelines: Rates, units & estimation (throughput, cost, latency, storage growth) Statistics for data quality & observability (distributions, percentiles, outliers, variance) Probability for streaming, sampling & approximate results (sketches like HyperLogLog++ & the logic behind false positives) Discrete maths for DAGs, partitioning & systems thinking (graphs, complexity, hashing) Optimisation intuition for SQL plans & Spark performance (joins, shuffles, partition strategy, “what is the bottleneck”) This article is written for UK job seekers targeting roles like Data Engineer, Analytics Engineer, Platform Data Engineer, Data Warehouse Engineer, Streaming Data Engineer or DataOps Engineer.

Neurodiversity in Data Engineering Careers: Turning Different Thinking into a Superpower

Every modern organisation runs on data – but without good data engineering, even the best dashboards & machine learning models are built on sand. Data engineers design the pipelines, platforms & tools that make data accurate, accessible & reliable. Those pipelines need people who can think in systems, spot patterns in messy logs, notice what others overlook & design elegant solutions to complex problems. That is exactly why data engineering can be such a strong fit for many neurodivergent people, including those with ADHD, autism & dyslexia. If you’re neurodivergent & considering a data engineering career, you might have heard comments like “you’re too disorganised for engineering”, “too literal for stakeholder work” or “too distracted for complex systems”. In reality, the traits that can make traditional office environments hard often line up beautifully with data engineering work. This guide is written for data engineering job seekers in the UK. We’ll cover: What neurodiversity means in a data engineering context How ADHD, autism & dyslexia strengths map to common data engineering tasks Practical workplace adjustments you can request under UK law How to talk about your neurodivergence in applications & interviews By the end, you’ll have a clearer sense of where you might thrive in data engineering – & how to turn “different thinking” into a genuine professional superpower.