Job summary
Due to the promotion of the current post-holder, an exciting opportunity has arisen for a highly motivated and experienced business analyst to apply for a permanent role as Business Analyst working across the Combined Community and Acute Group.
This is a key role in the Business Intelligence and Performance function of the care group which will work across all of the directorates in the care group: Integrated Community Care; Integrated Geriatric and Stroke Medicine and Therapeutics and Palliative Care.
We are a strong and effective team, looking for a new member with the experience and personal values to complement ours.
Main duties of the job
- This is a specialist role and is critical to support key decision makers to monitor performance, enhance service planning and lead to better delivery of services across a wide spectrum of needs and settings in the Combined Community and Acute Care Group.
- The post holder will co-ordinate daily, weekly, monthly and quarterly reports for the CCAG Executive Team to monitor performance against Care Group plans, projects and standards.; reports will also be developed for sharing with front line staff.
- The post holder will be responsible for the on-going development of the Information Systems in CCAG and development of the Care Group Performance Management offer in collaboration with other Care Group performance/analyst roles.
- The post holder is the primary provider of Business Analyst support to the Integrated Community Care Directorate within the group with other Care Group responsibilities.
About us
The Care Group has a workforce of over 2,500 people, and a budget of approximately £94million. There are 37 discrete services working from a significant number of local bases in the community and across all our acute sites.
Patient pathways within the care group span the provision of health services across community and acute services, including older people, stroke and palliative care. The Care Group provides community health services for Sheffield, and as a key provider works in partnership across the city with colleagues across health and social care. The Care Group is focused on delivering truly integrated care for patients whose care transcends primary, community, intermediate and acute care.
Job description
Job responsibilities
Please view the attached Job Description and Person Specification documents for full details regarding this post.
- The post holder will be required to undertake the following business analysis responsibilities as either the lead business analyst or by deputising for the Senior Business Analyst in the care group to ensure resilience of the crucial business analysis function.
- Undertake the interpretation of highly complex NHS national payment rules and translate those rules into complex algorithms and computer code to support delivery and recovery of Programme and Directorate income and expenditure.
- To communicate highly complex, sensitive, analytical information to service managers and staff where there may be barriers to understanding
- In conjunction with the Performance and Information team, manage the process of analysing, communicating, and disseminating data and information to build and support management action plans.
- Undertake detailed and complex analysis of performance on behalf the Executive Team.
- Develop and undertake the interpretation of complex reports on KPIs such as length of stay, midnight bed occupancy, flow across acute and community and other key metrics used to monitor improvement in the Care Group.
- Undertake regular analysis of Dr Fosters data and other benchmarking relating to the Stroke and Geriatric specialties and across acute and community services with particular attention to Length of Stay information.
- In conjunction with Care Group Clinical and Management team, manage the process of analysing, communicating, and setting activity plans and waiting list trajectories to support the acute services annual business planning round.
- Lead on the analysis and monitoring of some Care Group and Directorate Service Improvement plans using the Trusts WinChart software and statistical process control methodologies.
- Detailed working knowledge of Infoflex system to write technical reporting query to extract and interpret operational activity information for relevant group services.
- Extract, collate and interpret information in support of improvement in operational delivery to achieve Best Practice Tariff in relevant CCAG services.
- Specific support to the Deputy Operations Director in the delivery of Referral to Treatment time requirements and the CCAG data quality metrics.
- To assist in the continued development of the use of information throughout the Trust to support improvements in the clinical and business processes.
Job description
Job responsibilities
Please view the attached Job Description and Person Specification documents for full details regarding this post.
- The post holder will be required to undertake the following business analysis responsibilities as either the lead business analyst or by deputising for the Senior Business Analyst in the care group to ensure resilience of the crucial business analysis function.
- Undertake the interpretation of highly complex NHS national payment rules and translate those rules into complex algorithms and computer code to support delivery and recovery of Programme and Directorate income and expenditure.
- To communicate highly complex, sensitive, analytical information to service managers and staff where there may be barriers to understanding
- In conjunction with the Performance and Information team, manage the process of analysing, communicating, and disseminating data and information to build and support management action plans.
- Undertake detailed and complex analysis of performance on behalf the Executive Team.
- Develop and undertake the interpretation of complex reports on KPIs such as length of stay, midnight bed occupancy, flow across acute and community and other key metrics used to monitor improvement in the Care Group.
- Undertake regular analysis of Dr Fosters data and other benchmarking relating to the Stroke and Geriatric specialties and across acute and community services with particular attention to Length of Stay information.
- In conjunction with Care Group Clinical and Management team, manage the process of analysing, communicating, and setting activity plans and waiting list trajectories to support the acute services annual business planning round.
- Lead on the analysis and monitoring of some Care Group and Directorate Service Improvement plans using the Trusts WinChart software and statistical process control methodologies.
- Detailed working knowledge of Infoflex system to write technical reporting query to extract and interpret operational activity information for relevant group services.
- Extract, collate and interpret information in support of improvement in operational delivery to achieve Best Practice Tariff in relevant CCAG services.
- Specific support to the Deputy Operations Director in the delivery of Referral to Treatment time requirements and the CCAG data quality metrics.
- To assist in the continued development of the use of information throughout the Trust to support improvements in the clinical and business processes.
Person Specification
Qualifications
Essential
- Educated to degree level (or equivalent) including honours degree with statistical or business related modules, diploma or equivalent professional training.
Desirable
- Post Graduate Qualification or equivalent experience
Experience
Essential
- Working in an NHS information environment.
- Database development
- Advanced knowledge and experience of Microsoft Office packages, including Word, Excel, Access and PowerPoint
- Intermediate knowledge of computer programming languages (SQL and Visual Basic)
- Experience of developing, using and maintaining databases
- Understanding of methods for effective electronic back up of important data
- Understanding of basic principles of data analysis and statistics
- Experience of data analysis work
- Understanding of data protection legislation and its impact on the role day to day
Desirable
- Work in an acute trust
- Experience of Dr Fosters reporting
- Experience of using Trust information systems (PAS/PFI)
- Experience of working in a GSM setting.
Special Skills/Aptitudes
Essential
- Expert level of skill in information analysis and synthesis, including the ability to receive highly complex and sensitive information on patient details and diagnoses and the ability to interpret, draw conclusions from it and synthesise new knowledge from the findings. The data may be conflicting and may be contentious to those receiving it. The post holder must have an understanding of the issues facing the NHS and strategic objectives
- Ability to interpret national policy and guidance documents to provide expertise on information issues
- Ability to make decisions and show considerable initiative in the formulation of recommendations and subsequent actions.
- Expert technical knowledge of information systems including in depth knowledge of NHS data definitions.
- Expert skills in complex data extraction from the Trust's information databases including the use of Structured Query Language (SQL) and manipulation of this data in spread sheets and PC applications such as Excel and Access, using skills at an advanced level of expertise.
Additional factors
Essential
- Outcome focused, strong drive and motivation
- Energy and enthusiasm for delivering improvement
- Organisational skills
- Effective verbal communication skills
- Ability to appropriately escalate decisions or queries providing full information to line manager
- Ability to prioritise effectively
- Ability to successfully work to sometimes tight deadlines
- Commitment to patient-centred services
- Attention to detail
- Professional approach particularly when communicating with senior clinicians and managers
Person Specification
Qualifications
Essential
- Educated to degree level (or equivalent) including honours degree with statistical or business related modules, diploma or equivalent professional training.
Desirable
- Post Graduate Qualification or equivalent experience
Experience
Essential
- Working in an NHS information environment.
- Database development
- Advanced knowledge and experience of Microsoft Office packages, including Word, Excel, Access and PowerPoint
- Intermediate knowledge of computer programming languages (SQL and Visual Basic)
- Experience of developing, using and maintaining databases
- Understanding of methods for effective electronic back up of important data
- Understanding of basic principles of data analysis and statistics
- Experience of data analysis work
- Understanding of data protection legislation and its impact on the role day to day
Desirable
- Work in an acute trust
- Experience of Dr Fosters reporting
- Experience of using Trust information systems (PAS/PFI)
- Experience of working in a GSM setting.
Special Skills/Aptitudes
Essential
- Expert level of skill in information analysis and synthesis, including the ability to receive highly complex and sensitive information on patient details and diagnoses and the ability to interpret, draw conclusions from it and synthesise new knowledge from the findings. The data may be conflicting and may be contentious to those receiving it. The post holder must have an understanding of the issues facing the NHS and strategic objectives
- Ability to interpret national policy and guidance documents to provide expertise on information issues
- Ability to make decisions and show considerable initiative in the formulation of recommendations and subsequent actions.
- Expert technical knowledge of information systems including in depth knowledge of NHS data definitions.
- Expert skills in complex data extraction from the Trust's information databases including the use of Structured Query Language (SQL) and manipulation of this data in spread sheets and PC applications such as Excel and Access, using skills at an advanced level of expertise.
Additional factors
Essential
- Outcome focused, strong drive and motivation
- Energy and enthusiasm for delivering improvement
- Organisational skills
- Effective verbal communication skills
- Ability to appropriately escalate decisions or queries providing full information to line manager
- Ability to prioritise effectively
- Ability to successfully work to sometimes tight deadlines
- Commitment to patient-centred services
- Attention to detail
- Professional approach particularly when communicating with senior clinicians and managers
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.
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.
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).
