Job summary
This is a valuable opportunity to apply analytical and technical skills to support the trust in delivering high quality patient care working within our dynamic Information Department at Oxford University Hospitals Foundation Trust.
This corporate role supports the delivery of routine and ad-hoc reporting on activity, waiting times & performance against operational measures. As well as running routine processes you will be responding to ad-hoc requests for information and contributing to project work, developing the reporting functionality from the trust's local data warehouse.
Interviews will be done remotely and there will be a technical assessment using MS Excel and MS SQL to be completed prior the interview. An assessment pack will be sent via email to the candidate prior the interview date. The interview will be about 2 hours in total where the assessment will be discussed as well as interview questions.
Previous applicants need not apply.
Main duties of the job
You will need to work closely with corporate teams within the trust and also develop excellent working relationships with operational services and others external to the Trust.
The team is structured with Band 4, Band 5 and Band 6 analysts within 2 teams, each with a Team Leader. This lends itself to a progressive department with many opportunities for career development.
About us
Oxford University Hospitals NHS Foundation Trust is one of the largest NHS teaching trusts in the country. It provides a wide range of general and specialist clinical services and is a base for medical education, training and research. Find out more here www.ouh.nhs.uk
The Trust comprises four hospitals - the John Radcliffe Hospital, Churchill Hospital and Nuffield Orthopaedic Centre in Headington and the Horton General Hospital in Banbury.
Our values, standards and behaviours define the quality of clinical care we offer and the professional relationships we make with our patients, colleagues and the wider community. We call thisDelivering Compassionate Excellenceand its focus is on our values of compassion, respect, learning, delivery, improvement and excellence. These values put patients at the heart of what we do and underpin the quality healthcare we would like for ourselves or a member of our family. Watch how we set out to deliver compassionate excellence via theOUH YouTube channel.
Job description
Job responsibilities
A typical week will involve tasks such as producing routine reports from procedure notes, extracting data and information for ad hoc requests both internally and externally to the hospital, extracting information for Freedom of Information requests and helping to maintain and create ORBIT reports within Tableau. Many of the tasks require writing queries and troubleshooting existing queries using SQL and Access databases with many reports produced in Excel. Therefore you should have good analytical skills backed up with evidence of ability to work with databases. An understanding of the NHS datasets is desirable. The ability to work under pressure to achieve deadlines is essential.
Please note that automated emails may be diverted to your Junk email box. Please double check this for progress on your application.
Please refer to the Job Description and Person Spec for further information
Job description
Job responsibilities
A typical week will involve tasks such as producing routine reports from procedure notes, extracting data and information for ad hoc requests both internally and externally to the hospital, extracting information for Freedom of Information requests and helping to maintain and create ORBIT reports within Tableau. Many of the tasks require writing queries and troubleshooting existing queries using SQL and Access databases with many reports produced in Excel. Therefore you should have good analytical skills backed up with evidence of ability to work with databases. An understanding of the NHS datasets is desirable. The ability to work under pressure to achieve deadlines is essential.
Please note that automated emails may be diverted to your Junk email box. Please double check this for progress on your application.
Please refer to the Job Description and Person Spec for further information
Person Specification
Education
Essential
- 'A' Levels or equivalent
- Maths and English GCSE grade C (4/5) and above or equivalent
- Ongoing learning and development aspirations
Desirable
- Degree/Graduate calibre (or equivalent)
Personal attributes
Essential
- Analytical & logical approach to problem solving
- Organised & able to work to tight deadlines
- Attention to detail
- Positive attitude & collaborative approach
- Able to work on own initiative
Communication Skills
Essential
- Good interpersonal/team skills
- Able to work flexibly & develop working relationships across organisational boundaries
Desirable
- Good negotiating and influencing skills
IT Experience/Knowledge
Essential
- Good working knowledge of Microsoft Excel and other MS Office based applications.
- Excellent analytical and numeric skills
- Basic level of understanding of relational databases
Desirable
- Ability to query complex relational databases to extract and analyse data (e.g. using MS Access or SQL)
- Querying data with Microsoft SQL
- Report development using Tableau
Experience & Skills
Essential
- Customer focussed outlook
Desirable
- Broad and current knowledge of NHS information and processes
- Knowledge of NHS activity issues, data collection and reporting
Person Specification
Education
Essential
- 'A' Levels or equivalent
- Maths and English GCSE grade C (4/5) and above or equivalent
- Ongoing learning and development aspirations
Desirable
- Degree/Graduate calibre (or equivalent)
Personal attributes
Essential
- Analytical & logical approach to problem solving
- Organised & able to work to tight deadlines
- Attention to detail
- Positive attitude & collaborative approach
- Able to work on own initiative
Communication Skills
Essential
- Good interpersonal/team skills
- Able to work flexibly & develop working relationships across organisational boundaries
Desirable
- Good negotiating and influencing skills
IT Experience/Knowledge
Essential
- Good working knowledge of Microsoft Excel and other MS Office based applications.
- Excellent analytical and numeric skills
- Basic level of understanding of relational databases
Desirable
- Ability to query complex relational databases to extract and analyse data (e.g. using MS Access or SQL)
- Querying data with Microsoft SQL
- Report development using Tableau
Experience & Skills
Essential
- Customer focussed outlook
Desirable
- Broad and current knowledge of NHS information and processes
- Knowledge of NHS activity issues, data collection and reporting
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).
Employer details
Employer name
Oxford University Hospitals NHS Foundation Trust
Address
OUH Cowley
OUHC, 3rd Floor, Unipart House Business Centre, Garsington Road
Oxford
OX4 2PG
Employer's website
https://www.ouh.nhs.uk/ (Opens in a new tab)
