Data Warehouse Technical Lead (XN07)

Leeds Teaching Hospitals

Information:

This job is now closed

Job summary

We are seeking to appoint an ambitious, highly motivated, and enthusiastic technical lead with excellent technical data skills and knowledge of information analysis/financial data, commissioning data flows, NHS data contract requirements, the NHS data dictionary and Secondary Uses Service (SUS).

The successful candidate will be joining Digital Information & Solutions CSU, overseeing the day to day management of the Commissioning Information team, ensuring all reporting deadlines are met and the ongoing development, accuracy and timeliness of commissioning datasets.

You will provide advice and support to relevant projects within the department, to partners across the Trust and Externally.

Main duties of the job

You will provide day to day management to the Commissioning Team members, ensuring all routine deadlines are met, provide technical guidance and expert advice to support and guide the team in supporting the organisation. This will involve managing the teams workload, allocating tasks, monitoring progress, overseeing and supporting the team in responding to ad-hoc requests and new technical developments.

To be successful you will need to be highly organised, knowledgeable and technically skilled.

The successful candidate will report to the Commissioning Information Manager, ensuring SUS and other mandatory commissioner submissions are completed to deadlines and quality requirements are met. They will support the Commissioning Information Manager to provide input into annual contracting processes, providing advice relating to updated contracting rules, reporting requirements and assessing impacts related to Trust Income.

About us

The Commissioning Team are responsible for the regular processing and reporting of income related data for the Trust, processing over 100 datasets per month. The Team build and maintain a large range of complex SQL based processes and transformations and support the Trust in new / updated reporting requirements.

The Teams vision is to provide the highest quality work and care to patients. To achieve this vision, we all work to The Leeds Way values, which are:

Patient Centred

Fair

Collaborative

Accountable

Empowered

Hybrid working is available (home and office working) with the base being St James Hospital Leeds.

Initial Tenure is 12 months fixed term, tenure may be made permanent after 12-month review.

Leeds Teaching Hospitals is committed to our process of redeploying 'at risk' members of our existing workforce to new roles. As such, all our job adverts are subject to this policy and we reserve the right to close, delay or remove adverts while this process is completed. If you do experience a delay in the shortlisting stage of the recruitment cycle, please bear with us while this process is completed, and contact the named contact if you have any questions.

Date posted

07 October 2022

Pay scheme

Agenda for change

Band

Band 7

Salary

£41,659 to £47,672 a year

Contract

Fixed term

Duration

12 months

Working pattern

Full-time

Reference number

C9298-INF-021

Job locations

St. James's University Hospital

Beckett Street

Leeds

LS9 7TF


Job description

Job responsibilities

To assist the provision of technical solutions in the delivery of a Trust Wide Data Warehouse. To ensure a robust reporting strategy is implemented for Leeds Teaching Hospitals. To assist in the provision of an information and analysis service delivering accurate, timely and effectively information tailored to meet specific needs in support of operational requirements

The post holder will work as part of the Data Warehouse team to provide assistance to the Technical Information Managers in delivering a consistent, technical solution for the integration of data from a myriad of clinical information systems.

Assist the Technical Information Managers as required and in co-ordination with other Senior Information Managers, lead a Team of Information Analysts.

Key result areas are patient access, clinical governance, and performance management which support the strategic business plan and the accurate and timely submission of Trust data to the Department of Health, which has a direct bearing on the revenue of the Trust.

The jobholder will assist in the investigation of a range of highly complex IM&T issues and is a professional lead on the delivery of multi-layered solutions to allow the Trust to fulfil its internal and external information gathering and reporting requirements.

Provide technical support required by Trusts commissioning processes. This includes the accurate submissions to Secondary Users Service (SUS) and development of other income dependent data flows, ensuring Trust income is secured.

Job description

Job responsibilities

To assist the provision of technical solutions in the delivery of a Trust Wide Data Warehouse. To ensure a robust reporting strategy is implemented for Leeds Teaching Hospitals. To assist in the provision of an information and analysis service delivering accurate, timely and effectively information tailored to meet specific needs in support of operational requirements

The post holder will work as part of the Data Warehouse team to provide assistance to the Technical Information Managers in delivering a consistent, technical solution for the integration of data from a myriad of clinical information systems.

Assist the Technical Information Managers as required and in co-ordination with other Senior Information Managers, lead a Team of Information Analysts.

Key result areas are patient access, clinical governance, and performance management which support the strategic business plan and the accurate and timely submission of Trust data to the Department of Health, which has a direct bearing on the revenue of the Trust.

The jobholder will assist in the investigation of a range of highly complex IM&T issues and is a professional lead on the delivery of multi-layered solutions to allow the Trust to fulfil its internal and external information gathering and reporting requirements.

Provide technical support required by Trusts commissioning processes. This includes the accurate submissions to Secondary Users Service (SUS) and development of other income dependent data flows, ensuring Trust income is secured.

Person Specification

Qualifications

Essential

  • Degree or equivalent experience

Desirable

  • PRINCE project management skills

Experience

Essential

  • Advanced SQL script writing.
  • Data analysis, interpretation & problem solving.
  • SSIS skills.
  • Experience of source control processes.
  • Knowledge of database design.
  • Experience managing a team.

Desirable

  • Knowledge of Secondary Users Service (SUS).
  • Knowledge of Commissioner Assignment methodologies.
  • Technical expertise in the manipulation and presentation of data using spreadsheets.

Skills & Behaviours

Essential

  • A strong background in communicating with a wide range of technical and clinical stakeholders at all levels.
  • Ability to prioritise workload and projects.
  • Analytical and troubleshooting skills.
Person Specification

Qualifications

Essential

  • Degree or equivalent experience

Desirable

  • PRINCE project management skills

Experience

Essential

  • Advanced SQL script writing.
  • Data analysis, interpretation & problem solving.
  • SSIS skills.
  • Experience of source control processes.
  • Knowledge of database design.
  • Experience managing a team.

Desirable

  • Knowledge of Secondary Users Service (SUS).
  • Knowledge of Commissioner Assignment methodologies.
  • Technical expertise in the manipulation and presentation of data using spreadsheets.

Skills & Behaviours

Essential

  • A strong background in communicating with a wide range of technical and clinical stakeholders at all levels.
  • Ability to prioritise workload and projects.
  • Analytical and troubleshooting skills.

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

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

Leeds Teaching Hospitals

Address

St. James's University Hospital

Beckett Street

Leeds

LS9 7TF


Employer's website

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


Employer details

Employer name

Leeds Teaching Hospitals

Address

St. James's University Hospital

Beckett Street

Leeds

LS9 7TF


Employer's website

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


For questions about the job, contact:

Business Support Apprentice

Chia Johnson

chia.johnson@nhs.net

Date posted

07 October 2022

Pay scheme

Agenda for change

Band

Band 7

Salary

£41,659 to £47,672 a year

Contract

Fixed term

Duration

12 months

Working pattern

Full-time

Reference number

C9298-INF-021

Job locations

St. James's University Hospital

Beckett Street

Leeds

LS9 7TF


Supporting documents

Privacy notice

Leeds Teaching Hospitals's privacy notice (opens in a new tab)