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.
Details
Date posted
18 September 2025
Pay scheme
Agenda for change
Band
Band 7
Salary
47,810 to 54,710 a year per annum
Contract
Fixed term
Duration
12 months
Working pattern
Full-time
Reference number
354-CO-21719
Job locations
Portland House
44 Richmond Road
Worthing
BN11 1HS
Job description
Job responsibilities
Please refer to the for comprehensive details of the roles key duties and requirements. Job description
Job responsibilities
Please refer to the for comprehensive details of the roles key duties and requirements.
Person Specification
Qualifications
Essential

• 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.

Desirable

• Information Management Qualification or other relevant qualification e.g. BCS

KNOWLEDGE/EXPERIENCE
Essential

• 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

Person Specification
Qualifications
Essential

• 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.

Desirable

• Information Management Qualification or other relevant qualification e.g. BCS

KNOWLEDGE/EXPERIENCE
Essential

• 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

Skills Required