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 working, comprehensive benefits, and two Global 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 36000 - 60000 £ 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 consultant, 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 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.
- Have 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.
- Have 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 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.
Benefit and data correction specialist employer: Aon Corporation
Contact Detail:
Aon Corporation Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Benefit and data correction specialist
✨Tip Number 1
Network like a pro! Reach out to current employees at Aon or in the pensions sector on LinkedIn. Ask them about their experiences and any tips they might have for landing a role like the Benefit and Data Correction Specialist.
✨Tip Number 2
Prepare for your interview by brushing up on your Excel skills. Since this role requires creating and amending complex models, practice some common tasks and be ready to discuss your experience with data transformation projects.
✨Tip Number 3
Show off your communication skills! During interviews, highlight how you've successfully liaised with stakeholders in past roles. This will demonstrate your ability to work collaboratively, which is key for this position.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re genuinely interested in joining Aon and being part of our team.
We think you need these skills to ace Benefit and data correction specialist
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!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you’re passionate about this role and how your skills can contribute to our Data Solutions Team. Let us know what excites you about working at Aon!
Showcase Your Communication Skills: Since this role involves liaising with various stakeholders, make sure to demonstrate your strong communication skills in your application. We love candidates who can articulate their thoughts clearly and build relationships effectively.
Apply Through Our Website: We encourage you to apply through our website for the best chance of success. It’s the easiest way for us to review your application and get you into the process. Don’t miss out on this opportunity!
How to prepare for a job interview at Aon Corporation
✨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 GMP rectification or benefit remediation projects will show that you're not just a candidate, but a knowledgeable asset for the team.
✨Show Off Your Communication Skills
This role involves liaising with various stakeholders, so be ready to demonstrate your strong communication and relationship-building skills. Think of examples where you've successfully collaborated with others to achieve project goals.
✨Be Proactive and Solution-Oriented
Aon values individuals who take initiative. Prepare to discuss how you've identified project risks in the past and the strategies you implemented to mitigate them. This will highlight your proactive nature and problem-solving skills, which are crucial for this position.