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.

Essential Skills & Experience

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

Health & Safety Responsibilities

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 careers@ukpowernetworks.co.uk quoting the vacancy reference number and a member of the team will get in touch with you as soon as possible.