Senior Reporting Analyst

NHS; Worthing; On-site; GBP 35,000 - 45,000; Full time

Job summary

A healthcare organization in Worthing, England, is seeking a data analyst to assist in rebuilding reporting infrastructure using Power BI. Candidates should have strong technical skills in SQL and DAX, with experience in the NHS preferred. The role involves leading performance reporting and ensuring data quality while working in a collaborative environment to drive data-informed decisions.

Qualifications

• Extensive experience using analytical techniques to derive insights.
• Strong understanding of large datasets and data sources.
• Significant experience designing and publishing reports in Power BI.

Responsibilities

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

Skills

SQL

DAX

Data Visualisation

Stakeholder Engagement

Team Collaboration

Education

Degree in Mathematics, Economics, Statistics or related field

Information Management Qualification

Tools

Power BI

Microsoft Excel

SQL

R

Python

Job description

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.

We're looking for someone who combines strong technical skills in SQL and DAX with a creative flair for data visualisation and a focus on user needs. You'll be confident working with stakeholders, asking the right questions, and challenging constructively. You'll also be a strong team player, supporting and coaching others in report development.

You'll need a proven track record of building clear, high-quality reports that enable data-informed decisions and deliver real value.

Experience working in the NHS and/or mental health services is highly desirable, especially if you understand the specific reporting challenges and priorities in this setting.

If you're passionate about using data to drive improvement, and excited by the opportunity to shape reporting from the ground up, we'd love to hear from you.

Main duties of the job

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.

About us

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.

At the heart of everything we do are the Trust's core values of Compassion, Accountability, and Optimism. We approach our work with compassion, understanding the real-world impact of the data and insights we provide. We take accountability for the quality and accuracy of our reporting and analytics, ensuring they consistently meet the needs of our stakeholders. And we maintain optimism, even in the face of challenges, constantly seeking new ways to innovate and improve.

If you join our team, you will be working alongside visionary colleagues who are passionate about making a difference, equipped with a diverse range of skills that complement each other to deliver outstanding results. Together, we support the Trust's mission to provide excellent mental health services, contributing to better outcomes for the people we serve.

Job responsibilities

Please refer to the Job Description for comprehensive details of the roles key duties and requirements.

Person Specification

Qualifications

• Educated to Degree level in a relevant subject (such as Mathematics, Economics, Statistics or a related quantitative or analytical discipline) or equivalent level of qualification or significant equivalent previous proven experience in analytics.
• Information Management Qualification or other relevant qualification e.g. BCS

KNOWLEDGE/EXPERIENCE

• Extensive experience of using a range of analytical techniques to derive insight and inform improvement work
• Demonstrate an understanding of large datasets and data sources including the quality and reliability of the data
• Experience of triangulating data from different sources and demonstrate an appreciation of the differences that might occur in large datasets
• Significant experience of designing, developing and publishing reports and dashboards across a broad range of areas using PowerBI
• Thorough understanding of NHS data definitions, reporting requirements, sources and information flows
• Experience of using process mapping techniques
• Expert use of relevant analysis software (Microsoft Excel - essential; PowerBI - Desirable; "R" / Python - Desirable)
• Significant experience of extracting and processing data from multiple source systems using SQL
• In depth knowledge of the principles of data management and quality assurance
• Experience of developing clear and engaging reports and dashboards

Disclosure and Barring Service Check

This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.

Associate Director for Performance and Insight