This job has expired

Workforce Analyst

West London NHS Trust
£32,720 to £39,769 a year per annum inclusive
Closing date
1 Jun 2023

View more

Other Health Profession
Band 5
Contract Type
Part Time
Job summary

This is an exciting opportunity for a Senior Workforce Analyst to join our friendly Workforce Team. We are seeking an enthusiastic and technically-skilled individual with experience in using ESR and other workforce systems to deliver high quality data reports and analysis. Advanced excel and analytical skills is essential to this role.

Workforce Analyst Band 5

An exciting opportunity to join our HR Workforce Team at West London Mental Health Trust has arisen, as a Workforce Analyst.

We are looking for an enthusiastic individual with experience in using ESR and other Workforce Systems. You will need to have advanced excel and analytical skills.

As the Workforce Analyst, you will ensure the integrity and data set of ESR is maintained, and assist with establishment control. Interacting closely with HR and Finance teams, you will have to be flexible, and be able to work using your own initiative.

Business intelligence knowledge is advantageous.

Please note that this is a part time role - 22.5 hours/week

Main duties of the job

You will be responsible for:

1. To preserve the integrity of the ESR database, by running regular reports, undertaking regular data validation exercises and by liaison with budget holders, service heads and Management Accounts.

2. To maintain working relationships with Finance colleagues to ensure processes can be streamlined and improved where appropriate.

3. To support the Workforce Information and Planning Manager in ensuring ESR accurately reflects the Trust's funded establishment through post control, department structure and Trust hierarchy.

4. To liaise with other stakeholders to ensure an appropriate workforce structure is replicated on the relevant systems related to ESR.

5. To design, write, edit and run reports within ESR using Business Intelligence and Disco Ad-hoc tool to meet the business needs.

6. To assist and enable other users and HR staff in relation to running reports, provide training and advice on ESR report writing and editing.

7. To control access to ESR, including the set-up and monitoring of employee log-ins and URPs.

8. To update and maintain ESR positions, starters and leavers across relevant workforce systems.

About us

West London NHS Trust is one of the most diverse providers of mental health, community and social care in the UK.

Our 3,982 staff care for people in hospital and in the community, helping them to recover and go on to lead full and productive lives. We aim to be the best organisation of our kind in the country.

We provide care and treatment for more than 800,000 people living in the London boroughs of Ealing, Hammersmith & Fulham and Hounslow, delivering services in the community (at home, in GP surgeries and care homes), hospital, specialist clinics and forensic (secure) units.

We'rerated good overall by the Care Quality Commission (CQC).

Together, we're committed to promoting hope and wellbeing, working with patients, service users, carers, families and partners across the communities we serve.

We are keen to ensure that our workforce reflects the community it serves, particularly in terms of ethnicity, gender, disability, LGBTQ+ and experience of mental illness.

Job description

Job responsibilities

For further information with regards to the role and responsibility please see attached Candidate Pack.

Person Specification



  • Educated to degree level or equivalent experience


  • ECDL or equivalent



  • Extensive experience of working ESR
  • Experiencing of maintaining other workforce systems. Experience of creating and interrogating spreadsheets & databases.



  • Understanding of Agenda for Change Pay Regulations
  • Understanding of Data Protection Act issues and responsibilities
  • Comprehensive understanding of database report writing


  • Knowledge of ESR Business Intelligence tool



  • Excellent IT skills, including report writing and database management packages, including Excel and Access
  • Skilled in identifying and highlighting any areas of concern with regard to data quality.
  • Excellent verbal and written communication skills
  • Ability to prioritise workload
  • Excellent numeric skills
  • Ability to train staff
  • Excellent attention to detail
  • Ability to use own initiative and to work unsupervised

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