Senior Information Analyst – SQL Developer/DWH

Royal Cornwall Hospitals Trust

Information:

This job is now closed

Job summary

This is an exciting time for the NHS in Cornwall, with investment that will fund the development of a new Electronic Patient Record at the Royal Cornwall Hospitals Trust. This will be the biggest investment and transformation in the digital technology, that supports our patient care, for more than 30 years. Our new EPR will touch the lives of staff, patients and partner organisations across Cornwall, the Isles of Scilly and beyond. Our services will be supported by a software system that is modern, flexible, and able to support the ongoing health care needs of our population. A key part of the programme will be the transformation of reporting methods, information provision and business intelligence extracted from the new system. To support this, we are developing new posts in our vital, award winning, Information and Business Intelligence (BI) service. You could play a crucial part in our journey to deliver brilliant healthcare services across Cornwall.

Key elements of this post include:-

  • Educated to degree level / post grad diploma.
  • Computing related qualification
  • Comprehensive knowledge & expert use of SQL Language and SQL Server
  • Experience of working in information management and the use of information systems.
  • Logical and organised in approach, enthusiastic, team player.
  • Highly Skilled in collecting, extracting and validating complex and sensitive data from a variety of computer systems

Main duties of the job

The Information and Business Intelligence team have a direct and tangible link to the high quality of patient care and patient safety delivered across the Trust, providing key reporting/BI solutions. These roles will support the reporting/information work streams during the Electronic Patient Record (EPR) implementation. This will encompass assisting the Senior Management Team in ensuring reporting from the EPR complies with the national information guidelines, updating Data Collection Worksheets, lead on implementing quality checks and producing data quality reports. The post holders will also be responsible for cascading specialist knowledge and understanding of the new system, into the wider Information and BI Team.

We are looking for motivated and committed individuals, who are passionate about how data, information and BI tools can transform services and underpin the health of our population. We are looking for candidates with strong SQL experience, knowledge and experience of analytical techniques and technologies, an aptitude for problem-solving, a keen eye for detail, data analysis, and excellent communication skills. The best candidates will have experience in data extraction, analysis and data reporting and developing new information reports using a variety of business intelligence tools.

About us

Royal Cornwall Hospitals NHS Trust is the biggest provider of healthcare services in Cornwall and the Isles of Scilly. Our three main sites are Royal Cornwall Hospital Truro, St Michael's Hospital Hayle and West Cornwall Hospital Penzance, our staff and services are available across the region.

The Trust employs 5,000+ staff, has a budget of £380 million and 750 beds. We work with health and social care organisations -including NHS Kernow and NHS England- to ensure local healthcare needs are met. We provide acute medical, surgical and specialist services to around 500,000- which can increase significantly during busy holiday periods.

The Trust has teaching hospitals status as part of the University of Exeter Medical School. Keeping at the forefront of medical advances, we continually develop clinical services and are committed to maximising the range of specialist care offered locally.

We can offer you a rewarding career in a supportive working environment. We have extensive educational links to help you realise your full potential and develop skills to provide outstanding healthcare to the local community.

Enjoy an outstanding quality of life in a place that offers surfing beaches and fishing harbours to beautiful countryside and historic towns. With clean air, plenty of opportunities for outdoor activities and excellent schools, colleges and universities (including adult education) it is the ideal place for families and for you to develop your own career.

Date posted

08 November 2024

Pay scheme

Agenda for change

Band

Band 6

Salary

£37,338 to £44,962 a year Per annum pro rata

Contract

Fixed term

Duration

10 months

Working pattern

Full-time, Part-time

Reference number

156-6780872

Job locations

Royal Cornwall Hospital

Treliske

Truro

TR1 3LJ


Job description

Job responsibilities

PLEASE NOTE: To view the full Job Description and Person Specification, please click the supporting document on the right-hand side.

To be an employee of the NHS you need to successfully complete the following:

  • Identity Checks
  • Professional registration and qualification checks
  • Employment history and reference checks
  • Occupational Health clearance
  • Satisfactory Disclosure and Barring Service check
  • Right to work in the UK

For further information please visit:

https://www.nhsemployers.org/topics-networks/employment-standards-and-regulation

We reserve the right to close this advert early.

We may be able to offer flexible working. Please discuss at interview.

We may be able to offer sponsorship but this is not guaranteed.

Job description

Job responsibilities

PLEASE NOTE: To view the full Job Description and Person Specification, please click the supporting document on the right-hand side.

To be an employee of the NHS you need to successfully complete the following:

  • Identity Checks
  • Professional registration and qualification checks
  • Employment history and reference checks
  • Occupational Health clearance
  • Satisfactory Disclosure and Barring Service check
  • Right to work in the UK

For further information please visit:

https://www.nhsemployers.org/topics-networks/employment-standards-and-regulation

We reserve the right to close this advert early.

We may be able to offer flexible working. Please discuss at interview.

We may be able to offer sponsorship but this is not guaranteed.

Person Specification

Qualifications

Essential

  • Educated to degree level.
  • Computing related qualification.

Experience

Essential

  • Comprehensive knowledge of SQL Language and SQL Server.
  • Experience of working in information management and the use of information systems.

Desirable

  • Specialist knowledge and experience of business intelligence software both from a customer and technical viewpoint (particularly SharePoint and the Microsoft BI stack).
  • Significant experience of working in Information Management in the NHS or Healthcare environment.

Skills & Knowledge

Essential

  • Expert use of SQL.
  • Logical and organised in approach, enthusiastic, team player.
  • Highly Skilled in collecting, extracting and validating complex and sensitive data from a variety of computer systems.
  • Highly skilled in understanding, interpreting and responding appropriately to complex information requests, queries and problems.

Desirable

  • Comprehensive knowledge and understanding of NHS data definitions, Acute and Community information, clinical terminology and coding systems.
  • Comprehensive knowledge and practical experience of Hospital systems such as PAS, ICS and Encore.
Person Specification

Qualifications

Essential

  • Educated to degree level.
  • Computing related qualification.

Experience

Essential

  • Comprehensive knowledge of SQL Language and SQL Server.
  • Experience of working in information management and the use of information systems.

Desirable

  • Specialist knowledge and experience of business intelligence software both from a customer and technical viewpoint (particularly SharePoint and the Microsoft BI stack).
  • Significant experience of working in Information Management in the NHS or Healthcare environment.

Skills & Knowledge

Essential

  • Expert use of SQL.
  • Logical and organised in approach, enthusiastic, team player.
  • Highly Skilled in collecting, extracting and validating complex and sensitive data from a variety of computer systems.
  • Highly skilled in understanding, interpreting and responding appropriately to complex information requests, queries and problems.

Desirable

  • Comprehensive knowledge and understanding of NHS data definitions, Acute and Community information, clinical terminology and coding systems.
  • Comprehensive knowledge and practical experience of Hospital systems such as PAS, ICS and Encore.

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.

Certificate of Sponsorship

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.

Certificate of Sponsorship

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

Royal Cornwall Hospitals Trust

Address

Royal Cornwall Hospital

Treliske

Truro

TR1 3LJ


Employer's website

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


Employer details

Employer name

Royal Cornwall Hospitals Trust

Address

Royal Cornwall Hospital

Treliske

Truro

TR1 3LJ


Employer's website

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


For questions about the job, contact:

EPR BI Principal Information Analyst

Lynne Vinten

Lynne.vinten@nhs.net

Date posted

08 November 2024

Pay scheme

Agenda for change

Band

Band 6

Salary

£37,338 to £44,962 a year Per annum pro rata

Contract

Fixed term

Duration

10 months

Working pattern

Full-time, Part-time

Reference number

156-6780872

Job locations

Royal Cornwall Hospital

Treliske

Truro

TR1 3LJ


Supporting documents

Privacy notice

Royal Cornwall Hospitals Trust's privacy notice (opens in a new tab)