This Business Analysis and Reporting team at Essex Partnership University NHS Foundation Trust is being reshaped around new tools, including Power BI, for its reporting. The six-month fixed-term post centres on extracting data from several Trust systems, writing queries and code, and producing performance reports and dashboards for operational and corporate teams. It also involves coordinating improvement projects against national and contractual standards and supervising performance assistants, with flexible working and travel across the Trust. The interview includes an Excel assessment, and previous applicants should not apply.
What the job involves
- Extract data from multiple Trust systems and analyse data requirements
- Develop and test queries and code to produce complex analysis
- Produce and maintain regular performance reports, flagging risk and recommending improvements
- Coordinate quality and performance reporting to Trust commissioners and the Trust-wide Quality and Performance Report
- Design and maintain performance dashboards and reporting processes
- Present complex and sensitive performance findings and explain targets to staff
- Support operational managers and clinicians to meet national, CQC and commissioner targets
- Coordinate performance improvement projects, setting measures, milestones and timescales
- Lead development of health-related data sets, aligned with national and local policy
- Supervise and coach Performance and Information Assistants, including covering for team members
- Monitor improvements, report progress to stakeholders and resolve data quality issues
- Develop policies and procedures, contribute to new information systems and liaise with external agencies
What’s required
Qualifications
- Postgraduate-level education or equivalent relevant NHS experience
- Evidence of CPD to postgraduate diploma level or equivalent
Experience
- Demonstrable experience working in this field
- Experience working independently in a role that required it
Nice to have
- Intermediate level Microsoft Excel
- Experience using SQL
- Experience using Power BI
What’s offered
- 27 days holiday plus bank holidays, rising to 33 days after 10 years' service
- Pension of up to 14.5% of pensionable pay
- Staff discounts including Blue Light Card and NHS offers
- £8K relocation package if moving to Essex
- Interest-free season ticket loans for travel by tram, rail or bus
- Flexible working available from day one for most roles
- Job share applications welcomed
- Mental health and wellbeing services, occupational health advice and counselling