Skip to main content

Workforce Analyst

Royal Surrey NHS Foundation Trust
£29,828 to £36,311 Pro Rata Per Annum inc. HCAS
Closing date
28 Jul 2024

View more

Other Health Profession
Band 5
Full Time
We have an exciting opportunity for a workforce analyst to join our Human Resources Workforce Information team to help support the maintenance and development of the Trust's workforce information suite of reports. You will be responsible for a designated set of weekly and monthly reports, respond to ad hoc information requests and participate in the general work of the team supporting the data quality of ESR, system administration and other HR processes.

We are a friendly, forward thinking, proactive team, ensuring that requirements for workforce reporting are achieved and that we are supporting innovative technologies across HR.

We are seeking someone with advanced knowledge and experience of Microsoft Office, particularly Power BI and Microsoft Excel, combined with knowledge and experience of HR/Workforce reporting. This post requires a team player with a can-do attitude, flexible approach to work and an ability to prioritise demands. A high level of accuracy and attention to detail is essential. Experience of ESR is an advantage.

There will be a Microsoft Office assessment (including excel and Power BI) as part of the interview process.

The office is located in Guildford, Surrey with the opportunity for hybrid working.

The position is fixed term until end of October 2025 to cover maternity leave.

Main duties of the job

The key system for the Trust's workforce information is ESR (Electronic Staff Record). The system is used to capture the Trust's workforce information including employee personal data, pay, establishment and employment history. Other workforce systems are used to report bank & agency usage, training records and recruitment data.

The post holder will be responsible for using these systems to produce comprehensive workforce information for internal and external stakeholders, and to develop and enhance existing reporting methods and formats.

About us

Royal Surrey is a compassionate and collaborative acute and community Trust. Recognising that our 5000 colleagues are our greatest strength, we offer a comprehensive health and wellbeing program along with a commitment to developing and advancing your career. Our diverse and welcoming Royal Surrey family will ensure you that you feel valued from your initial interview through your entire tenure.

We are clinically led and provide joined up care by bridging the gap between hospital and community services alongside regional specialist cancer care. Our main acute hospital site is in Guildford with community hospital sites at Milford, Haslemere and Cranleigh. We provide adult community health services in homes across Guildford and Waverley.

The Care Quality Commission (CQC) have given us an overall rating of Outstanding.

Royal Surrey has a strong reputation and history to build on. We are proud of our achievements and we are investing in our colleagues through our commitment to supporting professional development as well as investing more than �45 million in our physical environment and new equipment in the next few years. There has never been a better time to join us.

Although it isn't the Trusts normal practice, adverts may close early, so you are encouraged to submit an application as soon as possible.

A video about the Royal Surrey -

Job description

Job responsibilities

Workforce Information

Interrogate and analyse data and present these qualitatively and quantitatively.

Prepare and provide data and analysis for a number of forums, which will include the Trust Board. Data will include but not be limited to bank & agency usage, recruitment, sickness, diversity, turnover, staff in post and training information.

Ensure information is prepared and quality checked before release to Trust Board and other customers.

To communicate complex statistical information and advise on queries regarding workforce information. This will include explaining systems and methodology to customers who may have limited statistical knowledge or competencies.

Assist with regular information audits to ensure that the complex work structures framework within ESR is accurately maintained at all times and that any changes are made on a timely basis.

Person Specification



  • Degree HND, level 5/6 qualification or equivalent experience.
  • Qualification in a relevant numerical subject e.g. statistics, accountancy, business studies, information management

Knowledge and Experience


  • Previous experience in Human Resources, Payroll or Learning & Development with a working knowledge of oracle-based system (preferably ESR/OLM)
  • Knowledge of data protection legislation
  • Understanding of information management reporting

Employer details

Employer name

Royal Surrey NHS Foundation Trust


Royal Surrey Hospital

Egerton Road



Any attachments will be accessible after you click to apply.


Get job alerts

Create a job alert and receive personalised job recommendations straight to your inbox.

Create alert