King's College Hospital NHS Foundation Trust

Workforce Reporting Analyst

Information:

This job is now closed

Job summary

PREVIOUS APPLICANT NEED NOT APPLY.

An exciting opportunity for a qualified and experienced MI Analyst has arisen within our Workforce Information Team.

With experience in data collation and analysis, and associated software systems; a solid understanding and practical experience in workforce data, metrics, data manipulation, report production, etc; and excellent presentation, organisation, and problem-solving skills, you will play a key role in our team, as we move forward with our constantly developing team.

You will have the opportunity to work closely with stakeholders across a variety of fields, both internal and external, identifying key information to meet requirements and appropriate methods for sourcing, and presenting across different formats, building on your existing skills.

Ideally, you will have experience working within a similar role for the NHS, experience with NHS systems - such as ESR, LEAP, SARD, etc, as well as Business Intelligence software such as QlikView, Tableau, etc.

This is a permanent, full-time role, and will be primarily based at our site at Denmark Hill, although travel to other King's sites may occasionally be required.

Please note we reserve the right to close this vacancy early if we receive sufficient applications for the role.

Main duties of the job

To provide high quality, accurate, timely and user-friendly Workforce information to internal and external stakeholders ensuring the information on workforce contributes to all the key decision-making agendas of the Trust and its wider partners.

Assist in efficient running of the Electronic Staff Record System and any linked systems which relate to workforce.

About us

King's College Hospital NHS Foundation Trust is one of the UK's largest and busiest teaching Trusts with a turnover of c£1 billion, 1.5 million patient contacts a year and around 14,000 staff based across 5 main sites in South East London. The Trust provides a full range of local hospital services across its different sites, and specialist services from King's College Hospital (KCH) sites at Denmark Hill in Camberwell and at the Princess Royal University Hospital (PRUH) site in Bromley.

King's is committed to delivering Sustainable Healthcare for All via our Green Plan. In line with national Greener NHS ambitions, we have set net zero carbon targets of 2040 for our NHS Carbon Footprint and 2045 for our NHS Carbon Footprint Plus. Everyone's contribution is required in order to meet the goals set out in our Green Plan and we encourage all staff to work responsibly, minimising their contributions to the Trust's carbon emissions, waste and pollution wherever possible.

The trust-wide strategy Strong Roots, Global Reachis our Vision to be BOLD, Brilliant people, Outstanding care, Leaders in Research, Innovation and Education, Diversity, Equality and Inclusion at the heart of everything we do. By being person-centred, digitally-enabled, and focused on sustainability, we can take Team King's to another level

Details

Date posted

28 May 2024

Pay scheme

Agenda for change

Band

Band 6

Salary

£42,471 to £50,364 a year per annum, including high cost area

Contract

Permanent

Working pattern

Full-time

Reference number

213-CORP-6135302-B

Job locations

King's College Hospital

Jennie Lee House, 34 Love Walk

London

SE5 8AD


Job description

Job responsibilities

Information Reporting

  • Follow predefine processes to produce and manage regular schedule of reports, managing own time and workload to meet reporting deadlines.
  • Assist with responses to information requests under the Freedom of Information Act interpreting, collating information and preparing responses within the statutory deadlines.
  • Assist on the production of external submissions (e.g. CQC, NHSi, etc) and ad-hoc requests.
  • Analyse and interrogate information to create complex workforce reports using a variety of sources of information both internal and external.
  • Respond to workforce reporting enquires in a timely and professional manner, based on agreed parameters in order to meet the needs of the target audience.
  • Ensure reports have appropriate and insightful narratives that addresses the specification requirements of the reports.
  • Explain and advise managers and staff to ensure they understand and utilize workforce information effectively and efficiently.
  • Assists in the production of guidance and standard operating procedures for all reporting to ensure that reports are produced in a consistent manner.
  • Report progress and escalate identified issues and risks to the Lead Workforce Information & Planning Analyst.
  • Ensure that Knowledge Pages on the intranet are kept current, easy to read/user friendly and accurate.
  • Be part of the review process to review and refresh reports for customers.

Systems and Information Management

  • Develop detailed knowledge of the ESR Business Intelligence reporting functionality, working alongside the Lead Workforce Information & Planning Analyst.
  • Develop detailed knowledge of the reporting functionality of Workforce systems and work alongside the respective System Manager. Other workforce systems include: HealthRoster, Employee Relations, SARD, LEAP, TRAC recruitment, bank and agency etc.
  • To identifying data quality issues as early as possible and assist with data cleansing activities for any additional Workforce systems, data, reporting projects.
  • Provide support to the maintenance of the Workforce systems identifying issues on accuracy and quality of data.
  • Support the workforce systems teams across various aspects of systems/information tasks/data /projects.

Planning and problem solving

  • Plan workload appropriately to ensure that reports achieve their publication deadlines. Ensure that reports which are created automatically are checked as per the schedule.
  • Develop project timescales for the development of new reports and engage appropriately with the commissioners of the reports to ensure they are delivered to specification, and time and quality requirements are communicated and agreed.
  • Understand the systems to appreciate how data is gathered, treated, and stored so that effective analysis can be made.
  • Experiment with alternative reporting formats, platforms and data sources so that new reports can be created.

Staff training and supervision

  • Assist on the provision of training on the ESR BI reporting functionality and local pre-defined reports for new and existing staff within the Workforce Team and the wider HR Team.

People Management and Performance

  • Lead, coach and manage the performance of the team in line with good people management practices. Ensuring excellence is recognised and underperformance is addressed.
  • Participate in regular performance appraisal meetings and ensure each member of the team has a clear set of objectives and development plans.
  • Ensure the team is compliance with all statutory, mandatory training together with any professional training requirements, ensuring they are up to date and fully compliant.
  • Manage team absences including sickness in line with Trust policy ensuring the appropriate return to work meetings occur, e-roster is updated and productivity is at keep to the highest possible level.
  • Identify and fill any vacancies that arise within the team in line with the Trusts recruitment policy and process.
  • Identify talent and support the internal talent management process in order attract and retain and succession plan for your people.
  • Review skills mix at regular intervals in order to identify any potential opportunities to maximise resource utilisation / allocation, ensuring job descriptions are kept up to date.
  • Ensure overall wellbeing of the team is maintained. Continuously support in improving the morale of the team and implementing a culture of zero-tolerance for bullying and harassment.

Job description

Job responsibilities

Information Reporting

  • Follow predefine processes to produce and manage regular schedule of reports, managing own time and workload to meet reporting deadlines.
  • Assist with responses to information requests under the Freedom of Information Act interpreting, collating information and preparing responses within the statutory deadlines.
  • Assist on the production of external submissions (e.g. CQC, NHSi, etc) and ad-hoc requests.
  • Analyse and interrogate information to create complex workforce reports using a variety of sources of information both internal and external.
  • Respond to workforce reporting enquires in a timely and professional manner, based on agreed parameters in order to meet the needs of the target audience.
  • Ensure reports have appropriate and insightful narratives that addresses the specification requirements of the reports.
  • Explain and advise managers and staff to ensure they understand and utilize workforce information effectively and efficiently.
  • Assists in the production of guidance and standard operating procedures for all reporting to ensure that reports are produced in a consistent manner.
  • Report progress and escalate identified issues and risks to the Lead Workforce Information & Planning Analyst.
  • Ensure that Knowledge Pages on the intranet are kept current, easy to read/user friendly and accurate.
  • Be part of the review process to review and refresh reports for customers.

Systems and Information Management

  • Develop detailed knowledge of the ESR Business Intelligence reporting functionality, working alongside the Lead Workforce Information & Planning Analyst.
  • Develop detailed knowledge of the reporting functionality of Workforce systems and work alongside the respective System Manager. Other workforce systems include: HealthRoster, Employee Relations, SARD, LEAP, TRAC recruitment, bank and agency etc.
  • To identifying data quality issues as early as possible and assist with data cleansing activities for any additional Workforce systems, data, reporting projects.
  • Provide support to the maintenance of the Workforce systems identifying issues on accuracy and quality of data.
  • Support the workforce systems teams across various aspects of systems/information tasks/data /projects.

Planning and problem solving

  • Plan workload appropriately to ensure that reports achieve their publication deadlines. Ensure that reports which are created automatically are checked as per the schedule.
  • Develop project timescales for the development of new reports and engage appropriately with the commissioners of the reports to ensure they are delivered to specification, and time and quality requirements are communicated and agreed.
  • Understand the systems to appreciate how data is gathered, treated, and stored so that effective analysis can be made.
  • Experiment with alternative reporting formats, platforms and data sources so that new reports can be created.

Staff training and supervision

  • Assist on the provision of training on the ESR BI reporting functionality and local pre-defined reports for new and existing staff within the Workforce Team and the wider HR Team.

People Management and Performance

  • Lead, coach and manage the performance of the team in line with good people management practices. Ensuring excellence is recognised and underperformance is addressed.
  • Participate in regular performance appraisal meetings and ensure each member of the team has a clear set of objectives and development plans.
  • Ensure the team is compliance with all statutory, mandatory training together with any professional training requirements, ensuring they are up to date and fully compliant.
  • Manage team absences including sickness in line with Trust policy ensuring the appropriate return to work meetings occur, e-roster is updated and productivity is at keep to the highest possible level.
  • Identify and fill any vacancies that arise within the team in line with the Trusts recruitment policy and process.
  • Identify talent and support the internal talent management process in order attract and retain and succession plan for your people.
  • Review skills mix at regular intervals in order to identify any potential opportunities to maximise resource utilisation / allocation, ensuring job descriptions are kept up to date.
  • Ensure overall wellbeing of the team is maintained. Continuously support in improving the morale of the team and implementing a culture of zero-tolerance for bullying and harassment.

Person Specification

Knowledge and Experience

Essential

  • Graduate-level qualification or equivalent relevant information management, statistical or computing subject role.
  • Knowledge of data analysis and associated software systems/reporting tools.
  • Experience in collecting, analysing and interpreting large quantities of complex data.
  • A good understanding of workforce data, metrics, benchmarking and information and the way that it can be used to support workforce productivity, planning and transformation
  • Able to interpret, produce complex reports, graphs and tables appropriate to the information required and to its audience.
  • Knowledge of the ESR Business Intelligence reporting function.

Desirable

  • Experience of using workforce systems.
  • Experience of using Business Intelligence software (e.g. MS Power BI, Tableau, QlikView).
Person Specification

Knowledge and Experience

Essential

  • Graduate-level qualification or equivalent relevant information management, statistical or computing subject role.
  • Knowledge of data analysis and associated software systems/reporting tools.
  • Experience in collecting, analysing and interpreting large quantities of complex data.
  • A good understanding of workforce data, metrics, benchmarking and information and the way that it can be used to support workforce productivity, planning and transformation
  • Able to interpret, produce complex reports, graphs and tables appropriate to the information required and to its audience.
  • Knowledge of the ESR Business Intelligence reporting function.

Desirable

  • Experience of using workforce systems.
  • Experience of using Business Intelligence software (e.g. MS Power BI, Tableau, QlikView).

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.

Certificate of Sponsorship

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.

Certificate of Sponsorship

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).

Employer details

Employer name

King's College Hospital NHS Foundation Trust

Address

King's College Hospital

Jennie Lee House, 34 Love Walk

London

SE5 8AD


Employer's website

https://www.kch.nhs.uk/ (Opens in a new tab)


Employer details

Employer name

King's College Hospital NHS Foundation Trust

Address

King's College Hospital

Jennie Lee House, 34 Love Walk

London

SE5 8AD


Employer's website

https://www.kch.nhs.uk/ (Opens in a new tab)


Employer contact details

For questions about the job, contact:

Manager

Marc Cottee

02032991984

Details

Date posted

28 May 2024

Pay scheme

Agenda for change

Band

Band 6

Salary

£42,471 to £50,364 a year per annum, including high cost area

Contract

Permanent

Working pattern

Full-time

Reference number

213-CORP-6135302-B

Job locations

King's College Hospital

Jennie Lee House, 34 Love Walk

London

SE5 8AD


Supporting documents

Privacy notice

King's College Hospital NHS Foundation Trust's privacy notice (opens in a new tab)