A

Aptia

Data Analyst

London·Hybrid·3d ago

Salary

Competitive salary

Work type

Hybrid

Level

mid

Category

Analytics & BI

About the role

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

The Role

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 be checking data production and manipulation of data and providing verification and sign off to the Aptia Administration teams prior to the data being issued externally.

The Data Analyst will act as an ambassador for Aptia at all times and will be conversant with best practice and will continually look to improve and embed best practice and excellence.

This role is a hybrid position where you will work from any nearest Aptia office in UK as well as from your home address.

What you will 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.

  • Assist in preparing reports relating to Data Analysis within the QA&A function.

Here's what we're looking for:

  • Advanced Microsoft Excel skills, including the use of Vlookups, Pivot table, and Index Match functions.
  • VBA coding is preferable but not essential.
  • Experience with macros and mail merges is preferable but not essential.
  • 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.

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.

Tech stack

Excel