Job summary
UCLH is seeking a full time Reports Analyst to join the Business Intelligence Reports team on a 12 month Fixed Term Contract basis
The post holder will be responsible for external mandatory data submissions as well as the development and maintenance of accurate, timely and meaningful business intelligence reports to support management decision making across the Trust ensuring that internal and external reporting obligations are met.
The post holder will support all levels and functions within the Trust by providing a highly advanced information development and analysis service to the trust boards, and external partners and agencies.
The post holder reports to the Reports Manager but will have key links to internal and external teams including the Planning and Performance directorate, Operational leads, EHRS (Electronic Health Record System) team, North Central London (NCL) ICB and NHSE .
UCLH as an organisation is committed to offering flexible working including hybrid working and would encourage candidates to discuss this with the recruiting manager as part of the recruitment process.
Main duties of the job
The post holder will:
o Support the development and provision of routine business intelligence reports and external mandatory data submissions. This could be through a mixture of working on new reports/projects and improving / troubleshooting existing reports and reporting processes.
o Develop and build innovative systems and reports to support changing and emerging business requirements for information provision and reporting.
o Support improvements in and automation of existing processes, validation and reports.
o Produce routine internal and external reports in an accurate, timely and complete way.
About us
University College London Hospitals NHS Foundation Trust (UCLH) is one of the most complex NHS trusts in the UK, serving a large and diverse population. We provide academically led acute and specialist services, to people from the local area, from throughout the United Kingdom and overseas. Our vision is to deliver top-quality patient care, excellent education, and world-class research.
We provide first-class acute and specialist services across eight sites:
We are dedicated to the diagnosis and treatment of many complex illnesses. UCLH specialises in women's health and the treatment of cancer, infection, neurological, gastrointestinal and oral disease. It has world class support services including critical care, imaging, nuclear medicine and pathology.
We are committed to sustainability and have pledged to become a carbon net zero health service, embedding sustainable practice throughout UCLH. We have set an ambitious target of net zero for our direct emissions by 2031 and indirect emissions by 2040.
Job description
Job responsibilities
For the full Person Specification and more information regarding the main responsibilities of this role, please refer to the attached Job Description.
Reporting To be responsible for the reporting of new and existing mandatory submissions to external partners e.g. NCL ICB, NHSE etc in a timely way and ensuring external submission deadlines are met. This will include:o To support automation of these reports and submissions where possibleo Ensure consistency and accuracy in submissions and trouble shoot issues as they ariseo Ensure new submission requirements are fully understood and develop reporting and submission processes to deliver ito Ensure that Standard Operating Procedures are in place and are kept up-to-dateo Liaising with internal and external stakeholders as appropriate to understand key reporting requirements To support the production of routine BI reports, working with the divisional information teams and other customers to ensure these reports clearly and accurately communicate the relevant information. This will include:o Development of new reports and trouble shooting existing reportso Liaising with internal and external customers to understand BI requirementso Working with other analysts in the corporate information teams to deliver the requirement using various database and report-writing tools as appropriateo Reviewing completed projects with customers to ensure that the original requirements were met and to understand lessons for future projectso Ensure documentation is in place and is accurate
To work with information business partners and key divisional stakeholders regarding accuracy of reporting, in particular working with MDT coordinators in support of accurate cancer reporting. To provide information about the existing suite of reports available from the UCLH data warehouse and related data systems. To have a good understanding of the data items catalogued in the Data Manual and used in regular and ad-hoc reports, and how the trusts systems fields relate to them. To monitor and action various generic email inboxes
Processes and documentation To understand key processes within the department so that the post-holder is able to provide business continuity in service provision, and cover for members of the team in supervising or running standard processes and reports. This will primarily be to provide cover in the case of absence in the department. To produce robust documentation for all BI reporting and information system development work including comprehensive procedures for all routine tasks performed within the department.
Communication To liaise with staff as needed to ensure that reporting appropriately reflects performance. To present the results of any complex modelling work to non-information staff in clear and unambiguous ways. To liaise with key staff (e.g. Medical Director, Head of Operations, Senior Finance Managers, and Divisional Managers) to ensure that reporting appropriately supports business objectives and performance.
Responsibility for human resources (HR) To support the day to day work of the team in performing its reporting function, supervising the work of staff where required. To promote good teamwork between all information professionals. To meet regularly with the line manager to set work priorities, discuss training needs, appraise own performance, etc.
Responsibility for finances To be responsible for office equipment used
Freedom to act
To operate with large degree of autonomy as a specialist in delivering BI reporting function in compliance with guidelines and principles reviewed regularly with the post holders line manager.
Other To concentrate as required when analysing statistical information and writing reports Requirement to concentrate for long periods on BI Reports and processes
General
To adhere to the UCLH Service Commitment "Making a Difference Together" and adopt a professional approach to customer care at all times. To comply with the Trusts Equal Opportunities Policy and treat staff, patients, colleagues and potential employees with dignity and respect at all times. To take personal responsibility for promoting a safe environment and safe patient care by identifying areas of risk and following the Incident, Serious Incidents and Near Misses reporting policy and procedure. To take personal responsibility for ensuring that UCLH resources are used efficiently and with minimum wastage and to comply with the Trust's Standing Financial Instructions (SFIs). To be aware of and adhere to all Trust policies and procedures, the Health and Safety at Work Act and the Data Protection Act. To maintain confidentiality at all times.Other
The job description is not intended to be exhaustive and it is likely that duties may be altered from time to time in the light of changing circumstances and after consultation with the post holder. The postholder will be expected to actively participate in annual appraisals and set objectives in conjunction with your manager. Performance will be monitored against set objectives.
Come and be a part of the best NHS trust in England to work for, according to our staff*
* UCLH top trust to work at in England - In the most recent NHS staff survey UCLH had the highest percentage of staff who said they would recommend us as a place to work, out of all general acute or acute/community NHS trusts in England for the third year in a row.
UCLH recognises the benefits of flexible working for staff To find out more, visit: Flexible working.
To discover more about what makes UCLH a great place to work, visit: Why Choose UCLH?
Job description
Job responsibilities
For the full Person Specification and more information regarding the main responsibilities of this role, please refer to the attached Job Description.
Reporting To be responsible for the reporting of new and existing mandatory submissions to external partners e.g. NCL ICB, NHSE etc in a timely way and ensuring external submission deadlines are met. This will include:o To support automation of these reports and submissions where possibleo Ensure consistency and accuracy in submissions and trouble shoot issues as they ariseo Ensure new submission requirements are fully understood and develop reporting and submission processes to deliver ito Ensure that Standard Operating Procedures are in place and are kept up-to-dateo Liaising with internal and external stakeholders as appropriate to understand key reporting requirements To support the production of routine BI reports, working with the divisional information teams and other customers to ensure these reports clearly and accurately communicate the relevant information. This will include:o Development of new reports and trouble shooting existing reportso Liaising with internal and external customers to understand BI requirementso Working with other analysts in the corporate information teams to deliver the requirement using various database and report-writing tools as appropriateo Reviewing completed projects with customers to ensure that the original requirements were met and to understand lessons for future projectso Ensure documentation is in place and is accurate
To work with information business partners and key divisional stakeholders regarding accuracy of reporting, in particular working with MDT coordinators in support of accurate cancer reporting. To provide information about the existing suite of reports available from the UCLH data warehouse and related data systems. To have a good understanding of the data items catalogued in the Data Manual and used in regular and ad-hoc reports, and how the trusts systems fields relate to them. To monitor and action various generic email inboxes
Processes and documentation To understand key processes within the department so that the post-holder is able to provide business continuity in service provision, and cover for members of the team in supervising or running standard processes and reports. This will primarily be to provide cover in the case of absence in the department. To produce robust documentation for all BI reporting and information system development work including comprehensive procedures for all routine tasks performed within the department.
Communication To liaise with staff as needed to ensure that reporting appropriately reflects performance. To present the results of any complex modelling work to non-information staff in clear and unambiguous ways. To liaise with key staff (e.g. Medical Director, Head of Operations, Senior Finance Managers, and Divisional Managers) to ensure that reporting appropriately supports business objectives and performance.
Responsibility for human resources (HR) To support the day to day work of the team in performing its reporting function, supervising the work of staff where required. To promote good teamwork between all information professionals. To meet regularly with the line manager to set work priorities, discuss training needs, appraise own performance, etc.
Responsibility for finances To be responsible for office equipment used
Freedom to act
To operate with large degree of autonomy as a specialist in delivering BI reporting function in compliance with guidelines and principles reviewed regularly with the post holders line manager.
Other To concentrate as required when analysing statistical information and writing reports Requirement to concentrate for long periods on BI Reports and processes
General
To adhere to the UCLH Service Commitment "Making a Difference Together" and adopt a professional approach to customer care at all times. To comply with the Trusts Equal Opportunities Policy and treat staff, patients, colleagues and potential employees with dignity and respect at all times. To take personal responsibility for promoting a safe environment and safe patient care by identifying areas of risk and following the Incident, Serious Incidents and Near Misses reporting policy and procedure. To take personal responsibility for ensuring that UCLH resources are used efficiently and with minimum wastage and to comply with the Trust's Standing Financial Instructions (SFIs). To be aware of and adhere to all Trust policies and procedures, the Health and Safety at Work Act and the Data Protection Act. To maintain confidentiality at all times.Other
The job description is not intended to be exhaustive and it is likely that duties may be altered from time to time in the light of changing circumstances and after consultation with the post holder. The postholder will be expected to actively participate in annual appraisals and set objectives in conjunction with your manager. Performance will be monitored against set objectives.
Come and be a part of the best NHS trust in England to work for, according to our staff*
* UCLH top trust to work at in England - In the most recent NHS staff survey UCLH had the highest percentage of staff who said they would recommend us as a place to work, out of all general acute or acute/community NHS trusts in England for the third year in a row.
UCLH recognises the benefits of flexible working for staff To find out more, visit: Flexible working.
To discover more about what makes UCLH a great place to work, visit: Why Choose UCLH?
Person Specification
Experience
Essential
- 1.Experience in an information analysis role Please outline your experience in an information analysis role
Skills and Abilities
Essential
- 2.Understanding of data quality issues and how these relate to the organisation as a whole What is your understanding of data quality issues and how these relate to the organisation as a whole?
- 3.SQL (or equivalent) skills Describe your skills and experience in SQL (or equivalent) and provide relevant examples
- 4.Use of MS Excel Describe your skills and experience in using Excel and provide relevant examples
Communication
Essential
- 5.Good oral and written communication skills In relation to the Job Description, please describe how your oral and written communication skills could be applied
Planning and Organisation Skills
Essential
- 6.Ability to take responsibility for own workload In relation to the Job Description, please describe how you would take responsibility for your workload.
Person Specification
Experience
Essential
- 1.Experience in an information analysis role Please outline your experience in an information analysis role
Skills and Abilities
Essential
- 2.Understanding of data quality issues and how these relate to the organisation as a whole What is your understanding of data quality issues and how these relate to the organisation as a whole?
- 3.SQL (or equivalent) skills Describe your skills and experience in SQL (or equivalent) and provide relevant examples
- 4.Use of MS Excel Describe your skills and experience in using Excel and provide relevant examples
Communication
Essential
- 5.Good oral and written communication skills In relation to the Job Description, please describe how your oral and written communication skills could be applied
Planning and Organisation Skills
Essential
- 6.Ability to take responsibility for own workload In relation to the Job Description, please describe how you would take responsibility for your workload.
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).
