Data Integrity Associate Consultant

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 team 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.

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 a comprehensive benefits package, we encourage a diverse workforce. We provide two Global Wellbeing Days each year and support a flexible, inclusive environment that promotes work/life balance. Our continuous learning culture inspires and equips you to learn, share and grow, helping you achieve your fullest potential. 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.