Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Analyse and manage workforce data, ensuring accuracy and quality across HR systems.
- Company: Join Royal Surrey, an 'Outstanding' Trust dedicated to community health and staff development.
- Benefits: Enjoy hybrid working options, comprehensive health programmes, and a focus on professional growth.
- Why this job: Be part of a friendly, innovative team making a real impact in workforce reporting.
- Qualifications: Advanced Microsoft Office skills, especially in Power BI and Excel; HR reporting experience preferred.
- Other info: Fixed-term role until September 2026, covering maternity leave; early applications encouraged.
The predicted salary is between 28800 - 43200 £ per year.
We have an exciting opportunity for a Workforce Analyst to join our Human Resources Workforce Information team. The successful candidate will support the maintenance and development of the Trust’s workforce reports, manage weekly and monthly reports, respond to ad hoc data requests, and contribute to ensuring data quality across HR systems, including ESR. Our team is friendly, proactive, and forward-thinking, committed to delivering effective workforce reporting and integrating innovative HR technologies.
Requirements include advanced skills in Microsoft Office, particularly Power BI and Excel, with experience in HR/workforce reporting. The role demands a team player with a proactive attitude, flexibility, high accuracy, and attention to detail. Experience with ESR is advantageous. An assessment in Microsoft Office, including Excel and Power BI, will be part of the interview process. The role is based in Guildford, Surrey, with opportunities for hybrid working. It is a fixed-term position until the end of September 2026, covering maternity leave.
Key Responsibilities:
- Interrogate and analyze data, presenting results both qualitatively and quantitatively.
- Prepare and deliver data analyses for forums, including the Trust Board, covering areas such as bank & agency usage, recruitment, sickness, diversity, turnover, staff in post, and training.
- Ensure data is accurate and checked before release.
- Communicate complex statistical information clearly, explaining systems and methodologies to non-expert audiences.
- Assist with data audits to maintain ESR work structures and ensure timely updates.
- Support monthly data quality validation processes, making corrections and reviewing procedures for accuracy.
- Maintain data quality on ESR through regular cleansing and liaising with users for corrections.
- Produce regular reports for managers, staff, and external bodies.
Royal Surrey is a compassionate, collaborative Trust serving a diverse community. We offer comprehensive health and wellbeing programs and are committed to your professional development. Our main hospital is in Guildford, with community sites at Milford, Haslemere, and Cranleigh. We also provide adult community health services across Guildford and Waverley. The Trust has been rated 'Outstanding' by the CQC and is investing heavily in infrastructure and staff development. Join us at an exciting time of growth and innovation.
Note: Applications may close early, so early submission is encouraged.
Workforce Analyst employer: Royal Surrey NHS Foundation Trust
Contact Detail:
Royal Surrey NHS Foundation Trust Recruiting Team
emilyallaway@nhs.net
StudySmarter Expert Advice 🤫
We think this is how you could land Workforce Analyst
✨Tip Number 1
Familiarise yourself with the key responsibilities of the Workforce Analyst role. Understanding how to interrogate and analyse data will be crucial, so consider brushing up on your analytical skills and how to present data effectively.
✨Tip Number 2
Since advanced skills in Microsoft Office, particularly Power BI and Excel, are essential, take some time to practice these tools. You might even want to create sample reports or dashboards to showcase your abilities during the interview.
✨Tip Number 3
Prepare to discuss your experience with HR/workforce reporting. Think about specific examples where you've ensured data quality or managed reports, as this will demonstrate your fit for the role.
✨Tip Number 4
Don't hesitate to reach out to Emily Allaway for an informal chat about the role. This can give you valuable insights into the team culture and expectations, which can help you tailor your approach during the interview.
We think you need these skills to ace Workforce Analyst
Some tips for your application 🫡
Understand the Role: Before applying, make sure to thoroughly read the job description for the Workforce Analyst position. Understand the key responsibilities and required skills, especially the importance of data accuracy and proficiency in Microsoft Office tools like Power BI and Excel.
Tailor Your CV: Customise your CV to highlight relevant experience in HR and workforce reporting. Emphasise your advanced skills in Excel and Power BI, and include any specific examples of how you've ensured data quality in previous roles.
Craft a Compelling Cover Letter: Write a cover letter that showcases your proactive attitude and team player mentality. Mention your flexibility and attention to detail, and explain why you are excited about the opportunity to contribute to the Trust’s workforce information team.
Prepare for the Assessment: Since an assessment in Microsoft Office will be part of the interview process, brush up on your Excel and Power BI skills. Familiarise yourself with common data analysis tasks and practice presenting data clearly and effectively.
How to prepare for a job interview at Royal Surrey NHS Foundation Trust
✨Brush Up on Your Microsoft Skills
Since the role requires advanced skills in Microsoft Office, particularly Power BI and Excel, make sure to review these tools thoroughly. Familiarise yourself with data analysis functions, visualisation techniques, and reporting features to demonstrate your proficiency during the assessment.
✨Understand Workforce Reporting
Get a good grasp of what workforce reporting entails, including key metrics like turnover, recruitment, and diversity. Be prepared to discuss how you would approach analysing these areas and presenting your findings clearly to different audiences.
✨Showcase Your Attention to Detail
The role demands high accuracy and attention to detail. During the interview, provide examples from your past experiences where your meticulousness made a difference, especially in data management or reporting tasks.
✨Prepare for Data Quality Discussions
Since maintaining data quality is crucial, be ready to talk about your experience with data audits and validation processes. Discuss any strategies you've used to ensure data integrity and how you handle discrepancies when they arise.
