Aon
UK Retirement Data Solutions Associate Consultant
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
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 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
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
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
Get help with your application
Your very own career expert that helps elevate your application to the next level.
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 on ReasonableAdjustments@Aon.com
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.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills