Senior Reporting Analyst

Sussex Partnership Nhs Foundation Trust; Worthing; On-site; GBP 40,000 - 60,000; Full time

Job summary

A healthcare organization in Worthing seeks a skilled individual to join the Performance & Insight Team. In this role, you will develop and maintain Power BI reports to support Trust objectives. The ideal candidate has strong SQL and DAX skills, a flair for data visualisation, and experience within the NHS, enhancing informed decision-making and continuous improvement in mental health services.

Qualifications

• Strong technical skills in SQL and DAX.
• Experience with Power BI for data-informed decisions.
• Confidence in stakeholder engagement and report development.

Responsibilities

• Develop and maintain Power BI reports and dashboards.
• Lead Trust-wide performance reporting.
• Ensure data governance for performance metrics.

Skills

SQL

DAX

Data visualisation

Stakeholder engagement

Team collaboration

Tools

Power BI

Job description

Overview

We have an exciting opportunity to join the Performance & Insight Team on a 12-month fixed-term contract. With the Trust moving to Microsoft Fabric and launching a new Electronic Patient Record system in November, we're rebuilding our entire reporting infrastructure and visualisations using Power BI. This is a rare chance to be part of a high-impact transformation, helping to create a best-in-class reporting environment that drives smart, insight-led decisions and improves care across the organisation.

Responsibilities

• Develop and maintain Power BI reports and dashboards to support Trust objectives using multiple data sources.
• Lead on Trust-wide performance reporting including Board-level and divisional reports.
• Ensure data governance and quality for key performance metrics and data flows, including completeness and compliance.
• Support team development and act as an expert in data presentation and visualisation to ensure clear, impactful reporting.
• Collaborate with internal teams and external partners to ensure accurate, consistent, and strategic reporting.

Qualifications and Experience

• Strong technical skills in SQL and DAX with a creative flair for data visualisation and a focus on user needs.
• Experience with Power BI and building clear, high-quality reports that enable data-informed decisions and deliver real value.
• Confident working with stakeholders, asking the right questions, and challenging constructively.
• Strong team player who can support and coach others in report development.
• Experience working in the NHS and/or mental health services is highly desirable, especially if you understand the reporting challenges and priorities in this setting.

About the Team and Organisation

Working within the Performance and Insights team at Sussex Partnership NHS Foundation Trust offers a unique opportunity to be part of a friendly, multiskilled, and forward-thinking group that plays a vital role in driving the Trust's success. Our team is highly valued across the organisation for delivering high-impact work that supports informed decision-making and continuous improvement. The Trust's core values are Compassion, Accountability, and Optimism. The team is focused on delivering high-quality reporting and analytics to meet stakeholder needs and drive improvement in mental health services.