Leeds Teaching Hospitals

Data Warehouse Technical Lead (XN07)

The closing date is 29 May 2025

Job summary

Expected Shortlisting Date

27/05/2025

Planned Interview Date

28/05/2025

We reserve the right to close at any time if sufficient applicants.

At Leeds Teaching Hospitals NHS Trust, we believe technology holds the key to delivering outstanding healthcare right across our services and taking care of it, now and in the future. We have a five-year plan that will see us investing heavily in our Technology and building an Azure cloud hosted Data Platform; a great opportunity for the successful applicant to learn new skills or enhance on existing skills experience working within an Azure cloud data environment. This investment will boost the departments capabilities to increase our delivery and responsiveness right across our services and develop highly skilled technical and data experts. We are now looking for a highly skilled candidate with extensive experience as an SQL developer to apply for the role of Data Warehouse Technical Lead to join us on this journey.

Main duties of the job

Enhance, deliver, and maintain the Target Operating Model for the team.

SQL expert for the team to lead during investigation and development of requirements.

Influence the strategic technology decisions through feedback and collaborative working with all relevant Tech stakeholders.

Maintain product backlog and act as lead for Data Preparation to support Business Intelligence analytics and reporting.

Provide coaching and development of colleagues to create resilience and succession.

Identify opportunities for innovation through existing or future data capabilities.

Drive continuous improvement to proactively identify & remove waste from processes & activities.

Develop and maintain iterations and stories in support of products and manage increments and change.

Identify, manage, and maintain relationships with key stakeholders across the business.

Identify and manage risks and issues.

About us

DIT at LTHT is a highly motivated and inclusive place to work. We hold our Leeds Way Values in high esteem and respect all colleagues. Within the trust we are always looking to improve and give the best service possible, and we are looking for individuals with the same drive to join us.

DIT look after the Trusts information technology, responsible for delivering and embedding the latest digital innovations, finding the right hardware and software to meet business needs, turning information into insight and everything in between. Its an exciting time to join us, as we offer varied and rewarding opportunities.

Wed love to consider your application if you want to be a part of delivering operational services that allow patients to be treated effectively across Leeds.

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.

Details

Date posted

08 May 2025

Pay scheme

Agenda for change

Band

Band 7

Salary

£46,148 to £52,809 a year

Contract

Permanent

Working pattern

Full-time

Reference number

C9298-INF-207

Job locations

St. James's University Hospital

Beckett Street

Leeds

LS9 7TF


Job description

Job responsibilities

Please see supporting documents for full Job Description with further information on requirements of the role, the department and workflows and full person specification.

Job description

Job responsibilities

Please see supporting documents for full Job Description with further information on requirements of the role, the department and workflows and full person specification.

Person Specification

Qualifications

Essential

  • Degree or equivalent level qualification in a numerate/analytical discipline or equivalent industry experience and some amount of experience ideally in an NHS information management role.
  • Evidence of Continuous Professional Development, i.e. specialist IM&T training/study/research, attendance at relevant conferences/workshops.

Desirable

  • Staff Management, including objective setting, appraisal and PDPs.

Additional Requirements

Essential

  • Identifying and resolving complex data problems.
  • Multi-disciplinary team working.
  • Planning and organisation, prioritisation, strategy formulation and management.
  • Training and mentoring.
  • Analytical and information consultancy.
  • Complex analytical report writing.

Experience

Essential

  • Expert SQL developer skillset in versions 2012-2019, along with a strong background in developing under the Microsoft SQL Server Stack.
  • Excellent Data Preparation knowledge to support Business Intelligence analytics and reporting. Experience in the use of SourceVersion Control systems such as GitHub.
  • Highly motivated and self-reliant aptitude for learning new technical skills and continuous development.
  • Experience of undertaking team leadership, providing direction and influence to ensure completion of activities within a team-oriented, collaborative environment.
  • Experience of developing and maintaining effective internal and external relationships at senior levels.
  • Ability to prioritise and execute tasks in a dynamic, changing environment and make sound decisions in time critical situations.
  • Ability to demonstrate relentless drive, energy and determination to delivery sustainable performance.
  • Ability to absorb complex technical information and communicate effectively to all levels, both technical and non-technical audiences.
  • Strong organisation and personal management skills.
  • Possess a strong sense of purpose and proactively seek responsibility and ownership.
  • Creativity and lateral thinking.
  • Proven analytical and problem-solving abilities.
  • Ability to understand enterprise solutions.
  • High standards of integrity and ethics with a demonstrable strong customer service ethos.

Desirable

  • Experience of Azure, PaaS, SaaS, DevOps
  • NHS Data and Information standards Agile methodologies.

Skills & behaviours

Essential

  • Abides by the Trust policy on standards of business conduct.
  • Committed to continuous active personal development involving formal training and personal study.
  • A team leader, able to build and maintain an efficient and effective team.
  • Innovative and adaptable to changing priorities.

Desirable

  • Understands implications of health and social care policies for the strategic development and delivery of informatics services.
Person Specification

Qualifications

Essential

  • Degree or equivalent level qualification in a numerate/analytical discipline or equivalent industry experience and some amount of experience ideally in an NHS information management role.
  • Evidence of Continuous Professional Development, i.e. specialist IM&T training/study/research, attendance at relevant conferences/workshops.

Desirable

  • Staff Management, including objective setting, appraisal and PDPs.

Additional Requirements

Essential

  • Identifying and resolving complex data problems.
  • Multi-disciplinary team working.
  • Planning and organisation, prioritisation, strategy formulation and management.
  • Training and mentoring.
  • Analytical and information consultancy.
  • Complex analytical report writing.

Experience

Essential

  • Expert SQL developer skillset in versions 2012-2019, along with a strong background in developing under the Microsoft SQL Server Stack.
  • Excellent Data Preparation knowledge to support Business Intelligence analytics and reporting. Experience in the use of SourceVersion Control systems such as GitHub.
  • Highly motivated and self-reliant aptitude for learning new technical skills and continuous development.
  • Experience of undertaking team leadership, providing direction and influence to ensure completion of activities within a team-oriented, collaborative environment.
  • Experience of developing and maintaining effective internal and external relationships at senior levels.
  • Ability to prioritise and execute tasks in a dynamic, changing environment and make sound decisions in time critical situations.
  • Ability to demonstrate relentless drive, energy and determination to delivery sustainable performance.
  • Ability to absorb complex technical information and communicate effectively to all levels, both technical and non-technical audiences.
  • Strong organisation and personal management skills.
  • Possess a strong sense of purpose and proactively seek responsibility and ownership.
  • Creativity and lateral thinking.
  • Proven analytical and problem-solving abilities.
  • Ability to understand enterprise solutions.
  • High standards of integrity and ethics with a demonstrable strong customer service ethos.

Desirable

  • Experience of Azure, PaaS, SaaS, DevOps
  • NHS Data and Information standards Agile methodologies.

Skills & behaviours

Essential

  • Abides by the Trust policy on standards of business conduct.
  • Committed to continuous active personal development involving formal training and personal study.
  • A team leader, able to build and maintain an efficient and effective team.
  • Innovative and adaptable to changing priorities.

Desirable

  • Understands implications of health and social care policies for the strategic development and delivery of informatics services.

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

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)


Employer contact details

For questions about the job, contact:

Technical Information Manager

Dean Small

dean.small@nhs.net

Details

Date posted

08 May 2025

Pay scheme

Agenda for change

Band

Band 7

Salary

£46,148 to £52,809 a year

Contract

Permanent

Working pattern

Full-time

Reference number

C9298-INF-207

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)