Job summary This role is part of the Business Analysis and Reporting team, which is undergoing transformation to integrate new technologies, including Microsoft Power BI, into its reporting and analysis processes. The post-holder will work flexibly to support the Trust's operational and corporate teams, providing complex data analysis and performance reports to aid decision-making and business planning. Key responsibilities include developing and delivering specialist reports, coordinating performance improvement projects, and advising services on meeting national and contractual standards. The role also involves ensuring data accuracy, presenting findings to senior management, and supporting the development of the Trust's business intelligence systems. Frequent travel across the Trust may be required for meetings and operational support. Main duties of the job Analyse data requirements, and extract data from multiple Trust systems. Develop and test queries, and provide clear, concise reports on performance indicators. Produce and maintain regular reports on Trust performance, identifying areas of risk and recommending improvements. Support performance improvement projects, coordinating actions to meet national and contractual standards. Design and maintain performance dashboards and reporting processes to support decision-making across the Trust. Interpret complex performance data, present findings, and communicate performance targets to staff. Support operational managers and clinicians with accurate, timely information to meet performance targets, including CQC and Commissioner targets. Lead on the development of health-related data sets and ensure reporting processes align with national/local policies. Supervise and coach Performance and Information Assistants, ensuring training and progress against objectives. Monitor and track performance improvements, reporting progress to stakeholders, and resolve any data quality issues. Develop policies and procedures to support performance improvement and compliance. Liaise with external agencies and maintain confidentiality in all interactions. Contribute to the introduction of new information systems and ensure appropriate reporting standards are in place. Manage, develop, and maintain performance reporting systems, providing cover for team members as needed About us EPUT are looking for motivated staff who shares our Trust values of Care, Learn and Empower. In return, EPUT can offer you a range of benefits and development including; Season Ticket Loans NHS discounts for staff Excellent Training facilities and opportunities Buying and Selling annual leave scheme The opportunity to work bank shifts and expand knowledge and experience in other areas Salary Sacrifice schemes including lease cars and Cycle to Work Day One Flexible Employer The Trust supports and actively encourages flexible working for all employees. We offer many options and you are encouraged to ask the recruiting manager what is possible for this role. If appointed, you will have the opportunity to apply for a flexible working request from the first day of your employment Join our Staff bank What is Staff Bank? Our EPUT NHS staff bank is an entity managed by the trust that hires clinical and non-clinical healthcare professionals to take on shifts at our trust hospitals and community settings. Here at EPUT we maintain our own bank of specialist staff to ensure that we are able offer safe and effective care at all times. All our permanent staff are automatically enrolled onto the staff bank however this does not mean you have to work any additional shifts, but the option is there for you if you wish. If you are joining our Trust in a fixed term role, please indicate on your New Starter Paperwork that you wish to join our staff bank. Date posted 05 November 2024 Pay scheme Agenda for change Band Band 6 Salary £37,338 to £44,962 a year per annum Contract Permanent Working pattern Full-time Reference number 364-A-8399 Job locations Head Office, The Lodge Wickford SS11 7XX Job description Job responsibilities 1. To be responsible for analysing customer and service requirements, related to data and information. 2. To extract complex data from multiple Trust systems, using multiple, complex querying methods and languages. 3. To write complex code and test theory to successful output 4. To provide clear and concise written and verbal reports on performance indicators to staff within the organisation, this will involve the interpretation of data and the need to present complex and sometimes sensitive or contentious information in a clear and understandable format. 5. To be responsible for production and development regular reports using appropriate query languages and software packages to analyse and interpret Trust performance. 6. To interpret and analyse activity and staff data to produce complex reports, drawing attention to areas of risk, and investigating any particular areas of concern, recommending changes to work practices and policy, where necessary 7. To work closely with operational services to improve areas of performance, communicating the need for change and giving a clear vision and plan of how this is to be achieved. 8. To understand and be able to explain to others performance targets, that may be highly complex and specialist in their nature and communicate these in an understandable way to staff. 4. The postholder will be responsible for the coordination of Quality and Performance reporting to Trust Commissioners and for the coordination of the Trustwide Quality and Performance Report 5. To be responsible for the development and ongoing maintenance of performance dashboards which ensure the right information is available at the right times at all levels of the organisation. This will include the technical development of dashboards 6. To co-ordinate and support designated projects in relation to performance improvement, national and/or contractual requirements. These projects may have implications on clinical and service delivery and will require strong communication skills and ability to engage effectively with a range of staff groups. 7. To deliver change through facilitation, engagement of stakeholders, analysis, planning, consultation, project management, capacity and demand analysis and other proven techniques to ensure performance improvements are sustainable, sharing good practice at all levels. 8. The post holder will identify methods of measurement for targets; milestones and timescales for all performance improvement projects, in order to ensure an evidence based approach 9. To leads on discrete developments and design of health related data sets and information and will respond proactively to national and local policy developments to ensure that information is provided in accordance with requirement. 10. To adapt, design and develop reporting processes to support local and national policy and other requirements in partnership with Senior Information Managers 11. To support the implementation of new systems, within national and local policy 12. To be responsible for keeping abreast of new technical ways of working and NHS and trust policy changes 13. To support operational managers and clinicians in the decision-making process by ensuring that the information generated by the team is accurate, timely and fit for purpose. 14. To support operational managers and clinicians in the achievement of all performance related targets, including CQC targets and locally set Commissioner and Local Authority targets 15. To analyse and interpret a range of complex performance and business data, identifying areas of concern and presenting options for resolution of concerns and improvement in service performance. 16. The post holder will track and monitor progress and report progress against identified measures on a regular basis to various stakeholder groups. 17. To respond to adhoc questions and requests for reports, which may often have short deadlines, effectively, efficiently and professional ensuring constant review of priorities and work allocation. 18. To promote the corporate Information System as the principal source for data entry and analysis, working to improve data quality on corporate systems where there is an obstacle to use this as the principal system. 19. To have day to day coaching responsibilities for a group of Performance and Information Assistants and when required supervisory or line management responsibility. This will include ensuring that training and regular support is delivered to staff, reviewing work performance and progress against key daily objectives as set out by the Associate Director of Business Analysis 20. To liaise with relevant staff within the Trust such as the Administration Leads to ensure that clinical data is reliably reportable in an accurate, complete, consistent and timely manner. 21. To attend Operational Business / Senior Management Team Meetings on behalf of the department 22. To attend, as required, meetings with Commissioners and Local Authority partners, representing the directorate. 23. The post holder will have regular contact with staff across the Trust, alongside contact with outside agencies and organisations, for example, Primary Care Trusts, Department of Health, NHSI, Local Authorities and other provider Trusts and must always behave in an appropriate and polite manner, working collaboratively and having the knowledge to know where the boundaries of confidentiality lie. 24. The post holder will demonstrate a flexible approach to testing new ideas, tools and techniques in order to ensure that the team is innovative and able to continually refine their approaches to reflect and develop leading edge performance and business reporting systems and performance improvement practice. 25. To assist with the introduction of new standards within services and to support the development and implementation of systems for compliance and reporting. 26. To work with new services within the Trust, whether internally developed or acquired through a tendering process to ensure appropriate systems are in place to record and monitor all relevant standards. 27. To monitor the effectiveness of performance improvement initiatives, identify key lessons learnt and ensure these are effectively communicated to relevant groups. 28. To analyse complex performance data from a variety of different sources and present this in a clear and understandable manner. 29. To identify potential breaches of performance standards and take appropriate action to investigate and implement preventative measures. 30. Development of policies and procedures to support performance improvements and adherence to standards. 31. To identify data quality issues and to work with Information colleagues and operational services to identify and implement solutions. 32. Contribute to effective team working by transferring skills and knowledge to appropriate staff and ensuring that working procedures are properly documented and maintained 33. To support the introduction of new Information Systems within the Trust 34. Manage, maintain and develop performance and business reporting systems for use both within the directorate and across the Trust 35. To line manage Performance and Information Assistants. This will include recruitment, selection, appraisal, training and development. The post-holder will also be responsible for allocating and managing individual workload and for ensuring that in liaison with other senior staff within the department that appropriate support is provided to achieve priority tasks for the team as a whole. 36. Authorised signatory for direct reports expenses, timesheets etc. 37. To provide cover for colleagues in the Performance Reporting Team during holidays, sickness etc. This may include attending meetings and communicating with the Executive Team 38. To lead and/or participate in any other projects or trust activities that contribute to the organisations objectives of providing high, quality care as directed by Line Manager and Service Director. 39. It is implicit that the post holder be required to demonstrate commitment to, and evidence of continued professional development and belief in maintaining an up to date knowledge of technical/professional information relevant to this position and to use it effectively. Job description Job responsibilities 1. To be responsible for analysing customer and service requirements, related to data and information. 2. To extract complex data from multiple Trust systems, using multiple, complex querying methods and languages. 3. To write complex code and test theory to successful output 4. To provide clear and concise written and verbal reports on performance indicators to staff within the organisation, this will involve the interpretation of data and the need to present complex and sometimes sensitive or contentious information in a clear and understandable format. 5. To be responsible for production and development regular reports using appropriate query languages and software packages to analyse and interpret Trust performance. 6. To interpret and analyse activity and staff data to produce complex reports, drawing attention to areas of risk, and investigating any particular areas of concern, recommending changes to work practices and policy, where necessary 7. To work closely with operational services to improve areas of performance, communicating the need for change and giving a clear vision and plan of how this is to be achieved. 8. To understand and be able to explain to others performance targets, that may be highly complex and specialist in their nature and communicate these in an understandable way to staff. 4. The postholder will be responsible for the coordination of Quality and Performance reporting to Trust Commissioners and for the coordination of the Trustwide Quality and Performance Report 5. To be responsible for the development and ongoing maintenance of performance dashboards which ensure the right information is available at the right times at all levels of the organisation. This will include the technical development of dashboards 6. To co-ordinate and support designated projects in relation to performance improvement, national and/or contractual requirements. These projects may have implications on clinical and service delivery and will require strong communication skills and ability to engage effectively with a range of staff groups. 7. To deliver change through facilitation, engagement of stakeholders, analysis, planning, consultation, project management, capacity and demand analysis and other proven techniques to ensure performance improvements are sustainable, sharing good practice at all levels. 8. The post holder will identify methods of measurement for targets; milestones and timescales for all performance improvement projects, in order to ensure an evidence based approach 9. To leads on discrete developments and design of health related data sets and information and will respond proactively to national and local policy developments to ensure that information is provided in accordance with requirement. 10. To adapt, design and develop reporting processes to support local and national policy and other requirements in partnership with Senior Information Managers 11. To support the implementation of new systems, within national and local policy 12. To be responsible for keeping abreast of new technical ways of working and NHS and trust policy changes 13. To support operational managers and clinicians in the decision-making process by ensuring that the information generated by the team is accurate, timely and fit for purpose. 14. To support operational managers and clinicians in the achievement of all performance related targets, including CQC targets and locally set Commissioner and Local Authority targets 15. To analyse and interpret a range of complex performance and business data, identifying areas of concern and presenting options for resolution of concerns and improvement in service performance. 16. The post holder will track and monitor progress and report progress against identified measures on a regular basis to various stakeholder groups. 17. To respond to adhoc questions and requests for reports, which may often have short deadlines, effectively, efficiently and professional ensuring constant review of priorities and work allocation. 18. To promote the corporate Information System as the principal source for data entry and analysis, working to improve data quality on corporate systems where there is an obstacle to use this as the principal system. 19. To have day to day coaching responsibilities for a group of Performance and Information Assistants and when required supervisory or line management responsibility. This will include ensuring that training and regular support is delivered to staff, reviewing work performance and progress against key daily objectives as set out by the Associate Director of Business Analysis 20. To liaise with relevant staff within the Trust such as the Administration Leads to ensure that clinical data is reliably reportable in an accurate, complete, consistent and timely manner. 21. To attend Operational Business / Senior Management Team Meetings on behalf of the department 22. To attend, as required, meetings with Commissioners and Local Authority partners, representing the directorate. 23. The post holder will have regular contact with staff across the Trust, alongside contact with outside agencies and organisations, for example, Primary Care Trusts, Department of Health, NHSI, Local Authorities and other provider Trusts and must always behave in an appropriate and polite manner, working collaboratively and having the knowledge to know where the boundaries of confidentiality lie. 24. The post holder will demonstrate a flexible approach to testing new ideas, tools and techniques in order to ensure that the team is innovative and able to continually refine their approaches to reflect and develop leading edge performance and business reporting systems and performance improvement practice. 25. To assist with the introduction of new standards within services and to support the development and implementation of systems for compliance and reporting. 26. To work with new services within the Trust, whether internally developed or acquired through a tendering process to ensure appropriate systems are in place to record and monitor all relevant standards. 27. To monitor the effectiveness of performance improvement initiatives, identify key lessons learnt and ensure these are effectively communicated to relevant groups. 28. To analyse complex performance data from a variety of different sources and present this in a clear and understandable manner. 29. To identify potential breaches of performance standards and take appropriate action to investigate and implement preventative measures. 30. Development of policies and procedures to support performance improvements and adherence to standards. 31. To identify data quality issues and to work with Information colleagues and operational services to identify and implement solutions. 32. Contribute to effective team working by transferring skills and knowledge to appropriate staff and ensuring that working procedures are properly documented and maintained 33. To support the introduction of new Information Systems within the Trust 34. Manage, maintain and develop performance and business reporting systems for use both within the directorate and across the Trust 35. To line manage Performance and Information Assistants. This will include recruitment, selection, appraisal, training and development. The post-holder will also be responsible for allocating and managing individual workload and for ensuring that in liaison with other senior staff within the department that appropriate support is provided to achieve priority tasks for the team as a whole. 36. Authorised signatory for direct reports expenses, timesheets etc. 37. To provide cover for colleagues in the Performance Reporting Team during holidays, sickness etc. This may include attending meetings and communicating with the Executive Team 38. To lead and/or participate in any other projects or trust activities that contribute to the organisations objectives of providing high, quality care as directed by Line Manager and Service Director. 39. It is implicit that the post holder be required to demonstrate commitment to, and evidence of continued professional development and belief in maintaining an up to date knowledge of technical/professional information relevant to this position and to use it effectively. Person Specification Shortlisting Essential Educated to post graduate level or equivalent relevant NHS experience Demonstrable experience working in this field and evidence of working at in a role that necessitated working independently Desirable Intermediate level in MS Office Excel Experience using SQL Experience using Power BI Evidence Essential Evidence of continuing professional development to post graduate diploma level or equivalent. Person Specification Shortlisting Essential Educated to post graduate level or equivalent relevant NHS experience Demonstrable experience working in this field and evidence of working at in a role that necessitated working independently Desirable Intermediate level in MS Office Excel Experience using SQL Experience using Power BI Evidence Essential Evidence of continuing professional development to post graduate diploma level or equivalent. 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 (Opens in a new tab). 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 (Opens in a new tab). Additional information 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 (Opens in a new tab). 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 (Opens in a new tab). Employer details Employer name Essex Partnership University NHS Foundation Trust Address Head Office, The Lodge Wickford SS11 7XX Employer's website https://eput.nhs.uk/ (Opens in a new tab)