Job summary
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 (www.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.
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
Qualifications
Essential
- Degree or equivalent occupational/professional qualification or experience
Desirable
- European Computer Driving License (ECDL)
- Microsoft SQL Server Certification
Trust Values
Essential
- 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
Essential
- 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
Desirable
- 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)
Experience
Essential
- 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
Desirable
- 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
Essential
- 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)
Desirable
- 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
Person Specification
Qualifications
Essential
- Degree or equivalent occupational/professional qualification or experience
Desirable
- European Computer Driving License (ECDL)
- Microsoft SQL Server Certification
Trust Values
Essential
- 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
Essential
- 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
Desirable
- 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)
Experience
Essential
- 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
Desirable
- 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
Essential
- 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)
Desirable
- 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
Additional information
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).
