Graduate Programme - Data Solutions (Wealth Solutions)

An Actuarial Consulting Graduate role at Aon involving pension scheme valuations, financial modelling, risk analysis, and advising clients on retirement funding and investment risks, supported by a 10-month graduate development programme.

Better Decisions Begin with You

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.

Wealth Solutions: Data Solutions

Right now, UK based companies have more invested in pension schemes than the rest of Europe combined. They are crafting and implementing large, complex projects that involve several collaborators and complex data sets. They aim to deliver efficient solutions for both employees and the company.

As the market leaders in Wealth Solutions consulting, our Data Solutions Team (DST) are here to provide a fully integrated client service on data-driven strategic projects. They use their data management skills to help this new and growing specialist team design efficient processes to provide the best outcomes for Aon and for our clients. As an Aon graduate, you’ll work with some of the most creative and promising individuals in the industry. You will earn as you learn and build your career as a Data Solutions specialist.

Join Aon as a Data Solutions graduate and discover how our growing team focus on working with large data sets to ensure strategic projects for our clients can be delivered efficiently. Work with specialists across data, consulting, project management and administration and learn about the vast array of projects we are designing and completing for our clients, and how your role will be vital to the success of these. 

Your role as a Data Solutions Graduate in Wealth Solutions: Retirement

As a Data Solutions graduate, you’ll find that no two days in the office are the same. You’ll work supporting a range of teams with colleagues who provide advice and support to either the trustees managing the pension scheme, or the company that provides it.

Our aim is for you to develop into an effective member of the Data Solutions Team and help shape how the team operates in the future. We’ll support you in building strong data analysis and problem-solving skills, including an understanding of data management, manipulation, rectification and benefit calculations.

You’ll learn to use digital and AI-enabled tools thoughtfully, ask effective questions, refine outputs and apply your own judgement to test assumptions, identify anomalies and recognise when human expertise is needed. Throughout your career with Aon, you’ll continue to develop your commercial awareness, professionalism and ability to connect your work to positive client outcomes.

What your day could look like:

• Process, clean and manipulate data using internal tools and efficient, well-controlled processes

• Analyse data sets to identify patterns, trends, anomalies and areas requiring further investigation

• Ask targeted questions, challenge assumptions and identify the root causes of data issues before recommending practical solutions

• Use digital productivity, analytics and AI-enabled tools to support your work, checking and refining outputs to ensure they are accurate, relevant and appropriate for the client

• Identify and rectify data issues so information is accurate, traceable and suitable for use in client projects

• Develop scalable solutions for large data sets and learn specialist benefit calculations

• Understand the complexities, nuances and caveats involved in gathering, handling and interpreting data

• Balance quality, budget and timescale considerations, taking ownership for dependable delivery and communicating priorities clearly

• Coordinate responses across colleagues and teams to keep client work joined up and focused on the right outcomes

• Take ownership for improving standard processes, sharing knowledge and adapting your approach as priorities and client needs change

You’ll be given opportunities to work on a range of projects, gaining early exposure to clients to support your development.

You’ll also can be involved in projects for one of our specialist teams, focusing in areas such as:

• Risk Settlement, advising clients on the best way to reduce risk through transferring it to a third party.

• Member Options, helping clients reduce risk and/or cost by offering pension scheme members the choice to reshape their benefits to better suit their individual circumstances.

• GMP equalisation, helping clients correct for previous benefit inequalities.

• Pensions Dashboard, ensuring pension savers can view all their pensions (from various employers) in one online place.

Your Development

As an Aon Graduate, you will be enrolled onto our Launch Programme when you join. This development programme is built around 2 core elements:

1. Business learning. On the job learning and experiences enabling you to develop your knowledge and understanding of your team and solution line.

2. Centralised learning. UK graduates complete in an Aon Induction, monthly webinars, business skills training and workshops; all designed to develop your knowledge of Aon, build your confidence and your network across our business.

You do not need to join us with these role-specific technical skills already developed. Through structured learning, practical experience and support from colleagues, you’ll build your capability in querying and manipulating data across sources using SQL; using Python and modelling platforms across the analytical pipeline; analysing patterns, testing scenarios, interpreting results and challenging assumptions; progressing from baseline outputs to more advanced analytical methods; building and improving data pipelines that produce and process analytical data; maintaining data governance and lineage so analysis is accurate and traceable; validating machine-produced data against agreed tolerances, investigating exceptions and supporting data-quality sign-off; and coordinating and owning delivery across concurrent analytical workstreams.

Your career beyond your Graduate programme

Once you’ve completed the formal graduate programme, you’ll continue to receive lots of support at Aon. As well as continued technical and business skills training. To aid your professional development you’ll receive regular performance feedback, and work with your line manager towards promotions, which are considered twice a year, enabling you to progress from a Graduate Analyst to Associate Consultant, then Consultant and beyond.

Entry Requirements:

• You will need to have or be on track to achieve a 2:1 degree (or equivalent) in a numeric or data related subject. (Please note, this role is not suitable for Data Science graduates.)

• Excellent Microsoft Excel skills

What are we looking for?

• Motivation and ambition to pursue this career path, with the ability to explain why Data Solutions interests you and how you want to develop

• Clear and thoughtful communication, including asking focused questions, listening to different perspectives and making complex, data-led ideas easier to understand

• Sound judgement and problem-solving, with the curiosity to analyse information, challenge assumptions, test outputs and make well-reasoned decisions

• An interest in technology and new ways of working, including a willingness to learn how digital, analytical and AI-enabled tools can improve productivity and client delivery while recognising the importance of human oversight

• A client and results-focused appraoch, enabling you to connect your work to wider objectives, consider trade-offs and take accountability for high-quality outcomes

• A collaborative and dependable approach, building trust through consistent delivery, partnering effectively across teams and seeking and applying feedback

• A commitment to learning and inclusion, sharing knowledge, adapting to changing priorities and valuing different perspectives so others feel respected and able to contribute

• Initiative and forward thinking, anticipating what may be needed next, working independently when appropriate and communicating priorities clearly