Senior Reporting Analyst
Job summary
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 description
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.
Certificate of Sponsorship
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website.
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants.
Employer details
Employer name
Sussex Partnership NHS Foundation Trust
Address
Portland House
44 Richmond Road
Worthing
BN11 1HS
Employer's website
https://www.sussexpartnership.nhs.uk/
- Company
- Sussex Partnership NHS Foundation Trust
- Location
- Worthing, United Kingdom BN11 1HS
- Employment Type
- Fixed-Term
- Salary
- £47810.00 - £54710.00 a year
- Posted
- Company
- Sussex Partnership NHS Foundation Trust
- Location
- Worthing, United Kingdom BN11 1HS
- Employment Type
- Fixed-Term
- Salary
- £47810.00 - £54710.00 a year
- Posted