Pensions Data Analyst

Abenefit2u Limited; Greater London; Hybrid; GBP 32,000 - 52,000; Full time

Benefits offered by this job

Flexible working

Career development opportunities

Employee benefits

Job summary

Abenefit2u Limited in London seeks a detail-oriented Data Quality & Cleansing Analyst to ensure accuracy and integrity of pension scheme data. You will cleanse member data, resolve inconsistencies, and drive quality improvements across the scheme.

The role focuses on analysing large datasets, adhering to regulatory requirements, and collaborating with internal teams and external partners. A flexible hybrid work model with occasional office presence is available.

Qualifications

• Strong analytical skills with a focus on data quality and accuracy.
• Advanced Excel skills are essential.
• Knowledge of SQL would be ideal.
• Experience working with large datasets and data cleansing activities.
• Good understanding of regulatory requirements in pensions.
• At least two years of experience in a similar pensions role.

Responsibilities

• Ensure high standards of data accuracy, quality, and completeness
• Analyse, cleanse, and standardise large datasets to remove errors and inconsistencies
• Maintain and update databases to ensure data is current and reliable
• Identify data gaps and work with stakeholders to obtain missing or correct information
• Perform bulk data updates and corrections
• Conduct data quality assessments and produce regular analysis reports
• Collaborate with internal teams and external partners to support data improvement initiatives
• Follow established processes, project plans, and regulatory recordkeeping guidelines
• Investigate data issues proactively and recommend effective solutions

Skills

Analytical skills

Advanced Excel

SQL knowledge

Data cleansing

Pensions regulatory knowledge

Attention to detail

Stakeholder management

Communication

Job description

We are seeking a detail-oriented Data Quality & Cleansing Analyst to support the accuracy, integrity, and completeness of pension scheme data. This role focuses on obtaining, analysing, and cleansing member data to meet regulatory requirements and ensure it is fit for purpose. You will play a key role in identifying inconsistencies, resolving data issues, and improving overall data quality across the scheme

Key Responsibilities

• Ensure high standards of data accuracy, quality, and completeness
• Analyse, cleanse, and standardise large datasets to remove errors and inconsistencies
• Maintain and update databases to ensure data is current and reliable
• Identify data gaps and work with relevant stakeholders to obtain missing or correct information
• Perform bulk data updates and corrections
• Conduct data quality assessments and produce regular analysis reports
• Collaborate with internal teams and external partners to support data improvement initiatives
• Follow established processes, project plans, and regulatory recordkeeping guidelines
• Investigate data issues proactively and recommend effective solutions

Key Requirements

• Strong analytical skills with a focus on data quality and accuracy
• Advanced Excel skills
• Knowledge of SQL would be ideal
• Experience working with large datasets and performing data cleansing activities
• Ability to identify inconsistencies and implement corrective actions
• Good understanding of regulatory requirements in pensions
• At least two years of experience in a similar pensions role
• Strong attention to detail and problem-solving skills
• Effective communication and stakeholder management abilities

This is an excellent opportunity for someone who enjoys working with data and wants to contribute to maintaining high-quality standards within a regulated environment.

The modern office is in the heart of the City with easy transport links and the option to work from home up to three times per week (post probation period). Fantastic employee benefits and career development opportunities.

Pensions Systems "After 34 years with my last employer (over 2 periods of service) I decided to leave a few weeks ago. Huge thanks go to Dianne and her team from Abenefit2u for their support and guidance in making this step relatively easy. I would highly recommend Dianne and Abenefit2u. I'm now looking forward to ...