At a Glance
- Tasks: Create and amend complex Excel models for pension data projects.
- Company: Join Aon's inclusive and diverse Data Solutions Team.
- Benefits: Enjoy flexible hybrid working, competitive salary, and wellbeing days.
- Why this job: Make a real impact in the pensions industry while developing your skills.
- Qualifications: Proficiency in Excel and understanding of UK pension schemes required.
- Other info: Fast-paced environment with excellent career growth opportunities.
The predicted salary is between 28800 - 48000 £ per year.
Do you have the skills needed to create and amend complex Excel models to support bulk pension data and calculation remediation projects? 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 cleanse, 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
- Carry out and/or review bespoke data modelling work, ensuring accuracy and compliance with requirements.
- Liaise with multiple stakeholders, including consultants, administrators, and specialists, to understand requirements, articulate our work and help make decisions.
- Help devise strategies for carrying out the required data work within the contractual timescales.
- Review the work carried out by others to ensure the output is fit for purpose.
- Developing others in the team.
- Leading or inputting into process improvement activities.
How this opportunity is different
As a benefit & data correction specialist, you will get the opportunity to interact with a wide range of colleagues and teams within the UK Retirement business. Your delivery will directly contribute to the ‘Aon Story’. Having a strong network of colleagues for support is pivotal for your individual development, and your network of colleagues will naturally increase rapidly from day one. Individual development within the role will be fast-paced, with new and interesting challenges presenting themselves through changes in pensions legislation and industry initiatives.
Skills and experience that will lead to success
- Proficiency in Excel, with ability to create and amend models.
- An understanding of UK pension schemes with knowledge of how individual member calculations are performed, and experience of delivering bulk pension data and/or calculation projects.
- Experience in pension data transformation projects, e.g. GMP Rectification/Reconciliation, GMP Equalisation, Risk Settlement Data Cleanse, Benefit Remediation projects.
- Ability to identify project risks/issues, and work with internal stakeholders to mitigate.
- Be proactive and self-motivated, with a desire to own and deliver the best solutions for Aon.
- Strong communication and relationship-building skills, with the ability to work with various teams and stakeholders.
- Strong time-management skills, able to prioritise and manage several projects.
How we support our colleagues
In addition to our comprehensive benefits package, we encourage an inclusive workforce. Plus, our agile 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.
Benefit and data correction specialist in London employer: Aon
Contact Detail:
Aon Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Benefit and data correction specialist in London
✨Network Like a Pro
Get out there and connect with people in the industry! Attend networking events, join relevant online forums, and don’t be shy about reaching out to current employees at Aon. Building relationships can open doors and give you insider info on job opportunities.
✨Ace the Interview
Prepare for your interview by researching Aon’s values and recent projects. Think about how your skills in Excel and pension data transformation can contribute to their goals. Practice common interview questions and be ready to showcase your problem-solving abilities!
✨Show Off Your Skills
During interviews or networking chats, don’t just talk about your experience—demonstrate it! Bring examples of your Excel models or past projects that relate to data correction. This will help you stand out and show you’re the right fit for the role.
✨Apply Through Our Website
Make sure to apply directly through Aon’s website. It’s the best way to ensure your application gets seen by the right people. Plus, you’ll have access to all the latest job openings and updates about the company!
We think you need these skills to ace Benefit and data correction specialist in London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the role of Benefit and Data Correction Specialist. Highlight your Excel skills and any relevant experience with pension data projects. We want to see how your background aligns with what we’re looking for!
Showcase Your Skills: In your application, don’t just list your skills—show us how you’ve used them! If you've worked on data transformation projects or dealt with complex calculations, share specific examples. This helps us understand your hands-on experience.
Be Clear and Concise: When writing your cover letter, keep it clear and to the point. We appreciate straightforward communication, so make sure you articulate your thoughts well and explain why you’re a great fit for our team.
Apply Through Our Website: We encourage you to apply through our website for the best chance of being noticed. It’s super easy, and you’ll be able to track your application status. Plus, we love seeing applications come directly from our site!
How to prepare for a job interview at Aon
✨Master Excel Like a Pro
Since this role requires proficiency in Excel, make sure you brush up on your skills. Practice creating and amending complex models before the interview. You might even want to prepare a few examples of your past work to showcase your abilities.
✨Know Your Pensions Inside Out
Familiarise yourself with UK pension schemes and the specifics of member calculations. Being able to discuss your understanding of data transformation projects like GMP Rectification or Benefit Remediation will show that you're not just a candidate, but a knowledgeable asset.
✨Communicate Clearly and Confidently
This role involves liaising with various stakeholders, so practice articulating your thoughts clearly. Prepare to discuss how you've built relationships in previous roles and how you can contribute to team dynamics at Aon.
✨Show Your Problem-Solving Skills
Be ready to discuss how you've identified project risks in the past and the strategies you used to mitigate them. This will demonstrate your proactive nature and ability to deliver effective solutions, which is key for success in this position.