Workforce Data Analyst

Job description

Job responsibilities

Duties and Responsibilities

Key results from the job holder

To support a range of workforce information requests including:

- Corporate workforce information requirements including Trust Executive Board & People Committee reporting

- Divisional reporting requirements

- External information requests to GM and NHS England

- Mandatory reporting including providing data to support completion of the WDES, WRES and Gender Pay Gap reports

- Ad hoc workforce information/reporting requests including (but not limited to) workforce related FOI requests

Produce & distribute statistical information/analysis, including a range of reporting on workforce trends such as labour turnover, sickness absence and temporary spend

Manipulation of information and usage of appropriate tools to present data, graphically and pictorially, including excel & PowerPoint

Be a resource for analysis, interpretation and presentation of datasets

Provide high quality workforce information for the Trusts annual Workforce Planning Strategy to include returns to GM and NHS England

Proactively contribute to improvements in ESR data quality through utilisation of WOVEN data quality reports & associated data cleansing activity

Utilise other information sources to provide benchmarking information

Support the continuing improvement of the workforce information provided to service users.

Be the central point of contact for Professional Registration interfaces with ESR e.g. GMC & NMC and co-ordinate any associated data cleansing actions that are required

Advise managers on all aspects of workforce data ensuring compliance with Trust Policies and Procedures, legislation and best practice.

Support the development and maintenance of workforce dashboards and reports using ESR, Qlik Sense, and Power BI (or equivalent), ensuring that data is presented clearly and effectively to support decision making.

Provide workforce analytics to support establishment control, vacancy monitoring, skill mix reviews and paybill forecasting.

Contribute to process improvement initiatives to automate reporting and improve data accuracy and efficiency.

Provide data insight and analysis to support Trust-wide and divisional workforce planning.

Planning and Organisational Duties

Plan and organise a comprehensive reporting schedule to ensure key deadlines are met

Work independently including planning and organising own workload

Support the Trusts workforce planning cycle by supporting the production of accurate forecasts and scenario models that inform budget setting, Staff In post and establishment reviews, and strategic workforce planning priorities

Communications and Key Working Relationships

Undertake effective communication with a range of stakeholders within the People Directorate and Divisional Management teams

Enhanced communication to explain statistical concepts and reporting techniques

Communicate complex workforce information clearly to non-technical audiences including senior operational and clinical leaders.

Build strong collaborative relationships with Finance, Rostering, Divisional Management teams, and external reporting functions

Responsibility for Finance

Promote effective utilisation of resources within the People Directorate

Responsibility for Human Resources

Provide training within own discipline as required by the needs of the People Directorate

Adhere to and promote Trust policies, procedures and guidelines

Ensure compliance with Mandatory training in accordance with Trust Policy

Responsibility for Health & Safety

Compliance with the Health & Safety at Work Act 1974 the post holder is required to fulfil a proactive role towards the management of risk in all of their actions. This entails the risk assessment of all situations, the taking of appropriate actions and reporting of all incidents, near misses and hazards, and a statutory duty of care for their own personal safety and that of others who may be affected by their acts or omissions.

Responsibility for Teaching

Provide informal training and guidance to managers and colleagues on accessing and interpreting workforce reports and dashboards

Work Circumstances & on-call

No on call required within the role

Person Specification

Qualifications

Essential

• GCSE Maths & English (Grade C or equivalent grade/qualification)
• Educated to degree level, or equivalent experience
• ECDL or equivalent IT skills

Experience

Essential

• Previous experience of working in an Informatics role
• Experience of using computerised Management Information or HR systems
• Experience of working with statistics / relational databases and reporting tools
• Experience of using Microsoft packages to include Excel, Word, PowerPoint and E-mail
• Experience of using Excel V-lookup and Pivot functions

Desirable

• Experience of utilising the Electronic Staff Record (ESR)
• ESR Business Intelligence Local report writing experience

Skills

Essential

• A high standard of analytical and numeracy skills
• Skills in using & extracting data from computerised Management Information and/or HR systems
• Excellent organisational skills to enable effective prioritisation of workload and deadline management
• Intermediate to Advanced IT skills, to include Excel, Word, PowerPoint and Email
• Proven ability to communicate effectively with a wide range of people
• Able to interpret and present numerical information accurately and in an easy-to-understand way
• Excellent attention to detail and able to identify data anomalies

Knowledge

Essential

• Intermediate to advanced knowledge of Microsoft Excel
• In depth knowledge & use of reporting tools to produce statistical information
• Well-developed knowledge of electronic management information/HR systems
• Knowledge of and able to apply statistical concepts
• Knowledge of the Data Protection Act

Desirable

• Knowledge of the Electronic Staff Record (ESR)
• Knowledge of NHS Workforce Planning
• Knowledge of ESR Business Intelligence Reporting

Additional

Essential

• Flexible and proactive approach to duties
• Agility in working with multiple systems
• Speak English to an appropriate standard relevant to their role, i.e. with confidence and accuracy, using correct sentence structures and vocabulary, and without hesitation

Disclosure and Barring Service Check

This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.

Employer details

Employer name

Wrightington Wigan & Leigh Teaching Hospitals NHS Foundation Trust

Address

Buckingham Row

Brick Kiln Lane

Wigan

WN1 1XX

Employer's website

http://www.wwl.nhs.uk/ (Opens in a new tab)