Business Intelligence Solution Developer

NHS National Services Scotland; Inverness; On-site; GBP 40,000 - 60,000; Full time

Job summary

A major healthcare provider in Scotland is seeking a BI solution developer to design and develop solutions supporting reporting and analytics needs. Candidates should have experience in the healthcare sector and be proficient with tools like Power BI, T-SQL, and DAX. The role involves mentoring analysts and addressing data challenges across various care settings.

Benefits

Comprehensive health benefits

Equal opportunity workplace

Qualifications

• Ability to discuss complex information requirements with non-technical counterparts.
• Experience in converting requirements into visually efficient solutions.
• Proficient in data-related challenges and overall data architecture.

Responsibilities

• Design and develop solutions to support reporting and analytics.
• Support analysis and statutory reporting in unscheduled and elective care.
• Train and mentor analysts in DAX, Data modeling and Power BI.

Skills

T-SQL

SSRS

Power BI

DAX

M (Power Query)

Data warehouse methodologies

Education

Experience in health care sector

Tools

Microsoft Fabric

Job description

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

As a BI solution developer, you are covering the whole spectrum from business requirements to data- and solution architecture and development. You may also be involved in the ongoing development and operation of our data warehouse. You will build up an extensive knowledge of the data warehouse as well as the operational health care systems and business processes.

From the start we expect that you will be designing and developing solutions that support the reporting and analytics need of the organisation. This can be within the wider EPR Programme (Electronic Patient Record) including a new Radiology Information System, order communications and discharge. You may also be involved in re-thinking and automating analytical tasks for analysts in other departments in NHS Highland. This also involves training, mentoring and expert support in DAX, Data modelling- and processing for analysts across the organisation that are building models in Power BI.

About You

You can discuss complex information requirements with senior non-technical counterparts, and you are able to articulate the data-related challenges and opportunities and come up with constructive solutions. You are also able to question and re-frame requirements as well as converting them into a solution that is visually efficient and appealing but also adheres to a solution architecture that is stable and efficient from a maintenance perspective. It is essential that you can cover the entire spectrum from requirements to development.

As a developer you possess demonstrable experiences and skills with most of the tools that we are using. You can work with the full stack of tools including T-SQL and SSRS and Power BI, DAX and M (Power Query). You are proficient with data warehouse methodologies and concepts as well as relational and multi-dimensional data modelling. Any experience in Microsoft Fabric is also valuable as this will be helpful in our modernisation and transition to the new tools.

You appreciate the advantages of having a data warehouse strategy that provides the foundation for unified use of data across a variety of reporting and dashboard solutions.

Since you will be supporting analysis and statutory reporting in unscheduled and elective care as well as primary care, experience with the data challenges in these areas is important.

It is important that that you have data related experience from the health care sector.

Informal enquiries

Informal enquiries should be made to Klas Laveno, Business Intelligence and Data Warehouse Manager; tel: [phone]; email: [e-mail].

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.

ADDITIONAL INFORMATION FOR CANDIDATES

• You should apply for this post by completing the application process on Jobtrain.
• DO NOT upload a CV as this will not be used for short listing purposes
• Posts close at midnight on the indicated date
• For help to complete an application on Job Train please follow this link: https://www.careers.nhs.scot/how-to-apply/application-process/
• To view our accessibility statement, please follow this link: https://www.eess.nhs.scot/jobtrain-accessibility-statement/
• Please note that our correspondence method is by e-mail, therefore please ensure you enter your email address accurately
• Please check your e-mail regularly (including junk folders) and also your Jobtrain account for updates
• Please contact Jobtrain Candidate Support Hub - https://jobseekersupport.jobtrain.co.uk/support/home for advice and support with any system issues
• We recommend using the Internet Browser "Google Chrome" or "Microsoft Edge" when using Jobtrain
• Once you have submitted your application form you will be unable to make any amendments
• Some of our vacancies are for internal candidates only. If you are a member of staff, please ensure you update your Jobtrain profile to reflect that you are employed by NHS Highland

NHS Highland is geographically the largest of the 14 regional boards of NHS Scotland, covering an area of 12,500 square miles, across Highland and Argyll & Bute.

We employ over 10,700 people, making us one of the biggest employers in the area. As an organisation, we make a very significant contribution to the local economy.

Our staff are also important members of our communities. Our greatest asset is our workforce, and the way we go about our work comes from the values and behaviours we demonstrate on a daily basis. As a board we strive to ensure the environment is conducive to nurturing a positive culture, supported and delivered through our NHS and social care values.

• Care and compassion
• Dignity and respect
• Openness, honesty and responsibility
• Quality and teamwork