Data Analyst-Pension Administration

About Aptia

Founded to shape the future of pensions, health, and insurance solutions, Aptia is a leading professional services firm dedicated to simplifying complexity for businesses and individuals. We bring together cutting-edge technology and deep industry expertise to help organisations navigate an evolving landscape with clarity and confidence.​

With a presence in the US, UK, India, and Portugal, we support over six million people and more than 1,100 clients, delivering solutions that drive efficiency, enhance financial security, and provide peace of mind.​

Our strength lies in the combination of smart technology and expert teams, ensuring that managing pensions, health, and insurance is more effective. By focusing on innovation, accessibility, and client success, we help businesses take care of their people, so they can focus on what they do best.

And we are expanding. Aptia Group is not only fueled by our investors' backing but also by our commitment to foster the growth and success of our people. At Aptia, we're investing heavily in learning and development, paving unique career paths for our colleagues.

Specialist. Responsive. Thoughtful. Our values aren't just words; they are the backbone of our business. Our team embodies our values daily, to surpass client expectations, evolve constantly and nurture genuine relationships for the long-term. 

Job requirements

Role Summary:

The Data Analyst works in the Quality Assurance and Audit (QA&A) Team which has responsibilities for contributing to the embedding of quality throughout the Aptia administration business.  

You will play a key role in ensuring accurate and timely data analysis is provided to our internal stakeholders in order to support our clients. You will work closely with both UK and India QA&A Data Analysts, ensuring data is processed efficiently and potential issues are identified early. 

You will include checking data production and manipulation and providing verification and sign off to the Aptia Administration teams prior to the data being issued.  The role of the Data Analyst is to:
•    Deliver accurate, high-quality data analysis within strict turnaround times.  
•    Streamline data analysis workflows and referral processes across Aptia’s operational teams.  
•    Coordinate incoming work and for efficient data analysis processing.  
•    Identify and report data quality issues to support compliance and reduce the risk of data breaches.  
•    Build proficiency with data analysis tools and processes through training and hands-on experience.  
•    Contribute to improving overall efficiency and capacity of the Data Analysis function within QA&A.
•    Work alongside QA&A and the wider First Line of Defence function to ensure a robust control environment is established across the Aptia administration business.

This role is a hybrid position where you will work from any of our Aptia offices, as well as from your home address.

Here's what you’ll be doing:
•    Carry out regular reviews of data extractions.
•    Analyse data that has been manipulated to ensure data integrity is maintained.
•     Sign off data extracts (including manipulation) before data can be issued.
•    Review and sign off the final data used for mail-merges ensuring communications are correct.
•    Ensure data is handled in line with GDPR requirements.
•    Assist in the provision of Root Cause Analysis (RCA) if required.
•    Contribute to changes in processes to strengthen controls around data handling.

Here’s what we’re looking for:

•    Advanced Microsoft Excel skills, including the use of Vlookups, Pivot table, and Index Match functions.
•    Ability to analyse and identify issues with data.
•    Strong analytical skills and attention to detail.
•    A strong quality focus.
•    Ability to work to short deadlines.
•    Strong communication skills and ability to collaborate and provide feedback across teams.
•    VBA coding is preferable but not essential. 
•    Experience with macros and mail merges is preferable but not essential. 
•    Experience in the pension industry is preferrable but not essential.
•    A strong control environment mentality.
 

How to apply

If you are interested in this role, then we’d love to hear from you. Please go ahead and click apply and submit your resume with appropriate contact information.

Aptia is committed to creating a diverse, inclusive and equitable work environment. At Aptia, fostering an equitable and inclusive environment for all our people to flourish is a priority. We are an equal opportunity employer and aim to attract and retain the best people without attention to age, background, disability, ethnic origin, family duties, political affiliation, race, religion, gender and sexual orientation.

If there are any reasonable adjustments we can make to the recruitment process to ensure it is accessible to you, we encourage you to reach out to us.