Home Based Senior Pensions Data Technician

Capita; United States; Remote; USD 60,000 - 100,000; Full time

Job summary

An established industry player is seeking a Senior Pensions Data Technician to join their dynamic Scheme Events team. This role involves managing complex data extraction, analysis, and processing to enhance pension outcomes. You will lead projects, ensure compliance with quality standards, and collaborate with clients and colleagues. The ideal candidate will possess strong experience in occupational pension schemes, technical calculations, and data analysis, particularly using Excel. Join this forward-thinking company to advance your career with a clear succession plan and enjoy a supportive work environment focused on professional growth.

Benefits

23 days holiday (rising to 27)

Company matched pension

Life assurance

Cycle2work scheme

15 weeks fully paid maternity leave

Voluntary benefits

Paid volunteering day

Access to Employee Network Groups

Qualifications

• Experience in DB pensions schemes and technical pensions calculations.
• Strong Excel skills for data analysis and project management.

Responsibilities

• Lead delivery of assigned projects and scheme events with accuracy.
• Review work of team members and provide technical support.

Skills

DB pensions scheme experience

Technical pensions calculations/analysis

Bulk data analysis

Pension administration and work management systems

Accuracy and attention to detail

Project Management Skills

Excel (filters, sorting, pivot tables)

Excel (formulas including lookups, IF statements)

Excel (importing data/text files)

A Level Maths or Degree with maths element

Education

A Level Maths

Degree with maths element

Work experience involving complex data analysis

Tools

Excel

Job description

We are looking for a Senior Pensions Data Technician to join the Scheme Events team in Capita Pensions Solutions.

You will be part of the team that owns and manages projects to cover complex extraction, analysis, cleansing and processing of pensions data to create better outcomes by bringing technical experience and leading on key projects, cyclical activities and scheme events to ensure they are completed in line with procedural and client requirements and within service level agreements.

You will have experience of working on a variety of occupational pension schemes with the ability to lead on the delivery of assigned projects and schemes. This role is perfect if you are an existing Senior Pensions Technician looking to work within a project-based role.

In return, Pensions Solutions will give you a clear succession plan to further your career.

Job title: Home Based Senior Pensions Data Technician

Job Description:

What you’ll be doing:

Key responsibilities

• To work with the Scheme Events Leads and Scheme Event Manager to deliver requirements for Scheme Events and Projects (time scales, deliverables, quality, sign off) and to input into the planning process.
• To review the work of Pensions Data Technicians and provide feedback and technical support.
• To be responsible for the accuracy and quality of Scheme Events and Projects.
• To correspond and build working relationships with clients and Capita colleagues.
• Regularly review the effectiveness and efficiency of existing systems and controls and make suggestions to continually enhance service delivery, improve processes and reduce potential complaints and business risks.
• Adhere to Quality Management Systems and comply with pensions and FCA regulations and initiatives, for example, Treating Customers Fairly (TCF).

Key tasks

• To lead on the delivery of assigned projects and scheme events.
• To promote the provision of a first-class experience for customers and to share knowledge and expertise with other team members.
• Performs data processes, including the following:
  • Running and specifying data extracts from the administration system including bespoke reports.
  • Transforming extracted data or data received into the required format and structure.
  • Performing and specifying data uploads to the administration system.
  • Building Mail Merge letters.
  • Performing bulk calculations in Excel.
  • Building and enhancing Excel templates and macros for regular jobs.
• Creating audit trails of all work and communications using the Team’s best practice.
• Testing bulk communications and calculations using the Team’s best practice.
• Providing project updates and time scales to Scheme Events Leads, Project Managers and Scheme Event Manager.

What we’re looking for:

Essential

• DB pensions scheme experience.
• Technical pensions calculations/analysis.
• Bulk data analysis.
• Pension administration and work management systems.
• Accuracy, attention to detail and quality management.
• Excel - Demonstrate the ability to use filters, sorting, pivot tables (rows, columns, grouping, filters and totalling).
• Excel – Can use formulas including lookups, IF and nested IF statements, date calculations and formatting of cells to specific guidelines.
• Excel - Can import data/text files and use data validation.
• Project Management Skills.
• A Level Maths or Degree with maths element or Work experience involving complex data analysis.

Desirable

• PMI Qualifications.

About Capita Pension Solutions

At Capita Pension Solutions (CPS) we continue to grow and evolve our Strategy & Product function. We are at another exciting point in that evolution, defining and executing CPS’s strategic goals as well as developing the next generation of market leading Products and Services. We have ambitious objectives and plans for 2025 and beyond.

What’s in it for you?

• 23 days’ holiday (rising to 27) with the opportunity to buy extra leave.
• Company matched pension, life assurance, a cycle2work scheme, 15 weeks’ fully paid maternity, adoption and shared parental leave, paternity pay of two weeks…and plenty more.
• Voluntary benefits designed to suit your lifestyle – from discounts on retail and socialising, to health & wellbeing, travel and technology.
• The opportunity to take a paid day out of the office, volunteering for our charity partners or a cause of your choice.
• Access to our Employee Network Groups, which represent every strand of diversity and allow colleagues to connect and learn from each other on an open, inclusive platform.

What we hope you’ll do next:

Choose ‘Apply now’ to fill out our short application, so that we can find out more about you.

We’re an equal opportunity and Disability Confident employer, which means we recruit and develop people based on their merit and passion. We’re committed to providing an inclusive, barrier-free recruitment process and working environment for everyone. If you need the job description or application form in an alternative format (such as large print or audio), or if you’d like to discuss other changes or support you might need going forward, please email Iqbal at [e-mail] or call 07784 237318 and we’ll get back to you. For more information about equal opportunities and process adjustments, please visit the Capita Careers website.

Access to Work can help candidates with a physical or mental health condition or disability to get support in the hiring process, including communication support at interviews such as a British Sign Language interpreter. If you require this support you can apply for this support at https://www.gov.uk/guidance/apply-for-communication-support-at-a-job-interview-if-you-have-a-disability-or-health-condition-access-to-work.

Location: Home-Based - GBR, United Kingdom

Time Type: Full time

Contract Type: Permanent