Job overview

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 some hybrid working.

The position is fixed term until end of September 2026 to cover maternity leave.

Main duties of the job

•    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 workstructures framework within ESR is accurately maintained at all times and that any changes are made on a timely basis.

•    Assist with the completion of the monthly data quality validation requests from IBM and other external bodies.  Ensure that amendments/corrections are actioned and review procedures where necessary to maintain future accuracy.

•    Monitor and maintain the quality of information held on ESR including regular data cleansing.  Liaise with ESR users to ensure corrections and amendments are made where necessary.

•    Responsible for the production of regular weekly and monthly reports for managers, other Trust staff and external bodies.

Working for our organisation

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 - https://www.youtube.com/watch?v=R96pMboIYdo