Business Intelligence Analyst

Nhsscotland; Inverness; Hybrid; GBP 30,000 - 45,000; Full time

Job summary

A public health organization in the UK is seeking a Business Intelligence Analyst to enhance decision-making through data-driven insights. This role involves building and optimizing Power BI dashboards, managing data from various sources, and collaborating with teams to standardize reporting and improve data quality. Ideal candidates should have a degree or equivalent experience, proven Power BI development skills, and strong SQL knowledge. Join us in supporting operational efficiency and improving service delivery across the organization.

Benefits

Flexible working options

Development opportunities

Qualifications

• Degree-level qualification or significant experience in complex analysis and data reporting.
• Proven experience building Power BI solutions.
• Practical SQL skills for data extraction and analysis.

Responsibilities

• Build and enhance Power BI dashboards for decision making.
• Extract and validate data from multiple sources.
• Collaborate with teams to improve data quality.

Skills

Data modelling with Power Query/M and DAX

Proficient SQL skills

Power BI solutions development

Attention to detail

Confident communication

Education

Degree-level qualification or significant experience in analysis

Tools

Power BI

SQL Server

Excel

Job description

Are you a data‑driven problem solver who can turn complex information into clear insight and action?

We’re looking for a Business Intelligence Analyst to embed high‑quality, timely reporting at the heart of decision‑making across Procurement & Supply Chain—supporting operational efficiency, cost reduction, and improved service delivery for NHS Highland.

About The Role

• Build, maintain and enhance Power BI dashboards and paginated reports (Report Builder/SSRS) that provide trusted, actionable insight for operational and strategic decisions.
• Extract, model and validate data from multiple sources (e.g. SQL Server / data warehouse), ensuring accuracy, lineage and refresh reliability.
• Use AI‑enabled analytics (e.g. Power BI Copilot, AI visuals, natural‑language query, anomaly detection, forecasting) to accelerate analysis, clearly documenting assumptions and outputs.
• Respond to routine and ad hoc reporting needs, meeting statutory and organisational deadlines; contribute to programme reporting (savings tracker, KPIs, risk dashboards).
• Collaborate across Finance & Commercial, eHealth and service teams to standardise reporting, strengthen data literacy and improve data quality.

What You’ll Bring (Essential)

• Degree‑level qualification or significant experience in complex analysis and data reporting.
• Proven experience building Power BI solutions:
  • Data modelling with Power Query/M and DAX (measures, calculated columns, role‑based security).
  • Visual design standards, accessible reporting (colour/contrast), and performance optimisation (model size, relationships, query folding).
  • Publishing and governance in Power BI Service (workspaces, datasets, lineage, scheduled refresh, permissions).
• Practical SQL skills (queries, views, stored procedures) and proficiency with Excel for analysis and data validation.
• Experience applying AI features responsibly to support insight generation (e.g. Copilot prompts for narrative summaries, AI visuals for key influencers/anomalies), with clear audit trails and human oversight.
• Strong attention to detail; ability to prioritise and deliver at pace to fixed deadlines; confident communicator to non‑specialists.

Information Governance & Safety (Essential)

• Understanding of UK GDPR, FOI, Caldicott Principles, and NHS Highland policies—ensuring secure handling of data, appropriate access controls (RLS), and safe use of AI features (no disclosure of confidential or patient‑identifiable data in prompts or outputs).
• Commitment to bias‑aware, explainable analytics; documenting sources, transformations and limitations.

Desirable

• Experience with Power BI Admin/Tenant governance (workspaces, capacity, gateways), Power Automate for refresh/notification flows, and Power BI Report Server.
• Familiarity with Python/R in Power BI, or other ML tooling (e.g. classification/forecasting) for operational analytics.
• SSIS/ADF or similar ETL; exposure to enterprise semantic models; API data ingestion.
• Experience rolling out reporting standards/style guides and data quality improvement initiatives.

Why join us

• Play a key role in modernising and standardising reporting, bringing Power BI and responsible AI into everyday decision‑making.
• Support measurable efficiencies and better visibility of performance and risks.
• Work in a supportive, collaborative environment with opportunities to develop both technical and leadership skills.
• Flexible working and hybrid options, subject to service needs.

Additional Information

• Sponsorship: As a full‑time Band 5 post, this role may be eligible for Skilled Worker visa sponsorship (subject to NHSH policies and national guidance).
• Pre‑employment checks: Standard NHS recruitment and onboarding requirements apply.

For more information please contact Kathleen Lohse, Head of Service Development (Finance & Commercial) at [e-mail]

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