This job has expired

SQL Data Warehouse Senior Develope

Barts Health NHS Trust
£51,488 to £57,802 a year per annum inc
Closing date
4 Jun 2023

View more

Other Health Profession
Band 7
Contract Type
Full Time
The Clinical Systems - Data Warehouse Applications Team is seeking to recruit to this position within the existing Data Warehouse Applications Team. The successful candidate will work within a dynamic team which supports the Trust's corporate data warehouse system helping drive the Trusts reporting and operational needs.

The Clinical Systems Department has completed a large programme of technical changes which is driving further system adoption. To support this system adoption you will lead a group of Developers to deliver new datasets as well as working on developments to enhance the Barts Health Data Warehouse.

Main duties of the job

Working with NHS datasets and data models, you will be comfortable holding discussions with end users on requirements gathering and translating these into technical requirements for the Developers. You will also be comfortable with NHS PbR and commissioning and provide development and business as usual support for financial business rules and services to meet monthly reporting cycles.

You will support planning and management of your resources to deliver solutions to meet reporting national & business needs within agreed timeframes and budget.

You will be responsible for managing daily business as usual support demands to ensure smooth running of systems and includes monitoring of the data warehouse services and processes.

About us

Barts Health is one of the largest NHS trusts in the country, and one of Britain's leading healthcare providers.

The Barts Health group of NHS hospitals is entering an exciting new era on our improvement journey to becoming an outstanding organisation with a world-class clinical reputation. Having lifted ourselves out of special measures, we now have the impetus and breathing space to chart a fresh course in which we are continually striving to improve all our services for patients.

Our vision is to be a high-performing group of NHS hospitals, renowned for excellence and innovation, and providing safe and compassionate care to our patients in east London and beyond. That means being a provider of excellent patient safety, known for delivering consistently high standards of harm-free care and always caring for patients in the right place at the right time. It also means being an outstanding place to work, in which our WeCare values and behaviours are visible to all and guide us in how we work together.

We strive to live by our WeCare values and are committed to promoting inclusion, where every staff member has a sense of belonging. We value our differences and fully advocate, cultivate and support an inclusive working environment.

Job description

Job responsibilities

More detailed information on the responsibilities of the role can be found on the job description below and attached.

Person Specification



  • Extensive experience in developing, implementing and supporting successful applications in multi-user systems, including the use of at least one of the programming languages used within the data warehouse applications team.
  • Experience in programming languages, SQL Server and SSIS.
  • Experience in specializing in developing ETL processes within a large data warehouse and associated interfaces
  • Experience of design and development and implementation of at least one significant implementation.
  • The ability to understand complex and often ill-defined problems, and to resolve them quickly by clear logical analysis and imaginative, efficient solutions.
  • NHS Datasets and Data Models
  • Leading/managing staff / team


  • NHS PbR & Commissioning Knowledge



  • Computer literate -- Word / Excel
  • High level of interpersonal and organisational skills -- self starter
  • Effective team player
  • Able to prioritise and work under pressure to meet deadlines
  • Flexible approach
  • Project Management and Business Analysis
  • Able to analyse, interpret and report audience appropriate information
  • Ability to lead in the production of tested and documented programs, database schema, and program test-schedules.



  • The ability to a lead a group of developers effectively.
  • The ability to learn quickly in a complex and technically demanding environment, obtaining relevant information from manuals etc., when needed.
  • An aptitude for systems analysis and design the ability to communicate with all levels of hospital staff, to determine how computing can best assist them.
  • The ability to write accurate and clear specifications, reports, program documentation etc.
  • Trained in the full range of IT disciplines including system analysis, system design, programming, testing and implementation, gained over extensive experience in an IT development environment.
  • Specialist knowledge of a number of technical areas such as business analysis, relational databases, and specialist programming.
  • Wide knowledge and understanding of the more technical and complex issues relevant to applications programming, with the ability to design and produce programs of considerable size and complexity.
  • NHS Datasets and Data Models



  • Educated to Degree level study or Equivalent


  • Evidence of continuous development
  • Professional lT qualification Eg: Microsoft Certified Professional
  • lTlL Foundation Certificate



  • Learn and become competent with the use of PI-EDW datasets
  • Identify own development needs to meet objectives to meet department deliverables.
  • Ability to work effectively within in a small development team and sharing knowledge, skills and experience with team members
  • Excellent written and verbal communication skills.
  • Sufficient to perform the duties of the post with any aids and adaptations

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) .

UK Registration

Applicants must have current UK professional registration. For further information please see NHS Careers website (opens in a new window).

Employer details

Employer name

Barts Health NHS Trust


Mile End Hospital

Burdett House, Bancroft Road,


E1 4DG

Any attachments will be accessible after you click to apply.


Get job alerts

Create a job alert and receive personalised job recommendations straight to your inbox.

Create alert