Permanent However Fixed Term Or Secondment Considered

An exciting opportunity has arisen to be part of the Business Intelligence (BI) team based in National Headquarters.

The BI team is responsible for all routine and ad-hoc performance reporting. This includes production of daily, weekly, monthly and quarterly reports covering all aspects of performance such as operational, clinical, PTS and sickness absence. These routine reports are produced for SAS Executive, Board, Senior Managers and the Scottish Government. Provision of this analysis applies to the whole system, from 999 calls to outcomes linked with other areas of healthcare.

We are looking for a highly creative Data Warehouse Developer to join the team who will be responsible for the ongoing development and maintenance of the Data Warehouse, which includes the design, build and maintenance of SQL Server databases, Business Objects Data Services (BODS) ETL processes and the creation and update of Business Objects reporting universes.

This is a highly specialist and technical role and the post holder will be required to undertake complex and detailed technical design for bringing each source system into the Data Warehouse and must be proficient in writing SQL queries, procedures and functions, along with design and development in a Data Warehouse environment. The Data Warehouse is built in Business Objects therefore experience of Business Object Universe Designer, Report Building, Administration, Migration and Security is essential.

The postholder will be expected to fully engage with users in the development of the Data Warehouse and to establish user requirements through analysis of business processes ensuring relevant source system data is fully maximised for reporting and analysis.

This is a varied role and the postholder will need to be flexible and able to cope with periods of pressure and competing demands. Consistent attention to detail and good organisational skills are essential. A willingness to support colleagues in the team and be flexible to meet ever changing demands from within the Service and externally is essential.

Experience or knowledge of using the following software would be desirable:

• SQL Server

• MySQL

• Business Objects Data Services

• Business Objects Web Intelligence

• Visual Studio

• C#

• R

• PHP

• HTML

• Data Visualisation tools such as Power BI

Although this post is based within NHQ, the location is flexible and will be discussed and agreed with the successful candidate. This could include home working, office working, or hybrid.

If you wish to discuss the post further, please contact Alan Brown on

NHS Scotland is committed to encouraging equality and diversity among our workforce and eliminating unlawful discrimination. The aim is for our workforce to be truly representative and for each employee to feel respected and able to give their best. To this end, NHS Scotland welcomes applications from ll sections of society.