82768 -Pensions Analyst (Accounts & Member Data)
This Pensions Analyst (Accounts & Member Data) will report to the Pensions Project Manager and will work within the Human Resources directorate based in our Crawley office. You will be a permanent employee.
You will attract a salary of £37,000.00 and a bonus of 7.5%. This role can also offer blended working after probationary period (6 months) - 3 days in the office and 2 remote
Close Date: 09/08/2026
We also provide the following additional benefits
- 25 Days Annual Leave plus bank holidays.
- Reservist Leave – Additional 18 days full pay and 22 unpaid
- Personal Pension Plan – Personal contribution rates of 4% or 5% (UK Power Networks will make a corresponding contribution of 8% or 10%)
- Tenancy Loan Deposit Scheme, Season Ticket Loan
- Tax efficient benefits: Cycle to Work, Home & Tech, and Green Car Leasing Schemes
- Occupational Health support
- Switched On – scheme providing discount on hundreds of retailers' products
- Discounted gym membership
- Employee Assistance Programme
Job purpose:
Your role will be to ensure the validity, accuracy and reporting of data from Pensions Services including member, scheme and financial data
Principal accountabilities:
You will sit within the in-house pensions team and you will help prepare scheme accounts from source data, alongside delivering high-quality reporting of member benefit data. You will combine technical accounting capability with strong analytical and data management skills to support governance, regulatory compliance, and decision-making.
Responsibilities:
Scheme Accounts Preparation
Work with data from multiple teams, including administrators, custodians, investment managers, and internal finance systems.
Undertake processes to post to Aviary accounting software
Help prepare quarterly pension scheme management accounts
Help prepare pension scheme financial information for regulatory and corporate accounting purposes.
Communicate with third-party service providers and auditors to resolve queries.
Member Data Reporting & Analysis
Analyse member benefit data to support actuarial valuations, accounting disclosures, and scheme reporting.
Assistance and support on one-off pension projects
Support data preparation and maintenance during scheme events such as benefit statements and pension increases.
Data analysis, reconciliation and validation for our Group Personal Pension Scheme.
Produce regular and ad hoc reports on membership movements, benefit changes, and liability metrics.
Identify trends, anomalies, and data quality issues within member datasets.
Support data cleansing exercises and improvement projects.
Work with administrators to validate and improve data integrity.
Data Management & Controls
Maintain knowledge of UKPN policies around data management, protection, cyber and supported tools and comply with these policies
Maintain data reconciliation and validation processes between systems and reports.
Develop controls around financial and member data.
Document processes and maintain clear audit trails to support governance requirements.
Support implementation of data governance frameworks and controls.
Partner Engagement
Collaborate with other teams (Finance, HR, Payroll, IS, Cyber) and external providers (administrators, actuaries, auditors).
Become familiar of the administration team's processes, workloads, issues and priorities.
Communicate clearly and promptly to keep team members informed and updated on data management issues.
Present analysis and findings to non-technical partners.
Support the Pensions Executive with Trustee reporting packs and insights.
Support the Head of Pensions with analysis to support Corporate Strategy decision-making by the Corporate Pensions Committee
Continuous Improvement
Identify opportunities to reduce risk and increase efficiencies in reporting and accounting processes.
Support system enhancements or data transformation projects.
Contribute to automation of reporting and reconciliation processes.
Skills & Experience
Essential:
Experience in pensions, finance, or a related analytical/accounting environment.
Analysis skills (Excel advanced level essential; experience with data tools beneficial).
Knowledge of relational and/or non-relational databases and SQL-based languages
Experience extracting and validating data
Translate data into meaningful insights
Experience working with large datasets and identifying trends/issues
Understanding of data integrity, consistency, and validation principles
Ability to troubleshoot data issues and investigate anomalies
Retrieve and work with data from external systems
Experience with data visualisation or reporting tools (e.g. Power BI)
Understanding of pension scheme structures and member data.
Good reconciliation skills.
You will interpret complex datasets and present clear insights.
Desirable:
Experience working with pension administrators or schemes (DB/DC).
Some knowledge of UK pension scheme accounting requirements (e.g. SORP).
Experience with SAP, Aviary and Pensions Office
Understanding of APIs and data integration
Personal Attributes
Analytical and methodical approach to problem-solving.
Strong organisational skills and ability to use own initiative to prioritise work and meet deadlines.
Effective communicator with the ability to engage diverse stakeholders.
Proactive mindset with a focus on continuous improvement.
Team-oriented but able to work independently.
Managers and supervisors carry both legal and company responsibilities for ensuring the health and safety of their employees, those under their control and those who might be affected by the work undertaken, i.e. public, visitors and employees of other organisations. This includes briefing individuals working for them and ensuring there is the necessary understanding, competence and application of requirements to work safely and without harming the environment.
Employees will ensure they understand the health and safety risks involved in their work activities and their responsibility to apply the controls needed to manage those risks to acceptable levels. Similarly where work activities can have an adverse impact upon the environment, and where there are legal requirements, employees will understand those impacts and the controls they must ensure are applied.
If in doubt ask!
We are committed to equal employment opportunity regardless of race, colour, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender, gender identity or expression, or veteran status. We are proud to be an equal opportunity workplace.
We are committed to safeguarding and promoting the welfare of children and young people. Where applicable, this role is subject to safer recruitment processes and robust pre‑employment checks
If you have any queries in connection to this vacancy or your application, please contact us at [email protected] quoting the vacancy reference number and a member of the team will get in touch with you as soon as possible.
