Job summary
We are in the process of transforming the way we use data to drive improvement in the NHS. We want to hear from people who can transform data into Business Intelligence; who can see how Business Intelligence can drive transformation in the NHS; who understand how BI can be used to identify opportunities for improvement.
Main duties of the job
Senior Business Intelligence Analyst within our Business Intelligence Team. The post holder will be responsible for coordinating and delivering Business Intelligence reports to their allocated Care Group acting as key contact/business partner between the Care Group and the rest of the BI Team.
Main Duties of the Job
- To lead Business Intelligence Reporting for the Trust within their assigned Care Group(s) coordinating the contributions of Business Intelligence Analysts / Support Analysts.
- To deliver the business intelligence reporting schedule and ad-hoc reports for their assigned Care Group(s), ensuring that the Trust complies with all contractual and regulatory information sharing requirements in the most efficient way possible.
- To support the automation of data submissions through the Microsoft Power BI software solution delivered by Business Intelligence Analysts / Support Analysts, providing clarity of parameters, indicator specification and any necessary analysis of outputs.
- To promote the use of Power BI as the default platform of choice for the deployment of new reports.
About us
Midlands Partnership University NHS Foundation Trust is an award winning organisation with over 9000 employees. We're one of the largest integrated Health and Social Care providers, covering services across North & South Staffordshire, Shropshire, Hampshire, Buckinghamshire, Isle of Wight and Essex.
We pride ourselves on the services provided to support with the well-being of all of our employees both physically and mentally and offer counselling support and lifestyle information. We encourage career development provided by in house training programs and coaching support.
As part of our strong commitment to equality, diversity and inclusion, we welcome applications from candidates who meet the specific criteria, regardless of race, gender, religion, sexual orientation, age, physical and/or mental disability or offending background.
Job description
Job responsibilities
Main duties and responsibilities
- To produce and manage the production of business intelligence dashboards and the reports to the post holders assigned Care group(s). This includes delivering a schedule of planned reports and responding swiftly and efficiently to internal and external information requests, using either the Microsoft Power BI software solution or Microsoft web-based SQL Reporting Services, prioritising demand for Business Intelligence Analysts / Support Analysts.
- Use initiative to undertake follow-up queries to highly complex information requests where the solution is not immediately obvious.
- To proactively explore the development of new dashboards and reports using SQL and PowerBI and make proposals for implementing these.
- To proactively review activity within Care Groups, drawing appropriate attention to areas that may have a current or future impact on the performance of the Trust.
- To provide statistical analysis and profiles of trends within patient and Trust performance information, highlighting variances from the norm, and share this knowledge with Care Group managers and others, to support decision making and performance improvement.
- To represent the Business Intelligence Team at meetings advising Care Groups another Corporate functions on technical reporting matters.
- To further develop the Trust reporting tools to take on new data flows, enhance current flows, and assist in data migration projects.
- To develop the Business Intelligence function within the assigned Care Group(s), producing new reports, enhancing the skills of internal clients so they can extract their own reports, and participating in change management processes.
- Provide support for Trust staff on their use of dashboards and report on existing information applications.
- To improve the knowledge Trust staff has of analysis techniques to support planning and performance improvement.
- To proactively share knowledge of reporting, database and querying techniques, data standards and changes with other team members.
- Have knowledge of NHS Data Dictionary standards, and to apply them to Trust data. Work within the wider Business Intelligence Team in liaison with clinical, administrative and managerial staff to effect improvements in data quality where necessary. Seek to extend the knowledge base by expanding the information available from these applications.
- To lead on or contribute to projects within the assigned Care Group(s).
- Maintaining up to date knowledge of policy or service changes relating to information and data usage.
- Adhere to Trust Information Governance Policy; particularly with regard to data security and patient confidentiality. Make sure that managed staff comply with Information Governance Policy.
- Carry out any other duties, as requested by the Head of Business Intelligence.
Service/People Management
- To manage the delivery of the BI function in the postholder's assigned Care Group(s).
- Provide line management, support and training for members of the Business Intelligence Team including performance management when this may be required.
- To promote and participate in the process of sharing knowledge of reporting, database and querying techniques, data standards and changes between team members.
Systems and equipment
- Be familiar with the teams software and hardware requirements and liaise with and advise the Head of Business Intelligence and Principal Business Intelligence Analyst, on occasions where deficiencies in this area impede the teams productivity.
- Proactively engage in training and development opportunities made available to Team members with the aim of reaching expert level on the reporting platforms used by the Team (e.g. SQL, Power BI, Azure).
- Share systems technical knowledge with other Team members and customers as appropriate.
Decisions and judgements
- To work co-operatively with senior leaders in the Care Groups to identify how the Business Intelligence team can provide accurate information to support their clinical development.
- To provide statistical analysis and profiles of trends within patient and Trust performance information, highlighting variances from the norm, and share this knowledge with Trust managers and others, to support decision making and performance improvement.
- To interpret data requirements from non-technical staff, into technical specifications for the activity reporting systems. Interpret highly complex database processes and standards in a simplified manner for non-technical staff.
- To provide expert advice and ensure that appropriate governance is adhered to, complying with all contractual and regulatory Data Quality Standards.
- Use initiative to undertake follow-up queries to highly complex information requests where the solution is not immediately obvious.
- To contribute as required, to working groups developing performance, information, or Information Governance policies, and to volunteer suggested improvements.
- To be involved in the development of Trust business plans.
- To raise awareness within the Business Intelligence team of new guidance or legislation relating to data collection and submission, and of new performance analysis tools that may enhance the Teams service to the Trust.
- To propose changes to policy and provide support to the Head of Business Intelligence in the development of policies.
Communication and relationships
- To promote the benefit of using Business Intelligence reports currently available.
- To communicate Business Intelligence issues to a wide range of internal and external staff, providing expert advice to influence decision making to ensure appropriate action is taken.
- To enhance the knowledge and awareness within the Trust of NHS performance indicators and healthcare standards, and extract and disseminate this information from NHS Digital and other sources as appropriate.
- To advise clinical and managerial staff of technical options available and make recommendations to address data quality and performance issues.
- To gain knowledge of the clinical and non-clinical areas of the Trust, their processes and information needs. To work closely with divisional colleagues with this objective in mind.
- To interpret data requirements from non-technical staff, into technical specifications for the activity reporting systems. Interpret highly complex datasets, processes and standards in a simplified manner for non-technical staff.
- To enhance the skills of non-IT staff across the Trust, especially in information issues and in the use of the Trusts PowerBI suite of reports, RiO front end reports and any other relevant repositories.
- To provide specialist advice, guidance and support to non-technical staff in the interpretation and analysis of any performance related information.
- Attend regional and national conferences and represent the Trust on working groups as appropriate.
- To enhance links between the Trust and other NHS organisations, on any information management related matters.
- To maintain and develop the reporting relationship with NHS England, NHS Improvement and Care Quality Commission (CQC), to ensure that external guidance and targets are adhered to.
- Attend and play an active role in project groups as a representative of the team. To advise the appropriate manager of issues with data such as changes to trends or unusual levels of activity.
- To be involved in the development of Trust business plans.
Physical demands of the job
- Requires the ability to maintain and analyse highly complex patient related activity and information through appropriate database and reporting tools.
- A high level of concentration is required on a daily basis for long periods of time. Additionally, unanticipated fluctuations in demand may require highly intense periods of activity within a complex and dynamic environment. There may be frequent interruptions to answer queries from staff and customers.
- Requires a high level of experience and skilled use of IT systems and equipment. The post holder will be required to utilise highly developed keyboard skills in the manipulation and analysis of information and developing reports.
- Delivery of complex analytical documents to short deadlines.
- Requirement for light physical effort including a combination of sitting, standing and walking as required.
- There will be occasional exposure to emotional circumstances when dealing with staff performance and disciplinary issues.
- The post holder will be office based and will be required to attend meetings across the Trusts geography including National representation.
- The post holder maybe asked to work from home for extended periods to support infection control.
Job description
Job responsibilities
Main duties and responsibilities
- To produce and manage the production of business intelligence dashboards and the reports to the post holders assigned Care group(s). This includes delivering a schedule of planned reports and responding swiftly and efficiently to internal and external information requests, using either the Microsoft Power BI software solution or Microsoft web-based SQL Reporting Services, prioritising demand for Business Intelligence Analysts / Support Analysts.
- Use initiative to undertake follow-up queries to highly complex information requests where the solution is not immediately obvious.
- To proactively explore the development of new dashboards and reports using SQL and PowerBI and make proposals for implementing these.
- To proactively review activity within Care Groups, drawing appropriate attention to areas that may have a current or future impact on the performance of the Trust.
- To provide statistical analysis and profiles of trends within patient and Trust performance information, highlighting variances from the norm, and share this knowledge with Care Group managers and others, to support decision making and performance improvement.
- To represent the Business Intelligence Team at meetings advising Care Groups another Corporate functions on technical reporting matters.
- To further develop the Trust reporting tools to take on new data flows, enhance current flows, and assist in data migration projects.
- To develop the Business Intelligence function within the assigned Care Group(s), producing new reports, enhancing the skills of internal clients so they can extract their own reports, and participating in change management processes.
- Provide support for Trust staff on their use of dashboards and report on existing information applications.
- To improve the knowledge Trust staff has of analysis techniques to support planning and performance improvement.
- To proactively share knowledge of reporting, database and querying techniques, data standards and changes with other team members.
- Have knowledge of NHS Data Dictionary standards, and to apply them to Trust data. Work within the wider Business Intelligence Team in liaison with clinical, administrative and managerial staff to effect improvements in data quality where necessary. Seek to extend the knowledge base by expanding the information available from these applications.
- To lead on or contribute to projects within the assigned Care Group(s).
- Maintaining up to date knowledge of policy or service changes relating to information and data usage.
- Adhere to Trust Information Governance Policy; particularly with regard to data security and patient confidentiality. Make sure that managed staff comply with Information Governance Policy.
- Carry out any other duties, as requested by the Head of Business Intelligence.
Service/People Management
- To manage the delivery of the BI function in the postholder's assigned Care Group(s).
- Provide line management, support and training for members of the Business Intelligence Team including performance management when this may be required.
- To promote and participate in the process of sharing knowledge of reporting, database and querying techniques, data standards and changes between team members.
Systems and equipment
- Be familiar with the teams software and hardware requirements and liaise with and advise the Head of Business Intelligence and Principal Business Intelligence Analyst, on occasions where deficiencies in this area impede the teams productivity.
- Proactively engage in training and development opportunities made available to Team members with the aim of reaching expert level on the reporting platforms used by the Team (e.g. SQL, Power BI, Azure).
- Share systems technical knowledge with other Team members and customers as appropriate.
Decisions and judgements
- To work co-operatively with senior leaders in the Care Groups to identify how the Business Intelligence team can provide accurate information to support their clinical development.
- To provide statistical analysis and profiles of trends within patient and Trust performance information, highlighting variances from the norm, and share this knowledge with Trust managers and others, to support decision making and performance improvement.
- To interpret data requirements from non-technical staff, into technical specifications for the activity reporting systems. Interpret highly complex database processes and standards in a simplified manner for non-technical staff.
- To provide expert advice and ensure that appropriate governance is adhered to, complying with all contractual and regulatory Data Quality Standards.
- Use initiative to undertake follow-up queries to highly complex information requests where the solution is not immediately obvious.
- To contribute as required, to working groups developing performance, information, or Information Governance policies, and to volunteer suggested improvements.
- To be involved in the development of Trust business plans.
- To raise awareness within the Business Intelligence team of new guidance or legislation relating to data collection and submission, and of new performance analysis tools that may enhance the Teams service to the Trust.
- To propose changes to policy and provide support to the Head of Business Intelligence in the development of policies.
Communication and relationships
- To promote the benefit of using Business Intelligence reports currently available.
- To communicate Business Intelligence issues to a wide range of internal and external staff, providing expert advice to influence decision making to ensure appropriate action is taken.
- To enhance the knowledge and awareness within the Trust of NHS performance indicators and healthcare standards, and extract and disseminate this information from NHS Digital and other sources as appropriate.
- To advise clinical and managerial staff of technical options available and make recommendations to address data quality and performance issues.
- To gain knowledge of the clinical and non-clinical areas of the Trust, their processes and information needs. To work closely with divisional colleagues with this objective in mind.
- To interpret data requirements from non-technical staff, into technical specifications for the activity reporting systems. Interpret highly complex datasets, processes and standards in a simplified manner for non-technical staff.
- To enhance the skills of non-IT staff across the Trust, especially in information issues and in the use of the Trusts PowerBI suite of reports, RiO front end reports and any other relevant repositories.
- To provide specialist advice, guidance and support to non-technical staff in the interpretation and analysis of any performance related information.
- Attend regional and national conferences and represent the Trust on working groups as appropriate.
- To enhance links between the Trust and other NHS organisations, on any information management related matters.
- To maintain and develop the reporting relationship with NHS England, NHS Improvement and Care Quality Commission (CQC), to ensure that external guidance and targets are adhered to.
- Attend and play an active role in project groups as a representative of the team. To advise the appropriate manager of issues with data such as changes to trends or unusual levels of activity.
- To be involved in the development of Trust business plans.
Physical demands of the job
- Requires the ability to maintain and analyse highly complex patient related activity and information through appropriate database and reporting tools.
- A high level of concentration is required on a daily basis for long periods of time. Additionally, unanticipated fluctuations in demand may require highly intense periods of activity within a complex and dynamic environment. There may be frequent interruptions to answer queries from staff and customers.
- Requires a high level of experience and skilled use of IT systems and equipment. The post holder will be required to utilise highly developed keyboard skills in the manipulation and analysis of information and developing reports.
- Delivery of complex analytical documents to short deadlines.
- Requirement for light physical effort including a combination of sitting, standing and walking as required.
- There will be occasional exposure to emotional circumstances when dealing with staff performance and disciplinary issues.
- The post holder will be office based and will be required to attend meetings across the Trusts geography including National representation.
- The post holder maybe asked to work from home for extended periods to support infection control.
Person Specification
Qualifications and Training
Essential
- Qualifications and Training (Person Specification found in JD document attached)
Desirable
- Qualifications and Training (Person Specification found in JD document attached)
Experience
Essential
- Experience (Person Specification found in JD document attached)
Desirable
- Experience (Person Specification found in JD document attached)
Skills, Knowledge, and Abilities
Essential
- Skills, Knowledge and Abilities (Person Specification found in JD document attached)
Desirable
- Skills, Knowledge and Abilities (Person Specification found in JD document attached)
Person Specification
Qualifications and Training
Essential
- Qualifications and Training (Person Specification found in JD document attached)
Desirable
- Qualifications and Training (Person Specification found in JD document attached)
Experience
Essential
- Experience (Person Specification found in JD document attached)
Desirable
- Experience (Person Specification found in JD document attached)
Skills, Knowledge, and Abilities
Essential
- Skills, Knowledge and Abilities (Person Specification found in JD document attached)
Desirable
- Skills, Knowledge and Abilities (Person Specification found in JD document attached)
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).
Employer details
Employer name
Midlands Partnership NHS Foundation Trust
Address
St George's Hospital / Longton Cottage Hospital
Stafford / Stoke on Trent
ST16 3SR
Employer's website
https://www.mpft.nhs.uk (Opens in a new tab)
