Job summary
An opportunity has arisen for an experienced Workforce Information Analyst to join our team. Workforce information is a key resource to enable managers to deliver services in a cost-effective way and you will have a key role in supporting this.
Main duties of the job
The key elements of your role will be to:
- Coordinate statistical returns relating to workforce ensuring they are produced in a consistent, and timely manner.
- As team leader lead you willsupervise the team on a day-to-day basis ensuring coordination of regular and ad-hoc reporting requirements, identifying training needs and supporting team development.
- Critically analyse workforce and pay-related data from multiple sources to provide a range of reports for clients such as Trust Groups, Committees and Board, Sector/ Acute Provider Collaborative Boards and Trust Managers
- A key aspect is to transform raw data into valuable information by analysis, and the development of management reports to meet user needs.
- The Senior Workforce Analyst will lead the HR contribution to the Trust's workforce and operational plan.
Provide expertise, leadership and support on a variety of large and small projects, as directed by the Senior HR Business Partner for Workforce or by external stakeholders for National Programme objectives, to work towards the enhancement of HR Information Systems.
You will have experience of working withinhealthcare and have advanced practical knowledge of Workforce Information in relation to Electronic Staff Records (ESR).
The Workforce Information team work a hybrid pattern and are on site twice a week.
About us
London North West University Healthcare NHS Trust (LNWH) cares for the people of Brent, Ealing, Harrow and beyond.
Our team of more than 8,200 clinical and support staff serve a diverse population of almost one million people.
We run major acute services at:
- Northwick Park Hospital: home to one of the busiest emergency departments (A&E) in the country. The hospital provides a full range of services including the country's top-rated hyper-acute stroke unit and one of only three hyper-acute rehabilitation units in the UK
- St Mark's Hospital: an internationally renowned specialist centre for bowel disease
- Ealing Hospital: a busy district general hospital providing a range of clinical services, as well as 24/7 emergency department and urgent care centre, and specialist care at Meadow House Hospice
- Central Middlesex Hospital: our planned care site, hosting a range of surgical and outpatient services and collocated with an urgent care centre.
We are a university teaching NHS trust, in recognition of the important role we play in training clinicians of the future and bringing the benefits of research to the public.
Job description
Job responsibilities
To view the main responsibility, please see the attached the Job Description and Person Specification.
Job description
Job responsibilities
To view the main responsibility, please see the attached the Job Description and Person Specification.
Person Specification
Desirable
Desirable
- Experience of working in a large organisation
Essential
Essential
- oEducated to masters level in a relevant numerate discipline e.g. maths, statistics, economics, clinical training or have developed practical knowledge and skills to an equivalent standard for data analytics.
- Evidence of continuing professional development
- oExtensive Workforce Information Analysis Experience and oAdvanced knowledge of using and running reports from NHS Electronic Staff Record [ESR]
- oSignificant experience of workforce operational planning and implementing best practice methodology
- oExperiencing of development in analysis systems for example, PowerPivot, Qlikview, Tableau, SPC, or Power BI
- oExperience of working with customers to meet current and future needs
- Highly developed knowledge of MS Excel, including use of Pivot Tables, an array of functions such as lookups (INDEX,MATCH; VLOOKUP), SUMIFS, AVERAGEIFS, ISNUMBER, SEARCH etc
- Ability to communicate regularly with a wide range of internal and external stakeholders
- Ability to work autonomously, providing specialist advice both internally and externally, working to tight and often changing timescales
- oExperience of working within projects
- oStaff management and Ability to train staff on one to one basis
Desirable
- oWorking knowledge of SQL, MS Excel VBA and programming languages such as R or Python
Person Specification
Desirable
Desirable
- Experience of working in a large organisation
Essential
Essential
- oEducated to masters level in a relevant numerate discipline e.g. maths, statistics, economics, clinical training or have developed practical knowledge and skills to an equivalent standard for data analytics.
- Evidence of continuing professional development
- oExtensive Workforce Information Analysis Experience and oAdvanced knowledge of using and running reports from NHS Electronic Staff Record [ESR]
- oSignificant experience of workforce operational planning and implementing best practice methodology
- oExperiencing of development in analysis systems for example, PowerPivot, Qlikview, Tableau, SPC, or Power BI
- oExperience of working with customers to meet current and future needs
- Highly developed knowledge of MS Excel, including use of Pivot Tables, an array of functions such as lookups (INDEX,MATCH; VLOOKUP), SUMIFS, AVERAGEIFS, ISNUMBER, SEARCH etc
- Ability to communicate regularly with a wide range of internal and external stakeholders
- Ability to work autonomously, providing specialist advice both internally and externally, working to tight and often changing timescales
- oExperience of working within projects
- oStaff management and Ability to train staff on one to one basis
Desirable
- oWorking knowledge of SQL, MS Excel VBA and programming languages such as R or Python
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.
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
Additional information
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.
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
