BI & Reporting Analyst

IT Works Health LTD; Preston; On-site; GBP 42,000 - 65,000; Full time

Job summary

IT Works Health LTD is seeking a BI & Reporting Analyst to design and deliver high-quality reporting solutions using Power BI and Microsoft data technologies. You will work with Data Engineers and Data Architects to create trusted insights for clinical, operational, commercial and executive teams.

You will champion self-service analytics, establish a single source of truth, and drive adoption through training and governance to help stakeholders access decision-ready information that improves

Qualifications

• Proficient in Power BI report and dashboard design with strong DAX knowledge.
• Solid SQL skills for data exploration, validation and analysis.
• Experience with semantic/tabular data models and star schema design.

Responsibilities

• Design, build and maintain Power BI dashboards and reports.
• Gather requirements from stakeholders and translate into technical solutions.
• Maintain governance and a single source of truth for reporting across teams.

Skills

Power BI

SQL

DAX

Semantic models

Tabular models

Star schema

PL-300 certification

Stakeholder engagement

Data storytelling

Tools

Power BI

Job description

As our BI & Reporting Analyst, you'll sit within the Data Team and be responsible for designing and delivering high-quality reporting solutions using Power BI and modern Microsoft data technologies. Working alongside Data Engineers and Data Architects, you'll help create a trusted reporting environment that enables stakeholders across clinical, operational, commercial and executive teams to access reliable, decision-ready insights. You'll champion self-service analytics, and help establish a single source of truth across the organisation.

Main duties of the job

What You'll Be Doing Design, build and maintain engaging Power BI dashboards, reports and visualisations. Gather reporting requirements from stakeholders and translate business needs into effective technical solutions. Develop and maintain semantic models and support a consistent, governed reporting environment. Analyse complex datasets to identify trends, opportunities and actionable insights. Work closely with business teams to improve reporting consistency and data literacy. Monitor and optimise Power BI performance, refresh processes and report usability. Support data quality initiatives and ensure robust reporting standards are maintained. Contribute to NHS statutory reporting processes and help provide resilience within the wider data team. Drive adoption of self-service analytics through training, guidance and stakeholder engagement.

Job responsibilities

What We're Looking For Essential Skills & Experience Microsoft Power BI expertise, including report development, dashboard design and DAX. PL-300 certification (or equivalent Microsoft Power BI certification). Strong understanding of semantic models, tabular models and dimensional modelling (star schema). Solid SQL skills for data exploration, validation and analysis. Experience delivering reporting solutions for operational, commercial and executive audiences. Strong communication skills with the ability to engage technical and non-technical stakeholders. A proactive approach to problem-solving and continuous improvement. Experience integrating data from multiple business systems into a consistent reporting environment You'll be someone who: Loves turning data into meaningful stories and insight. Enjoys collaborating with a wide range of stakeholders. Takes pride in delivering high-quality work. Is naturally curious and always looking for ways to improve processes. Thrives in a fast-paced environment where your work directly impacts business and patient outcomes.

Additional Criteria

• Strong understanding of semantic models, tabular models and dimensional modelling (star schema).
• Solid SQL skills for data exploration, validation and analysis.
• Experience delivering reporting solutions for operational, commercial and executive audiences.
• Strong communication skills with the ability to engage technical and non-technical stakeholders.
• A proactive approach to problem-solving and continuous improvement.
• Experience integrating data from multiple business systems into a consistent reporting environment