AI Summary
We're looking for a Business Intelligence Analyst to embed high-quality, timely reporting at the heart of decision-making across Procurement & Supply Chain.
Key Highlights
Build, maintain and enhance Power BI dashboards and paginated reports
Extract, model and validate data from multiple sources
Use AI-enabled analytics to accelerate analysis
Technical Skills Required
Benefits & Perks
Flexible working and hybrid options
Supportive, collaborative environment
Opportunities to develop technical and leadership skills
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.
- 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.
- 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.
- 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.
- 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.
- 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.
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.