Job summary
The Department of Anaesthesia covers both the Royal Hallamshire and Northern General Hospitals and has a workforce of 120 Consultant Anaesthetists and approximately 80 Trainee Anaesthetists.
It provides a comprehensive anaesthetic service to a number of specialties across STHFT including:
o General Surgeryo Orthopaedic Surgery (including Trauma)o Plastic Surgeryo Cardiothoracic Surgeryo Vascular Surgeryo Renal Surgeryo Neurosurgeryo ENT Surgeryo Ophthalmic Surgeryo Jessop Wing Maternity Unit
To support the information requirements of the Operating Services, Critical Care and Anaesthesia (OSCCA) Care Group at Sheffield Teaching Hospitals NHS Foundation Trust.
This post will support Care Group decision makers in understanding ongoing operational performance, enhance service planning discussions, and support the well informed delivery of services across a wide range of Care Group areas (incl. operating theatres, pre-operative assessment, critical care, theatre admission areas, theatre recovery).
This post provides an essential support function to a wide range of administrative and clinical staff working across these internal areas, and the post holder will play a fundamental role in supporting Care Group leaders in providing a better service for our patients.
Main duties of the job
The role requires the frequent extraction of data from various databases across the Trust using Standard Query Language (SQL), followed by any subsequent wrangling, analysis and presentation to users both internal and external to the care group.
The nature of the Care Group's function requires that admitting directorate stakeholders must be well supported with their information requirements, and the post holder will be required to build and maintain relationships with staff across the Trust.
This will be via supporting the information needs of other Care Group (and corporate) management teams to support their ongoing planning & improvement discussions, and the post holder will be required to familiarise themselves with the theatre planning cycle and maintain various reports and database tables to ensure that the Trust has accurate oversight of its capacity and activity plans.
Supplying timely and accurate information to the numerous performance meetings attended by the Care Group's management teams is central to the role, alongside supporting various service improvement projects with their own specific information requirements. Adhoc requests for theatre information are numerous and often obscure.
The post holder will be required to oversee these adhoc information requests, producing reports & advisingstakeholders as required.
About us
You will be working for an organisation which values and respects all its staff and the community it serves. The Trust is a leader in the NHS and research sectors and provides excellent benefits for its staff. This includes commitments to professional development but also many policies to support employees in balancing their personal and professional lives.
We want you to come to STH, and stay at STH, our success starts with you. All our staff have been involved in developing our PROUD values and this why we believe that they make STH a better place for patients and staff alike. This is an exciting opportunity to join one of the largest acute teaching hospitals in the region and develop your skills within a major trauma centre. We aim to ensure no harm comes to our patients; we continually strive to improve patient experience and make our areas a great place to work and learn
Job description
Job responsibilities
Please view the attached Job Description and Person Specification documents for full details regarding this post.
When completing your application please ensure that you clearly demonstrate how you meet the role criteria
Job description
Job responsibilities
Please view the attached Job Description and Person Specification documents for full details regarding this post.
When completing your application please ensure that you clearly demonstrate how you meet the role criteria
Person Specification
Qualifications
Essential
- Educated to a Degree Level (or equivalent experience in an information role)
Desirable
- Post grad qualification (or equivalent experience)
Experience
Essential
- Experience of data wrangling and analysis, with an ability to produce aesthetically pleasing report outputs and experience of presenting interpreted results demonstrable though a degree or through equivalent experience.
- Highly IT literate, with advanced knowledge and experience of Microsoft Office packages, in particular Microsoft Excel.
- Highly organised, with experience of managing a dynamic workload and to tight deadlines.
- Experience of using SQL to query databases
Desirable
- Experience with R, RStudio, R Shiny, PowerBI
- Working in an NHS Information Environment.
- Experience of using SQL to build and manage/maintain databases
- Work in an acute trust.
- Experience of using Trust information systems.
Knowledge
Essential
- Understanding of principles of data analysis and basic statistics,
- Ability to recognise themes and trends from complex data and interpretation of results to stakeholders. Understanding of data protection legislation and its impact on the role day to day.
- An understanding of the issues facing the NHS and strategic objectives
Desirable
- Qualifications in any data analytics software or programming languages
Special Skills/Aptitudes
Essential
- Ability to analyse information, including receiving highly complex and sensitive information on patient details and diagnoses
- Ability to interpret, draw conclusions from analysis and synthesise new knowledge from the findings.
- Ability to relay conflicting and contentious findings to those receiving it.
- Ability to understand national policy and guidance documents to provide expertise on information issues.
- Ability to develop expert technical knowledge of information systems including in depth knowledge of NHS data definitions.
Desirable
- Expert skills in complex data extraction from information databases including the use of Structured Query Language (SQL) and manipulation of this data in spreadsheets and PC applications, such as Excel, using skills at an advanced level.
- Ability to contribute to decision making and show considerable initiative in the formulation of recommendations and subsequent actions.
Person Specification
Qualifications
Essential
- Educated to a Degree Level (or equivalent experience in an information role)
Desirable
- Post grad qualification (or equivalent experience)
Experience
Essential
- Experience of data wrangling and analysis, with an ability to produce aesthetically pleasing report outputs and experience of presenting interpreted results demonstrable though a degree or through equivalent experience.
- Highly IT literate, with advanced knowledge and experience of Microsoft Office packages, in particular Microsoft Excel.
- Highly organised, with experience of managing a dynamic workload and to tight deadlines.
- Experience of using SQL to query databases
Desirable
- Experience with R, RStudio, R Shiny, PowerBI
- Working in an NHS Information Environment.
- Experience of using SQL to build and manage/maintain databases
- Work in an acute trust.
- Experience of using Trust information systems.
Knowledge
Essential
- Understanding of principles of data analysis and basic statistics,
- Ability to recognise themes and trends from complex data and interpretation of results to stakeholders. Understanding of data protection legislation and its impact on the role day to day.
- An understanding of the issues facing the NHS and strategic objectives
Desirable
- Qualifications in any data analytics software or programming languages
Special Skills/Aptitudes
Essential
- Ability to analyse information, including receiving highly complex and sensitive information on patient details and diagnoses
- Ability to interpret, draw conclusions from analysis and synthesise new knowledge from the findings.
- Ability to relay conflicting and contentious findings to those receiving it.
- Ability to understand national policy and guidance documents to provide expertise on information issues.
- Ability to develop expert technical knowledge of information systems including in depth knowledge of NHS data definitions.
Desirable
- Expert skills in complex data extraction from information databases including the use of Structured Query Language (SQL) and manipulation of this data in spreadsheets and PC applications, such as Excel, using skills at an advanced level.
- Ability to contribute to decision making and show considerable initiative in the formulation of recommendations and subsequent actions.
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).
