Hybrid Data Modelling Consultant | Pension Data & Excel

Aon plc; United Kingdom; Hybrid; GBP 45,000 - 65,000; Full time

Benefits offered by this job

Smart Working

Global Wellbeing Days

Job summary

Aon plc in the United Kingdom is seeking a Data Solutions Modelling Consultant to create and amend complex Excel models supporting bulk pension data and calculation remediation projects.

This hybrid role, within Aon's UK Retirement business, involves delivering data cleansing, GMP rectification, benefit remediation, and system implementation while developing others and driving process improvement.

Qualifications

• Proficiency in Excel, with ability to create and amend models.
• Understanding of UK pension schemes with knowledge of member calculations and experience delivering bulk pension data or calculation projects.
• Experience in pension data transformation projects (GMP Rectification/Reconciliation, GMP Equalisation, Risk Settlement Data Cleanse, Benefit Remediation).
• 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.

Responsibilities

• 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.

Skills

Data modelling

Stakeholder management

Pension knowledge

Project management

Communication

Time management

Leadership

Tools

Excel

Job description

Aon plc in the United Kingdom is seeking a Data Solutions Modelling Consultant to create and amend complex Excel models supporting bulk pension data and calculation remediation projects.

This hybrid role, within Aon's UK Retirement business, involves delivering data cleansing, GMP rectification, benefit remediation, and system implementation while developing others and driving process improvement.