Applications and Data Warehouse Developer

Swansea Bay University Health Board

Information:

This job is now closed

Job summary

Swansea Bay University Health Board is looking to recruit an enthusiastic and driven individual to the post of Application and Data Warehouse Developer. The principal role of the post holder will be to assist in maintain the day-to-day running of the Digital Intelligence data warehouse and the production and distribution of routine reports meaning a good understanding of SQL is essential. Additionally you will be working with senior analysts to assist in the production and maintenance of our Business Intelligence solutions so an understanding of BI tools would be desirable. The position will require a good understanding of analytical and statistical techniques that can be applied to healthcare information.

This post will also support the direction of the infrastructure required in designing, developing and implementing a Digital Services Delivery Solution. The post holder will help to provide users with seamless access to information that will support service improvement and management, as well as continually seek innovative ways of using technology to support working practices and streamline processes within the Department, Directorate and the Health Board.

Main duties of the job

  • Supporting the specification, design and development of the Digital Intelligence Data Warehouse, which aims to automate, streamline and standardise data flows from clinical systems to automate the information production process through the application of available technologies.
  • The development and maintenance of innovative information reporting solutions. This will involve utilising a variety of Business Intelligence technologies, such as PowerBI, QlikView and QlikSense, with SQL Server and Microsoft Office products to support seamless access to a wide range of informatics resources and reports for SBU staff.

  • The ability to speak Welsh is desirable for this post; English and/or Welsh speakers are equally welcome to apply.

About us

The Digital Intelligence Department is made up of3 teams of staff. The teams work closely together, value and respect each other. Communication and excellent work ethics makes the team such a success.

Date posted

19 May 2023

Pay scheme

Agenda for change

Band

Band 5

Salary

£27,461 to £33,428 a year per annum

Contract

Permanent

Working pattern

Full-time

Reference number

130-AC247-0523

Job locations

SBUHB HQ Baglan

Port Talbot

South Wales

SA12 7BR


Job description

Job responsibilities

  • To assist in the provision of comprehensive information for the Health Board, ensuring the highest quality information is available to support current services. This will involve the development and maintenance of innovative information reporting solutions, utilising a variety of Business Intelligence technologies, such as PowerBI, QlikView and QlikSense, with SQL Server and Microsoft Office products to support seamless access to a wide range of informatics resources and reports for SBU staff.
  • Supporting the specification, design and development of the Digital Intelligence Data Warehouse.
  • Maintain the day-to-day running of the Digital Intelligence Data Warehouse and support specification
  • Undertake analysis of trend based data, incorporating many sources of information and aspects including where information may not be readily available. Will exercise own judgement in the assumptions made in the production of this information.

Job description

Job responsibilities

  • To assist in the provision of comprehensive information for the Health Board, ensuring the highest quality information is available to support current services. This will involve the development and maintenance of innovative information reporting solutions, utilising a variety of Business Intelligence technologies, such as PowerBI, QlikView and QlikSense, with SQL Server and Microsoft Office products to support seamless access to a wide range of informatics resources and reports for SBU staff.
  • Supporting the specification, design and development of the Digital Intelligence Data Warehouse.
  • Maintain the day-to-day running of the Digital Intelligence Data Warehouse and support specification
  • Undertake analysis of trend based data, incorporating many sources of information and aspects including where information may not be readily available. Will exercise own judgement in the assumptions made in the production of this information.

Person Specification

Qualifications

Essential

  • Evidence of further development and or education and training
  • Educated to Degree Level or equivalent experience

Knowledge

Essential

  • "Knowledge of information requirements and standards within a healthcare environment"
  • "Advanced IT skills with an advanced knowledge of IT tools/systems such as SQL"
  • "Advanced knowledge and experience of data warehousing, relational databases, information systems and data transfer packages"

Desirable

  • "Advanced IT and analytical skills with experience using Business Intelligence technologies"
  • "A good general understanding of clinical and non-clinical informatics processes"

Experience

Essential

  • oExperience within an information environment
  • oPrevious experience of delivering projects within timescales
  • oIT and analytical skills with a good knowledge of IT tools/systems such as SQL along with Business Intelligence technologies.
Person Specification

Qualifications

Essential

  • Evidence of further development and or education and training
  • Educated to Degree Level or equivalent experience

Knowledge

Essential

  • "Knowledge of information requirements and standards within a healthcare environment"
  • "Advanced IT skills with an advanced knowledge of IT tools/systems such as SQL"
  • "Advanced knowledge and experience of data warehousing, relational databases, information systems and data transfer packages"

Desirable

  • "Advanced IT and analytical skills with experience using Business Intelligence technologies"
  • "A good general understanding of clinical and non-clinical informatics processes"

Experience

Essential

  • oExperience within an information environment
  • oPrevious experience of delivering projects within timescales
  • oIT and analytical skills with a good knowledge of IT tools/systems such as SQL along with Business Intelligence technologies.

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

Swansea Bay University Health Board

Address

SBUHB HQ Baglan

Port Talbot

South Wales

SA12 7BR


Employer's website

https://sbuhb.nhs.wales/ (Opens in a new tab)

Employer details

Employer name

Swansea Bay University Health Board

Address

SBUHB HQ Baglan

Port Talbot

South Wales

SA12 7BR


Employer's website

https://sbuhb.nhs.wales/ (Opens in a new tab)

For questions about the job, contact:

Applications and Data Warehouse Manager

Andrew Jones

Andrew.Jones11@wales.nhs.uk

Date posted

19 May 2023

Pay scheme

Agenda for change

Band

Band 5

Salary

£27,461 to £33,428 a year per annum

Contract

Permanent

Working pattern

Full-time

Reference number

130-AC247-0523

Job locations

SBUHB HQ Baglan

Port Talbot

South Wales

SA12 7BR


Supporting documents

Privacy notice

Swansea Bay University Health Board's privacy notice (opens in a new tab)