Clinical Support - Data Warehouse Developer

  • Department Digital Services Data Warehouse Team
  • Salary £43,742.00 – £50,056 per annum
  • Closing Date 08/06/2023
  • Location Shrewsbury Business Park
  • Grade NHS AfC: Band 7
  • Job ref 223-DWD-642-A
  • Pension NHS Pension
  • Holidays Generous Holiday Allowance
  • NHS discount Eligible for NHS Discounts
  • Contract Permanent
  • Hours 37.5 hours per week

Job overview

**The banding of this role is subject to confirmation of Agenda for Change job evaluation**

The role of Data Warehouse Developer is to support the delivery of the Digital Service Roadmap supporting the Trusts vision and strategic goals.

It is an exciting time to be joining The Shrewsbury and Telford Hospital NHS Trust (SaTH) to be a part of an exceptional Data Warehouse team. You will be working on a number of developments as part of the Digital Services Roadmap as well as business as usual tasks.

You will need to have strong SQL (SSIS, and T-SQL query building) skills, logical reasoning skills, analytics development skills, and be experienced in optimising data models and queries. You will be required to gather requirements from our customers and design and develop robust and efficient data products for reporting and analytical uses.

We are looking for someone with experience of NHS datasets and someone that works well as part of a team. We work within a framework which we have developed to ensure we produce quality output that is fit for purpose. You will need to work effectively under pressure whilst maintaining quality as we have numerous ah-hoc requests, project work and BAU.

NHS experience and knowledge and experience of SQL are essential.

At present we mainly work remotely with a day or two in the office but this is subject to change.

Main duties of the job

  • Responsibility for the development, implementation and support of automated ETL routines for the extraction and processing of complex data from source database systems and text based data extracts where appropriate. Adapt existing processes to meet new requirements.
  • Data modelling and data solution designs.
  • Collaborate on architecture and design across the team on larger projects.
  • Deliver code changes and releases to production via development and NPE environments.
  • Develop and maintain processes to generate mandated datasets for national and local submission following national guidance or policy.
  • Work with senior managers and other key users to specify and design new data flows and outputs.
  • Identify opportunities for improvements to routine data processes and implement enhancements to deliver efficiencies. Recommend solutions based on own research.
  • Investigate and diagnose technical problems followed by the development and implementation of suitable solutions.
  • Assist with migrating databases to the cloud.
  • Staff management
  • Plan and prioritise own workload.

Working for your organisation

As a member of the Digital Service's Directorate, this role will be critical to improving the organisations understanding of opportunities and risks and in improving the quality of decision-making.

The role will support the delivery of the Trusts vison and strategic goals though the identification of key insights that drive improvements to the effectiveness and efficiency of the services provided. The team will provide the data for central reporting systems to ease the day to day job of staff at all levels. This in turn will help the Trust deliver its integrated care vision.

Detailed job description and main responsibilities

For full duties and responsibilities please refer to the attached document entitled Job Description.

The well-being of our staff is of the upmost importance to us.  If you are offered a role at our Trust, and fall into the increased and higher risk categories as set out by Public Health England (PHE) and NHSI/E, your line manager will complete an risk assessment with you.  This will be completed in conjunction with the latest guidance from Public Health England in relation to Covid-19.

By submitting your application to Trac, you are giving your consent for parts of your application data to be transferred to the NHS Electronic Staff Record (ESR) and other secure, internal NHS Workforce systems. This is to support and manage your recruitment and employment within your employing organisation. 

If successful, by completing the NHS Jobs application form you authorise the Trust to obtain any previous NHS service details including all electronically held sickness information, via the Inter Authority Transfer process on the national ESR.

If the role requires a qualification/professional registration, you will need to provide proof during the recruitment process. By submitting your application you are giving the Trust permission to check the qualification certificates provided back to the source provider. Please note that a sample of all applicant’s qualifications will be checked with the educational institution or provider.

In the event of a high response to this advertisement, this post will be closed. Early applications are advised.
Unfortunately we do not accept CVs or keep them on file. If you are unable to apply online please contact the person named in the advertisement for the post you are interested in.
We are committed to offering an interview to all applicants with a disability who meet the minimum criteria for the above position and will support reasonable adjustments wherever possible.  In addition, whilst all applicants will be judged on merit alone, we particularly welcome applications from candidates who are male, from black and minority ethnic backgrounds or who have a disability, as these are currently under-represented in our workforce.
We are committed to equal opportunities in employment. The policies and practices of the Trust aim to promote an environment that is free from all forms of unlawful or unfair discrimination and values the diversity of all people. At the heart of our policy, we seek to treat people fairly, flexibly and with dignity and respect.

Thank you for your interest in The Shrewsbury and Telford Hospital NHS Trust, we look forward to receiving your application for employment.

Look around a little and browse our jobs...

There are many exciting opportunities available for dedicated and loyal staff at The Shrewsbury and Telford Hospital NHS Trust.

Is it time you made a change?