Cornwall Partnership NHS Foundation Trust

Data Warehouse Lead

Information:

This job is now closed

Job summary

An exciting opportunity to join a new and expanding team as we continue to implement our data warehouse and develop business intelligence visualisations, transforming data into intelligence to support performance management, effective decision making and service improvement. The post holder will be part of a team that operate as a resource pool within the Trusts Performance & Information Team acting as the expert on a range of topics relating to the Database Management including development of the data warehouse, interpretation of the NHS Data Dictionary, change control etc in order to provide a safe and reliable base for Performance & Information Analysis.

Proposed interview/assessment date - week commencing 29th January 2024

Main duties of the job

The post holder will be responsible for oversight of the delivery of key external reports and offloads, involving audit, progress reporting, as well as understanding the set-up, administration and data quality issues. They will also be responsible for developing the presentation layer from the data warehouse.

About us

We're an NHS community and mental health provider Trust based in Cornwall and the Isles of Scilly. We deliver community and hospital-based care to improve people's physical and mental health. We also provide specialist support to people with dementia or a learning disability.

We are a people organisation and people matter to us. As part of the team, you'll help support the health and wellbeing of the people who live and visit this beautiful part of the UK.

Over 4,000 people make up the Trust. This includes doctors, nurses, therapists, plus admin and support staff.

We work in people's homes, in community clinics and bases. Some staff work from one of our 13 community hospitals. Our aspiration is to have great people, provide great care, be a great place to work and a great partner.

Approximately 568,000 people live here. A third of people who live in Cornwall are supported by acute hospital services in Devon. As a result, we also work closely with our partners in Devon. In the summer, and during other holidays lots of people choose to visit the area. This increases the numbers of people who use our services.

Detailed job description and main responsibilities

To view a detailed job description and person specification including the main responsibilities of this role please see 'supporting documents'.

Details

Date posted

22 December 2023

Pay scheme

Agenda for change

Band

Band 7

Salary

£43,742 to £50,056 a year Per Annum

Contract

Permanent

Working pattern

Full-time, Home or remote working

Reference number

201-23-1427

Job locations

Latham Park

St Blazey

PL24 2HY


Job description

Job responsibilities

To view a detailed job description and person specification including the main responsibilities of this role please see supporting documents.

Job description

Job responsibilities

To view a detailed job description and person specification including the main responsibilities of this role please see supporting documents.

Person Specification

Education & Experience

Essential

  • Recent significant experience working with MSSQL in a work based environment.
  • Computer Science related qualification or equivalent experience
  • IT related Degree or equivalent experience and additional specialist knowledge acquired through experience and training

Skills

Essential

  • Extensive skills in writing SQL queries and developing reports using SQL Server Reporting Services, and good knowledge of optimisation techniques within SQL Server (e.g. indexing, query optimization)
  • Expert knowledge of: SSRS, SQL server, Industry Standard RDBMS (e.g. Oracle, MS SQL), MS Access, MS Office
  • Experience/knowledge of designing, implementing and maintaining relational databases

Other

Essential

  • Self-motivated and able to enthuse others at all levels and across disciplines
  • Able to work effectively as a team member and individually under own initiative.
  • Able to effectively communicate with members of other Teams and Services within the Trust.
Person Specification

Education & Experience

Essential

  • Recent significant experience working with MSSQL in a work based environment.
  • Computer Science related qualification or equivalent experience
  • IT related Degree or equivalent experience and additional specialist knowledge acquired through experience and training

Skills

Essential

  • Extensive skills in writing SQL queries and developing reports using SQL Server Reporting Services, and good knowledge of optimisation techniques within SQL Server (e.g. indexing, query optimization)
  • Expert knowledge of: SSRS, SQL server, Industry Standard RDBMS (e.g. Oracle, MS SQL), MS Access, MS Office
  • Experience/knowledge of designing, implementing and maintaining relational databases

Other

Essential

  • Self-motivated and able to enthuse others at all levels and across disciplines
  • Able to work effectively as a team member and individually under own initiative.
  • Able to effectively communicate with members of other Teams and Services within the Trust.

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.

Employer details

Employer name

Cornwall Partnership NHS Foundation Trust

Address

Latham Park

St Blazey

PL24 2HY


Employer's website

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

Employer details

Employer name

Cornwall Partnership NHS Foundation Trust

Address

Latham Park

St Blazey

PL24 2HY


Employer's website

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

Employer contact details

For questions about the job, contact:

Head of Business Analytics

Jonathan Trower

jonathan.trower@nhs.net

Details

Date posted

22 December 2023

Pay scheme

Agenda for change

Band

Band 7

Salary

£43,742 to £50,056 a year Per Annum

Contract

Permanent

Working pattern

Full-time, Home or remote working

Reference number

201-23-1427

Job locations

Latham Park

St Blazey

PL24 2HY


Supporting documents

Privacy notice

Cornwall Partnership NHS Foundation Trust's privacy notice (opens in a new tab)