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 ad-hoc basis for team meetings.
Royal Mail Pensions is looking to 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
* Develop an in-depth understanding of the data held and how this reflects the routines and calculations over the members' life in the Royal Mail Pension Plan.
* Assess the integrity of data held on the pension administration system and provide system extracts and design tests along with supporting bulk data migrations and reconciliations to external parties for our member’s plan.
* Work with and compare large data extracts and summarize for input to decisions and solutions for necessary rectification actions.
* Design checks for data integrity, completeness, and accuracy, running reports and providing relevant extracts and/or summaries of the data with clear explanations.
* Collaborate across the De-Risking team and wider Pensions Service Centre to define solutions for remaining pension benefits, record keeping, and administration processes.
* Produce and test any systems change requests required, including any reports specified under contract (e.g., triennial valuations) and deliver final migration to any selected insurance provider and/or advisors.
* Work with partners on Bulk Data Migration, validation, and reconciliation to third-party systems.
* Prepare and define bulk mailing extracts for individual Member Statements and support any member queries, providing clear explanations of how the results were derived.
What you need
* 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.
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 - more than 800 offers to help you save on groceries, days out, holidays, and household bills*.
* Supportive and generous company sick pay.
* Your Wellbeing - 24/7 access to services and tools to help you get the most out of life, including physical and mental health support.
Next Steps
Closing Date: Thursday 26th September 2024. 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 the qualities we seek and build trust from the beginning of your journey with us. We provide interview questions ahead of the interview to allow you time to prepare and ensure you have your best examples in mind.
Royal Mail is proud of our diverse employee network groups and the active role they play in supporting belonging and encouraging a positive work environment. We are firmly committed to inclusion and passionate about our people representing the communities we serve.
We 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 installments 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.
#J-18808-Ljbffr