Data Analyst - De Risking Pensions - Hybrid Working

​

Job reference 306949
Data Analyst - De Risking Pensions - Hybrid Working

Salary £36,000 to £42,000 (DOE), You may be eligible for a Welcome Bonus of up to £1,500 * ,10% annual bonus potential, company pension scheme with highly competitive contribution rates, generous annual leave offering of 25 days, plus bank holidays, increasing with years of service.

Permanent, Full time

Location: Hybrid Working - Requirement to attend Royal Mail, Pond Street, Sheffield, S98 6HR on an ahoc basis for team meetings.

Royal Mail Pensions is looking at add Pensions Data Professionals to its De-Risking team. This is a new team within the Pensions Service Centre focusing on delivering comprehensive reporting and analysis for the Royal Mail Pension Plan.

About the role

As a Pensions Data Professional you will develop an in-depth understanding of the data held and understand how this reflects the routines and calculations over the members life in the Royal Mail Pension Plan. You will also assess the integrity of data held on the pension administration system, and to be able to provide system extracts and design tests along with supporting bulk data migrations and reconciliations to external parties for our member’s plan.

• Be able to work with and compare large data extracts and to summarize for input to decisions and solutions for any necessary rectification actions.
• Be able to apply the knowledge to design checks for Data integrity, completeness, and accuracy, running reports and providing relevant extracts and/or summaries of the data, with clear explanations.
• Work collaboratively across the De-Risking team and wider Pensions Service Centre to define solutions for any remaining pension benefits, record keeping and administration processes, to enable post-migration calculation and payment of any residual benefits.
• Produce and test any systems change requests required, including any reports specified under contract (e.g., triennial valuations) and to deliver final migration to any selected insurance provider and/or advisors.
• Work with the partners on Bulk Data Migration, validation, and reconciliation, to third party systems
• Prepare and define bulk mailing extracts for individual Member Statements and to support any member queries; providing plain and clear explanations of how the results were derived.

What you need

• To be successful in this role you will have a broad and deep understanding of Defined Benefit structures, particularly with a complex benefit structure scheme.
• Well-developed numerical and analytical skills, with experience of working with large volumes of complex data.
• Highly developed communication and influencing skills, with experience of working with senior internal and external stakeholders, and professional advisors.
• Excellent PC skills, Advanced Excel with experience of handling large data files, query and validation, desirable Microsoft Access

Extra Benefits

• RMG Share Schemes - partnership and matching share offer
• Family friendly support - enhanced maternity pay, paternity leave, adoption leave and shared parental leave
• Discounts and offers - there are more than 800 offers to help you save on things like groceries, days out, holidays and your household bills*.
• Supportive and generous company sick pay
• Your Wellbeing - you and your family have 24/7 access to services and tools to help you get the most out of life. From your physical and mental health to financial and social support and advice. It’s free, and it’s for everyone.

*Available only to perm employees

Next Steps

Closing Date: Thursday 26th September 2024. Please note, this advert may close early if the appropriate number of applications has been reached.

The next stage of the selection process will be a virtual interview consisting of competency based and role specific questions.

Trust forms the foundation of everything we do in Royal Mail. We want to be transparent about what kind of qualities we are looking for and build trust from the very beginning of your journey with us. The first step is your interview, and we mean ‘your’ interview. We want to give you the opportunity to shine. To enable you to do this, we will provide you with your interview questions ahead of the interview taking place. This will allow you time to prepare, and ensure you have your best examples in mind. Royal Mail Group values both trust, and our people.

Royal Mail are proud of our diverse employee network groups and the active role they play to support belonging and encourage a positive work environment. We are firmly committed to inclusion and passionate about our people representing the communities we serve.

We are happy to support your need for any adjustments during the application and hiring process. Please share the details within your application if required.

*payments are made in instalments and subject to terms and conditions

We are Forces family friendly and a Gold signatory to the Armed Forces Covenant. We welcome applications from ex-Armed Forces personnel, reservists, veterans, cadet instructors and military spouses/partners.

For more information on Royal Mail Group and our values please click here: Royal%20Mail%20Group%20values%20both%20trust,%20and%20our%20people.%20%20%20%20%20We%20don%E2%80%99t%20expect%20every%20candidate%20to%20meet%20the%20full%20criteria%20for%20the%20role.%20If%20your%20experience%20looks%20a%20little%20different%20from%20the%20job%20requirements,%20but%20you%20feel%20you%20have%20the%20relevant%20skills%20to%20bring%20value%20to%20the%20role,%20we%E2%80%99d%20love%20to%20learn%20more%20about%20you.%20(delete%20if%20essential%20criteria%20only)%20%20%20%20%20Royal%20Mail%20are%20proud%20of%20our%20diverse%20employee%20network%20groups%20and%20the%20active%20role%20they%20play%20to%20support%20belonging%20and%20encourage%20a%20positive%20work%20environment.%20We%20are%20firmly%20committed%20to%20inclusion%20and%20passionate%20about%20our%20people%20representing%20the%20communities%20we%20serve.%20%20%20%20%20%20We%20are%20happy%20to%20support%20your%20need%20for%20any%20adjustments%20during%20the%20application%20and%20hiring%20process.%20Please%20share%20the%20details%20within%20your%20application%20if%20required.%20%20%20%20%20%20%20%20%20%20We%20are%20Forces%20family%20friendly%20and%20a%20Gold%20signatory%20to%20the%20Armed%20Forces%20Covenant.%20We%20welcome%20applications%20from%20ex-Armed%20Forces%20personnel,%20reservists,%20veterans,%20cadet%20instructors%20and%20military%20spouses/partners.%20%20%20%20%20For%20more%20information%20on%20Royal%20Mail%20Group%20and%20our%20values%20please%20click%20here:%20https://www.internationaldistributionsservices.com/en/about-us/%20%20%20%20%20Closing%20Date:%20.%20Please%20note,%20this%20advert%20may%20close%20early%20if%20the%20appropriate%20number%20of%20applications%20has%20been%20reached.%20%20%20#YourCareerStartsHere%20#PFW%20#RMG%20#LIMRT%20%20(Please%20delete%20as%20appropriate%20for%20your%20campaign)%20%20%E2%80%8B">https://www.internationaldistributionsservices.com/en/about-us/

#RMG

​