Skip to main content

This job has expired

2642 - Data Warehouse Developer

Barnsley Hospital NHS Foundation Trust
£35,392 to £42,618 a year
Closing date
29 May 2024

View more

Other Health Profession
Band 6
Contract Type
Full Time
Interview Date: W/C 3rd June 2024

An exciting opportunity has arisen for 1 Data Warehouse Developer to work within the Business Intelligence Department at Barnsley Hospital NHS Foundation Trust.

The Business Intelligence team aims to deliver responsive, high quality information by actively engaging with the local health community and soliciting its current and changing requirements in support of the Trusts Vision and Strategy in order to:

meet users expectations and needs for high quality services in informatics,

deliver those services effectively, efficiently and responsively,

develop and enhance close partnerships with the Trusts divisions and other local health communities so as to encourage the best working practices,

plan ahead co-operatively to keep pace with changing needs, providing leadership for innovation.

Main duties of the job

The post holder will support the provision of management information to users across the Trust, by ensuring that specialist or complex IM& T information is processed in accordance with policies and procedures. Investigate specialist or complex IM& T issues, this will include assisting in the development and maintenance of the MS SQL server data warehouse reporting and back-end functionality (using tools in the Microsoft SQL server BI Stack such as SSIS, SSRS, T-SQL) as well as working with data feeder systems to ensure timely trust wide access to the required Business Intelligence.

The postholder will utilise ETL Data skills (Extract Transform and load) using SSIS SQL Server integration services to import and load data into the Data Warehouse. T-SQL scripting using Management Studio including Views, stored procedures and functions will be used extensively and form the basis of producing reports within the data warehouse.

The postholder will support the senior data warehouse developer in providing specialist advice to IM& T and non-IM& T users, developing and/or adapting complex code/reports and delivering specialist training for users.

The postholder will provide input to projects and work as part of a multi-disciplinary team providing business intelligence on a range of NHS Performance and Commissioning targets.

About us

Please note that the Trust reserves the right to close a position early.

Barnsley Hospital NHS Foundation Trust is a high performing Trust achieving a Good rating in our most recent Care Quality Commission (CQC) assessment and achieving significant progress in the delivery of our strategic objectives. We are proud of the commitment of our staff to ensuring a strong and sustainable future for this organisation which is highly valued by our local communities.

There has never been a better time to join Barnsley Hospital. It is moving at pace and a we can do this attitude is evident right through the organisation, where staff are engaged for change and committed to being part of the journey to sustainability and growth.

Barnsley Hospital NHS Foundation Trust is committed to promoting equality of opportunity and fair treatment to all applicants regardless of race, nationality, ethnic origin, gender, marital status, mental or physical disability, religion or belief, sexual orientation, age or offending history.

The cost of the DBS (criminal records check) for Band 6 and above roles only will be met by the successful candidate(s) through salary deduction.

Certificates of Sponsorship

For individuals who may require sponsorship under the skilled worker or health & care visa route please use the link below to check your eligibility Check if you need a UK visa - GOV.UK (, band 2 and 3 roles are no longer eligible for sponsorship.

Job description

Job responsibilities

Job Description for Data Warehouse Developer

Please refer to the attached Job Description and Person Specification for full details of the role and responsibilities.

Supporting Documents

Please refer to the values-based recruitment guidance and associated documentation.

Person Specification



  • Degree or equivalent occupational/professional qualification or experience


  • European Computer Driving License (ECDL)
  • Microsoft SQL Server Certification

Trust Values


  • In around 100 words please describe what Equality & Diversity means to you and why they are important.
  • In around 100 words please describe what motivates you to do a good job.

Knowledge and Awareness


  • Specialised knowledge of T-SQL scripting using management studio including views/stored procedures, cursors and functions
  • SSRS SQL (Server Reporting Services) running from T-SQL stored procedures
  • National Tariff
  • NHS performance indicators
  • NHS Information Governance
  • Data Protection Act 1998 and
  • Caldicott Principles
  • NHS Data Definitions, Datasets and Statistical Returns


  • Information for Commissioning
  • NHS Performance Indicators
  • Data Accreditation/Information Quality Assurance
  • Sources of comparative/benchmarking information
  • Clinical Coding and HRGs
  • SSAS (SQL server analysis services)



  • Specialised knowledge of ETL Data skills (Extract Transform and Load) using SSIS SQL Server Integration Services to import and load data.
  • Expert user of MS Excel and Access (or similar) for statistical reporting
  • Ability to generate reports using the SSRS platform
  • Significant experience of data mining/NHS analytical experience in an acute or community setting


  • Application/knowledge of a range of statistical techniques and modeling methods
  • Working with hospital information systems
  • Use of Trust Integration Engines (TIE) e.g. Ensemble

Skills and Abilities


  • Excellent analytical and logical approach to problem solving
  • Interpretation and meaningful presentation of information
  • Writing reports and policies
  • Presentation using MS PowerPoint or similar software
  • Database application development and reporting tools (e.g. MS Access, SQL Server Management Suite)


  • Project Management
  • Use of InfoPath to develop user electronic forms
  • Proficient in content management on SharePoint sites
  • Use of PowerBI to generate mobile report solutions
  • Ability to use VBA, .NET programming languages

Employer details

Employer name

Barnsley Hospital NHS Foundation Trust


Floor 9

Gateway Plaza


South Yorkshire

S70 2RD

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