Data Integrity Associate Consultant in London

Do you have the skills needed to lead complex pension data cleanse and integrity projects? Do you have strong Defined Benefit (DB) scheme knowledge, with the ability to investigate data issues and design pragmatic solutions?

We are looking for a driven individual to join our Data Solutions Team, within Aon’s UK Retirement business. This is a team which brings together specialists from across our business to deliver project work for clients in areas such as data services, benefit rectification, GMP rectification and system implementation. This is a hybrid role with the flexibility to work both virtually and from any of our UK offices.

Aon is in the business of better decisions. At Aon, we shape decisions for the better to protect and enrich the lives of people around the world. As an organisation, we are united through trust as one inclusive, diverse team, and we are passionate about helping our colleagues and clients succeed.

What the day will look like:

• Lead the delivery of pension data cleanse and integrity projects, taking ownership of the full project lifecycle.
• Analyse scheme data to identify inconsistencies, gaps and errors across member populations.
• Design and implement effective data cleanse strategies, including bulk solutions, assumptions-based approaches and targeted file reviews.
• Extract, manipulate and validate pension data, ensuring outputs meet agreed standards and requirements.
• Work with modelling and system teams to implement data corrections and calculation updates.
• Liaise with multiple stakeholders, including consultants, administrators, specialist teams, and external insurers to understand requirements and support decision-making.
• Help devise strategies for carrying out data work within agreed timelines, ensuring delivery is aligned to project objectives.
• Identify risks and issues, working with stakeholders to mitigate and manage these effectively.
• Contribute to developing others in the team and inputting into process improvement and standardisation activities.

How this opportunity is different:

• This is a specialist role focused on pension data integrity, sitting at the heart of complex pension transformation and settlement projects.
• You will gain exposure to a wide range of work, including data cleanse, benefit correction and system implementation activities.
• Your work will directly influence critical client outcomes, particularly where data quality underpins major decisions such as buy-out or remediation.
• You will work with a broad network of colleagues across the UK Retirement business, quickly building strong relationships and expertise.
• The role offers fast-paced development, with opportunities to deepen both technical and consulting capability as data challenges evolve.

Skills and experience that will lead to success:

• Strong knowledge of UK Defined Benefit pension schemes, including benefit structure, administration and calculation.
• Proven experience delivering pension data cleanse, remediation or transformation activity.
• Ability to interrogate complex datasets, identify root causes and translate findings into practical solutions.
• Familiarity with pension administration data, systems and end-to-end processes.
• Strong Excel skills, including the ability to manipulate and analyse large datasets effectively.
• Some experience with SQL (or similar data querying tools) would be advantageous.
• Strong risk awareness, with the ability to identify issues early and work with stakeholders to mitigate effectively.
• Excellent communication and relationship-building skills, able to engage credibly across technical and non-technical audiences.
• Proactive and self-motivated, with a strong sense of ownership and a focus on delivering high-quality outcomes.

How we support our colleagues:

In addition to our comprehensive benefits package, we encourage a diverse workforce. Plus, our agile, inclusive environment allows you to manage your wellbeing and work/life balance, ensuring you can be your best self at Aon. Furthermore, all colleagues enjoy two “Global Wellbeing Days” each year, encouraging you to take time to focus on yourself. We offer a variety of working style solutions, but we also recognise that flexibility goes beyond just the place of work... and we are all for it. We call this Smart Working!

Our continuous learning culture inspires and equips you to learn, share and grow, helping you achieve your fullest potential. As a result, at Aon, you are more connected, more relevant, and more valued.

We provide individuals with disabilities reasonable accommodations to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment in accordance with applicable law. Please contact us to request an accommodation.

Aon values an innovative, diverse workplace where all colleagues feel empowered to be their authentic selves. Aon is proud to be an equal opportunity workplace.