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 Aonu2019s 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 u201cGlobal Wellbeing Daysu201d 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.
#LI-KN2
2575560
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 Aonu2019s 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 u201cGlobal Wellbeing Daysu201d 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.
#LI-KN2…