Senior Data Engineer

NHS Resolution

Information:

This job is now closed

Job summary

NHS Resolution is a not-for-profit part of the NHS working for health care providers to resolve claims fairly and to share learning across the NHS and beyond. We provide a supportive environment for our staff with specialist training and the opportunity for personal development.

NHS Resolution has put Business Intelligence at the heart of its strategy, and this has led to a transformation of the Business Intelligence department over the last 2 years. We currently have 2 full-time, permanent vacancies for a Senior Data Engineers to help us continue that journey and help us make the most of our data.

We have many complex data sets which are key to managing our £2.7bn annual budget and for feeding back learnings into the wider health system. We are currently undergoing large transformational projects and need to ensure that we can support the organisation fully.

Main duties of the job

The current day to day role involves developing data sets using technologies including SQL, SSIS and SSRS. This includes providing expert resourcing to other BI teams, ensuring integrity of the organisations data and undertaking development and project work to support our stakeholders.

The post holder will be expected to be educated to Masters Level Degree (or equivalent relevant experience) and to be an expert in SQL coding and have previous experience of SSIS and SSRS.

Please see the attached Job description and Person specification for more information.

About us

NHS Resolution is an Arms Length Body of the Department of Health & Social Care. As a not for profit part of the NHS, our purpose is to provide expertise to the NHS to resolve concerns fairly, share learning for improvement and preserve resources for patients. We have four key service areas:

Claims Management: delivering expertise in handling clinical and non-clinical claims to members of our Indemnity Schemes.

Practitioner Performance Advice: providing advice, support and interventions in relation to concerns about the individual performance of Doctors, Dentists and Pharmacists.

Primary Care Appeals: offering an impartial tribunal service for the fair handling of Primary Care contracting services.

Safety and Learning: supporting the NHS to better understand and learn from claims, concerns and disputes; to target safety activity while sharing learning across the NHS.

What do we have to offer?

At NHS Resolution, we strive to be an employer of choice. Some of the benefits we offer include access to the NHS Pension Scheme and a minimum of 27 days Annual Leave. We are also committed to support individuals in having a work and life balance, offering flexible working arrangements. Furthermore, we can offer a chance to gain extra skills and training and with regular reviews and a clear plan, all employees can develop to their full potential.

Date posted

03 May 2023

Pay scheme

Agenda for change

Band

Band 7

Salary

£41,659 to £47,672 a year plus HCAS (London only)

Contract

Permanent

Working pattern

Full-time

Reference number

M9912-NHSR-2023-48

Job locations

8th Floor, 10 South Colonnade

Canary Wharf

London

E14 4PU


Job description

Job responsibilities

For those that wish to work from home, we ask that you check you are able to access an average internet speed (per personworking from that location) of 10 Mbps download speed and at least 2 Mbps upload speed so that you can access and use our systems.

We have been granted permission to use the Employment Service's "Positive about Disabled People" symbol. Any applicant with a disability who meets the minimum specification for the post as set out in the person specification is guaranteed an interview.

Please note: If you require a Visa to work in the UK, NHS Resolution is currently unable to support any sponsorship requests.

Job description

Job responsibilities

For those that wish to work from home, we ask that you check you are able to access an average internet speed (per personworking from that location) of 10 Mbps download speed and at least 2 Mbps upload speed so that you can access and use our systems.

We have been granted permission to use the Employment Service's "Positive about Disabled People" symbol. Any applicant with a disability who meets the minimum specification for the post as set out in the person specification is guaranteed an interview.

Please note: If you require a Visa to work in the UK, NHS Resolution is currently unable to support any sponsorship requests.

Person Specification

Knowledge & Understanding

Essential

  • Knowledge and understanding of confidentiality within
  • the workplace (particularly within the NHS)

Desirable

  • In depth specialist knowledge of statistical and
  • information data analysis

Qualifications

Essential

  • Educated to Masters Degree level or equivalent relevant experience in database development and management

Desirable

  • PRINCE 2
  • MCSE: Data Management and Analytics Certification
  • DP-203: Data Engineering on Microsoft Azure Certification
  • AZ-400: Designing and Implementing Microsoft DevOps
  • Solutions Certification

Skills & Abilities

Essential

  • Ability to collate, analyse and interpret extremely
  • complex data sources
  • Ability to identify underlying problems by analysing
  • information and find effective solutions

Experience

Essential

  • Experience of managing multiple databases and DBA knowledge.
  • Extensive experience of analysing complex datasets effectively in a variety of settings
  • Experience of maintaining database back end processes such as jobs, backups and linked servers
  • Experience of using and building Azure or other cloud based solutions
Person Specification

Knowledge & Understanding

Essential

  • Knowledge and understanding of confidentiality within
  • the workplace (particularly within the NHS)

Desirable

  • In depth specialist knowledge of statistical and
  • information data analysis

Qualifications

Essential

  • Educated to Masters Degree level or equivalent relevant experience in database development and management

Desirable

  • PRINCE 2
  • MCSE: Data Management and Analytics Certification
  • DP-203: Data Engineering on Microsoft Azure Certification
  • AZ-400: Designing and Implementing Microsoft DevOps
  • Solutions Certification

Skills & Abilities

Essential

  • Ability to collate, analyse and interpret extremely
  • complex data sources
  • Ability to identify underlying problems by analysing
  • information and find effective solutions

Experience

Essential

  • Experience of managing multiple databases and DBA knowledge.
  • Extensive experience of analysing complex datasets effectively in a variety of settings
  • Experience of maintaining database back end processes such as jobs, backups and linked servers
  • Experience of using and building Azure or other cloud based solutions

Employer details

Employer name

NHS Resolution

Address

8th Floor, 10 South Colonnade

Canary Wharf

London

E14 4PU


Employer's website

https://resolution.nhs.uk/careers/ (Opens in a new tab)

Employer details

Employer name

NHS Resolution

Address

8th Floor, 10 South Colonnade

Canary Wharf

London

E14 4PU


Employer's website

https://resolution.nhs.uk/careers/ (Opens in a new tab)

For questions about the job, contact:

Data Delivery Manager

Neil Taylor

neil.taylor23@nhs.net

Date posted

03 May 2023

Pay scheme

Agenda for change

Band

Band 7

Salary

£41,659 to £47,672 a year plus HCAS (London only)

Contract

Permanent

Working pattern

Full-time

Reference number

M9912-NHSR-2023-48

Job locations

8th Floor, 10 South Colonnade

Canary Wharf

London

E14 4PU


Supporting documents

Privacy notice

NHS Resolution's privacy notice (opens in a new tab)