NHS Ayrshire & Arran
Business Intelligence Solution Developer
NHS Ayrshire & Arran, House, New Mexico, United States, 88121
Business Intelligence Solution Developer
The Team
The team is an integrated Business Intelligence- and Data Warehouse team within the eHealth Department that serves the entire organisation with solutions related to reporting and analytical applications. Our core areas are performance reporting and dashboards and statutory reporting to the Scottish Government. Our data warehouse is based on Microsoft SQL Server and tools from Insource. For the Business Intelligence delivery, we are using Analysis Services, Reporting Services and Power BI from Microsoft. We are in the process of implementing Microsoft Fabric.
Your Role
Design and develop solutions that support the reporting and analytics needs of the organisation.
Work within the wider EPR Programme, including a new Radiology Information System, order communications and discharge.
Re‑think and automate analytical tasks for analysts in other departments in NHS Highland.
Provide training, mentoring and expert support in DAX, data modelling and processing for analysts building Power BI models.
Participate in the ongoing development and operation of the data warehouse.
Build extensive knowledge of the data warehouse, operational health care systems and business processes.
About You
Experience and skills with T‑SQL, SSRS, Power BI, DAX, M (Power Query).
Proficient with data warehouse methodologies and concepts, relational and multi‑dimensional data modelling.
Experience with Microsoft Fabric is valuable.
Adequate knowledge of data‑warehouse strategy and its integration across reporting and dashboard solutions.
Experience with data challenges in unscheduled and elective care, as well as primary care.
Ability to discuss complex information requirements with senior non‑technical counterparts, articulate data‑related challenges and opportunities, and convert them into visually efficient and appealing solutions while adhering to a stable architecture.
Data‑related experience from the health care sector.
Informal enquiries should be made to Klas Laveno, Business Intelligence and Data Warehouse Manager; tel: 01463 705701; email: klas.laveno2@nhs.scot. Please quote reference
Post431
in the subject line of your email.
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 all sections of society.
Seniority Level
Entry level
Employment Type
Full‑time
Job Function
Information Technology
Industries
Hospitals and Health Care
#J-18808-Ljbffr
Your Role
Design and develop solutions that support the reporting and analytics needs of the organisation.
Work within the wider EPR Programme, including a new Radiology Information System, order communications and discharge.
Re‑think and automate analytical tasks for analysts in other departments in NHS Highland.
Provide training, mentoring and expert support in DAX, data modelling and processing for analysts building Power BI models.
Participate in the ongoing development and operation of the data warehouse.
Build extensive knowledge of the data warehouse, operational health care systems and business processes.
About You
Experience and skills with T‑SQL, SSRS, Power BI, DAX, M (Power Query).
Proficient with data warehouse methodologies and concepts, relational and multi‑dimensional data modelling.
Experience with Microsoft Fabric is valuable.
Adequate knowledge of data‑warehouse strategy and its integration across reporting and dashboard solutions.
Experience with data challenges in unscheduled and elective care, as well as primary care.
Ability to discuss complex information requirements with senior non‑technical counterparts, articulate data‑related challenges and opportunities, and convert them into visually efficient and appealing solutions while adhering to a stable architecture.
Data‑related experience from the health care sector.
Informal enquiries should be made to Klas Laveno, Business Intelligence and Data Warehouse Manager; tel: 01463 705701; email: klas.laveno2@nhs.scot. Please quote reference
Post431
in the subject line of your email.
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 all sections of society.
Seniority Level
Entry level
Employment Type
Full‑time
Job Function
Information Technology
Industries
Hospitals and Health Care
#J-18808-Ljbffr