Cornwall Partnership NHS Foundation Trust

Senior SQL Developer

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 date: to be confirmed

Main duties of the job

This role involves the development and maintenance of the Trust's Data Warehousing and Reporting Solution. The successful candidate will be working alongside other members of the Business Analytics team to write, document and test queries and reports using T-SQL and SSRS. They will be expected to develop, maintain and perform analyses on complex datasets used to fulfil National, Commissioner and local reporting requirements and provide an active role in the completion of data migrations whilst working alongside key stakeholders within the Trust.

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.

Details

Date posted

26 February 2024

Pay scheme

Agenda for change

Band

Band 6

Salary

£35,392 to £42,618 a year Per Annum

Contract

Permanent

Working pattern

Full-time, Home or remote working

Reference number

201-24-217

Job locations

Latham Park

Par

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 / Qualifications and Relevant Experience

Essential

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

Skills and Aptitude

Essential

  • Knowledge of or interest in Data Warehousing Principals and Data Visualisation technologies (Power BI, Tableaux)
  • experience/knowledge of designing, implementing and maintaining relational databases
  • Relevant experience of writing specifications from user requirements

Personal Qualities

Essential

  • Self-motivated and able to enthuse others at all levels and across disciplines
Person Specification

Education / Qualifications and Relevant Experience

Essential

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

Skills and Aptitude

Essential

  • Knowledge of or interest in Data Warehousing Principals and Data Visualisation technologies (Power BI, Tableaux)
  • experience/knowledge of designing, implementing and maintaining relational databases
  • Relevant experience of writing specifications from user requirements

Personal Qualities

Essential

  • Self-motivated and able to enthuse others at all levels and across disciplines

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

Par

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

Par

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

26 February 2024

Pay scheme

Agenda for change

Band

Band 6

Salary

£35,392 to £42,618 a year Per Annum

Contract

Permanent

Working pattern

Full-time, Home or remote working

Reference number

201-24-217

Job locations

Latham Park

Par

PL24 2HY


Supporting documents

Privacy notice

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