Worcestershire Acute Hospitals NHS Trust

Senior Information Analyst

This job is now closed

Job summary

The post holder will be one of a team of analysts responsible for the extraction and processing of data from the data warehouse or other data collation sources; and using SQL and SSRS to provide insightful business intelligence reporting, analytical presentations and interpretations; that will enable our clinical and operational colleagues to make decisions. The post holder will have responsibility for the extraction and analytical manipulation of weekly/monthly information and performance reports at any level as required. These reports will include benchmarking information, monitoring of Health Standards and inclusion of non-patient performance information (eg Finance and HR). Work will include detailed analysis/trends of performance as required by the Trust to effectively manage trust performance.

Please note, we do not offer Certificate of Sponsorship for this role.

Main duties of the job

Data Extraction and processing

Extraction and processing of data from clinical, management information systems and bespoke data sources.
To translate national standards to the local arena and advise managers on data collection methods.

National and local reporting

As required have responsibility for any of:
Managing the process of national and regional data submissions
Any other statutory returns not specified above.
As required have responsibility for any of:
Production of monthly/weekly/daily performance information, Benchmarking, Trust project/programme support, Detailed performance analysis, Business Intelligent reporting including written papers.

Data Storage

To ensure adequate documentation exists for all data processes.
To ensure that the data continues to be stored and analysed according to the NHS Data Dictionary, and according to published NHS Information Standards Notices (ISNs)

Data Quality

To provide oversight on data quality.
To ensure the Department has a clear view on the quality of the data extracted from the systems before these extracts are sent to external organizations.
To liaise with the Data Quality Team, trainers and Directorate Information Analysts identifying areas of poor data quality and assist in identifying solutions.

Please note a full job description is included in this advertisement.

About us

Our purpose is simple - Putting Patients First. We are looking for exceptional colleagues who can help us achieve this.

Worcestershire Acute Hospitals NHS Trust is a large acute and specialised hospital trust that provides a range of local acute services to the residents of Worcestershire and more specialised services to a larger population in Herefordshire and beyond.

The Trust operates hospital-based services from three sites in Kidderminster, Redditch and Worcester

Our workforce is nearly 6,800 strong, and our caring staff are recognised as providing good and outstanding patient-centred care. You could be one of them.

We are committed to recruiting the best people to work with us to achieve our Vision - working in partnership to provide the best healthcare for our communities, leading and supporting our teams to move 4ward. Our 4ward behaviours, which we ask all staff to demonstrate, underpin our everyday work and remain firmly at the heart of all we do.

Our objectives are simple:

Best services for local people
Best experience of care and best outcomes for our patients
Best use of resources
Best people

Better never stops, and our Clinical Services Strategy provides a clear future vision for our Trust, our hospitals, our services and our role in the wider health and care system.

We are proud to have achieved Timewise accreditation - this means we are committed to embedding flexible working within our organisation as a flex positive employer.

Date posted

13 September 2023

Pay scheme

Agenda for change

Band

Band 6

Salary

£35,392 to £42,618 a year

Contract

Permanent

Working pattern

Full-time, Flexible working

Reference number

C9365-23-0559-2

Job locations

Charles Hastings Way

Worcester

Worcestershire

WR5 1DD

Job description

Job responsibilities

Key Working Relationships:

Internal: Trust Leadership Team, Divisional and Directorate Management, Clinical staff, Corporate Support teams, Patients and their families

External: Integrated care system representatives, NHSE improvement support teams, Health Economy stakeholders, Patients and their families, and Peer Trust representatives

Liaises With: All internal staff, patients and their families and external stakeholders as required (as required).

Risk Assessment: Concentrated periods of computer based working..

Job Purpose:

The postholder will be one of a team of analysts responsible for the extraction and processing of data from the data warehouse or other data collation sources; and using SQL and SSRS to provide insightful business intelligence reporting, analytical presentations and interpretations; that will enable our clinical and operational colleagues to make decisions. The postholder will have responsibility for the extraction and analytical manipulation of weekly/monthly information and performance reports at any level as required. These reports will include benchmarking information, monitoring of Health Standards and inclusion of non-patient performance information (eg Finance and HR). Work will include detailed analysis/trends of performance as required by the Trust to effectively manage trust performance.

Key Duties:

Data Extraction and Processing

Extraction and processing of data from clinical, management information systems and bespoke data sources.

Inputting to corporate databases where required in order to capture data.
To translate national standards to the local arena and advise managers on data collection methods.

2. National Reporting

As required have responsibility for any of:

Managing the process of national and regional data submissions

Any other statutory returns not specified above

3. Data Storage

To ensure adequate documentation exists for all data processes.
To ensure that the data continues to be stored and analysed according to the NHS Data Dictionary, and according to published NHS Information Standards Notices (ISNs).
Knowledge management - to contribute to a review of how the Dept information is stored on the network.

4. Internal Reporting

As required have responsibility for any of:

Production of monthly/weekly/daily performance information

Benchmarking.

Trust project/programme support.

Detailed performance analysis.

Business Intelligent reporting including written reporting.

5. Data Quality

To provide oversight on data quality within the data stored on clinical, management information systems and bespoke data sources.

To ensure the Department has a clear view on the quality of the data extracted from the systems before these extracts are sent to external organizations.

To liaise with the Data Quality Team, trainers and Directorate Information Analysts identifying areas of poor data quality and assist in identifying solutions.

General Duties:

Vision and Values:

The Trust aims to provide local services for local people. It has developed its vision to reflect this commitment.

To continue to be the major provider of acute/specialist services for the people of Worcestershire (and wider) with a strong reputation for providing outstanding, high quality, reliable, accessible and integrated healthcare for local people

Driving this commitment are the Trust-wide signature behaviours:

Do what we say we will do

No Delays, every day

We listen, we learn, we lead

Work together, celebrate together

PLEASE NOTE: A full job description is included in this advertisement.

Job description

Job responsibilities

Key Working Relationships:

Internal: Trust Leadership Team, Divisional and Directorate Management, Clinical staff, Corporate Support teams, Patients and their families

External: Integrated care system representatives, NHSE improvement support teams, Health Economy stakeholders, Patients and their families, and Peer Trust representatives

Liaises With: All internal staff, patients and their families and external stakeholders as required (as required).

Risk Assessment: Concentrated periods of computer based working..

Job Purpose:

The postholder will be one of a team of analysts responsible for the extraction and processing of data from the data warehouse or other data collation sources; and using SQL and SSRS to provide insightful business intelligence reporting, analytical presentations and interpretations; that will enable our clinical and operational colleagues to make decisions. The postholder will have responsibility for the extraction and analytical manipulation of weekly/monthly information and performance reports at any level as required. These reports will include benchmarking information, monitoring of Health Standards and inclusion of non-patient performance information (eg Finance and HR). Work will include detailed analysis/trends of performance as required by the Trust to effectively manage trust performance.

Key Duties:

Data Extraction and Processing

Extraction and processing of data from clinical, management information systems and bespoke data sources.

Inputting to corporate databases where required in order to capture data.
To translate national standards to the local arena and advise managers on data collection methods.

2. National Reporting

As required have responsibility for any of:

Managing the process of national and regional data submissions

Any other statutory returns not specified above

3. Data Storage

To ensure adequate documentation exists for all data processes.
To ensure that the data continues to be stored and analysed according to the NHS Data Dictionary, and according to published NHS Information Standards Notices (ISNs).
Knowledge management - to contribute to a review of how the Dept information is stored on the network.

4. Internal Reporting

As required have responsibility for any of:

Production of monthly/weekly/daily performance information

Benchmarking.

Trust project/programme support.

Detailed performance analysis.

Business Intelligent reporting including written reporting.

5. Data Quality

To provide oversight on data quality within the data stored on clinical, management information systems and bespoke data sources.

To ensure the Department has a clear view on the quality of the data extracted from the systems before these extracts are sent to external organizations.

To liaise with the Data Quality Team, trainers and Directorate Information Analysts identifying areas of poor data quality and assist in identifying solutions.

General Duties:

Vision and Values:

The Trust aims to provide local services for local people. It has developed its vision to reflect this commitment.

Driving this commitment are the Trust-wide signature behaviours:

Do what we say we will do

No Delays, every day

We listen, we learn, we lead

Work together, celebrate together

PLEASE NOTE: A full job description is included in this advertisement.

Person Specification

Experience

Essential

A minimum of 3 years experience as a data analyst, with an excellent understanding of Microsoft products.
Basic to 'competent' knowledge of SQL and SSRS

Desirable

Specialist knowledge and expertise working with large and complex datasets.
Advanced skills in SQL and SSRS. Understanding of Statistical Process Charts

Qualifications

Essential

Educated to degree level in a relevant discipline (or with equivalent knowledge/skills through work experience in similar roles)

Desirable

Evidence of continuous professional development

Skills / Knowledge

Essential

Ability to:
Interpret complex externally defined datasets;
Undertake in depth analysis;
Develop & deliver formal, complex statistical presentations appropriate to the audience;
Understand the relationships between datasets to identify the drivers behind performance changes;
Planning and organisational skills. The post requires the ability to plan a broad range of complex activities requiring the formulation and adjustment of plans.

Personal Qualities

Essential

Good verbal communicator - able to explain complex analytical outputs.
Excellent written and presentation skills.
They must be confident when communicating with people at all levels of the organisation and externally.
Must be able to work within a team.
Ability to react to changes in data requirements (Data set change notices etc) and software changes.
Ability to identify problems and suggest and implement solutions

Person Specification

Experience

Essential

A minimum of 3 years experience as a data analyst, with an excellent understanding of Microsoft products.
Basic to 'competent' knowledge of SQL and SSRS

Desirable

Specialist knowledge and expertise working with large and complex datasets.
Advanced skills in SQL and SSRS. Understanding of Statistical Process Charts

Qualifications

Essential

Educated to degree level in a relevant discipline (or with equivalent knowledge/skills through work experience in similar roles)

Desirable

Evidence of continuous professional development

Skills / Knowledge

Essential

Ability to:
Interpret complex externally defined datasets;
Undertake in depth analysis;
Develop & deliver formal, complex statistical presentations appropriate to the audience;
Understand the relationships between datasets to identify the drivers behind performance changes;
Planning and organisational skills. The post requires the ability to plan a broad range of complex activities requiring the formulation and adjustment of plans.

Personal Qualities

Essential

Good verbal communicator - able to explain complex analytical outputs.
Excellent written and presentation skills.
They must be confident when communicating with people at all levels of the organisation and externally.
Must be able to work within a team.
Ability to react to changes in data requirements (Data set change notices etc) and software changes.
Ability to identify problems and suggest and implement solutions

Employer details

Employer name

Worcestershire Acute Hospitals NHS Trust

Address

Charles Hastings Way

Worcester

Worcestershire

WR5 1DD

Employer's website

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

Employer details

Employer name

Worcestershire Acute Hospitals NHS Trust

Address

Charles Hastings Way

Worcester

Worcestershire

WR5 1DD

Employer's website

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