Job summary
An exciting opportunity has arisen for an Information Analyst to support the business intelligence and reporting function within the Pharmacy department. The role will involve the production of a wide range of analysis for clinical directorates and corporate services within the Trust.
Although, based at Freeman Hospital with the Pharmacy Medicines Management Team, the job involves regular contact with staff from a wide range of hospital and community departments, colleagues from corporate departments, other analysts and IT staff and representatives of relevant organisations outside the Trust. Communication will be either face to face (including attendance at directorate, specialty or departmental meetings), via the telephone, video call or by email.
- Interview Date Thursday 19 June 2025
- 37 Hours 30 Minutes/Week
- You will be redirected to Trac to apply for the vacancy. Please expand the job details section and read all of the information before applying for the vacancy
NO AGENCIES PLEASE
Main duties of the job
This post requires you to develop complex queries, manipulate data and validate, design, present and discuss reports. It will be necessary to investigate anomalies and gaps in data and liaise with colleagues to understand if there are any operational issues affecting the accuracy or completeness of information. You will lead on specific data collections and take responsibility for meeting regional and national deadlines.To be successful in this post you must have a flexible approach to work and function well as part of a team. You must have strong problem-solving and communication skills, have proven, advanced spreadsheet skills and have experience of writing SQL queries and using Microsoft Power BI or similar business intelligence software. In addition to excellent data manipulation and transformation skills you must be able to present and communicate your findings to clinical and non-clinical staff via a number of different means. This is a real opportunity to showcase your knowledge and skills and lead the reporting from a rich, complex clinical data set. Applicants must possess either a degree level qualification in a relevant subject, hold a Post-Graduate Certificate in Health Information Systems or have significant specialist experience within NHS Information Management.
About us
Our staff oversee over 6,500 patient contacts every day, delivering high standards of healthcare from the following sites:
o Freeman Hospitalo Royal Victoria Infirmary (RVI)o Health Innovation Neighbourhood (on the former Newcastle General Hospital and Centre for Ageing and Vitality site)o Newcastle Dental Hospitalo Newcastle Fertility Centreo Northern Centre for Cancer Care, North Cumbriao Northern Genetics Serviceo Cramlington Manor Walks
These include a range of flagship services which deliver cutting-edge care (supported by state-of-the-art diagnostic services in both radiology and pathology) and are a catalyst for innovation to support pioneering clinical practice in the NHS.
We also have offices at Regent Point in Gosforth and community sites.
Please see attached information on what Staff Benefits we have to offer at our Trust under 'Documents to download' or 'Supporting documents'.
For further information on The Newcastle upon Tyne Hospitals NHS Foundation Trust please visit: Careers | Newcastle Hospitals | NHS | Newcastle Hospitals and Newcastle Hospitals NHS Foundation Trust
Job description
Job responsibilities
- To support the Pharmacy Department in providing dedicated information support to clinical directorates and corporate services.
- To work with colleagues to ensure that complete and accurate data is available in a timely fashion.
As a flexible working friendly organisation, we want to be sure that you can work in a way that is best for us and for our patients, and for you. Speak to us about how we might be able to accommodate a flexible working arrangement. If it works for the service, we will do our best to make it work for you.
Job description
Job responsibilities
- To support the Pharmacy Department in providing dedicated information support to clinical directorates and corporate services.
- To work with colleagues to ensure that complete and accurate data is available in a timely fashion.
As a flexible working friendly organisation, we want to be sure that you can work in a way that is best for us and for our patients, and for you. Speak to us about how we might be able to accommodate a flexible working arrangement. If it works for the service, we will do our best to make it work for you.
Person Specification
Qualifications & Education
Essential
- Possess degree level qualification in relevant subject or Post- Graduate Certificate in Health Information Systems, or have significant specialist experience within NHS Management Information
Desirable
- Knowledge of medical terminology
Knowledge & Experience
Essential
- Using spreadsheets to a high level
- The use of databases
- Computer literacy and a strong working knowledge of Microsoft Windows
- Have previous experience of writing SQL queries
- Have previous experience of Microsoft Power BI or similar packages
Desirable
- Have previous experience of data modelling and analysis
- Have previous experience writing R scripts
Skills & Abilities
Essential
- Possess strong numerical and statistical skills
- Have excellent communication skills and be able to work to deadlines
- Possess decision making skills and have the ability to delegate tasks and motivate staff
Desirable
- Possess good presentation skills
- Be able to design and implement practical data collection policies, procedures and processes
Person Specification
Qualifications & Education
Essential
- Possess degree level qualification in relevant subject or Post- Graduate Certificate in Health Information Systems, or have significant specialist experience within NHS Management Information
Desirable
- Knowledge of medical terminology
Knowledge & Experience
Essential
- Using spreadsheets to a high level
- The use of databases
- Computer literacy and a strong working knowledge of Microsoft Windows
- Have previous experience of writing SQL queries
- Have previous experience of Microsoft Power BI or similar packages
Desirable
- Have previous experience of data modelling and analysis
- Have previous experience writing R scripts
Skills & Abilities
Essential
- Possess strong numerical and statistical skills
- Have excellent communication skills and be able to work to deadlines
- Possess decision making skills and have the ability to delegate tasks and motivate staff
Desirable
- Possess good presentation skills
- Be able to design and implement practical data collection policies, procedures and processes
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).