Job summary
The Forensic Service Performance Team is a small dynamic team that provides activity and performance information for Inpatient and Community Forensic Services. We work closely with our commissioners, North London Forensic Collaborative (NLFC), which is formed of the secure services of five mental Health Trusts; which includes West London NHS Trust.
We are now recruiting to a full time Business Information Analyst. This post will provide analytical analysis support to the Performance Team and work as an effective and integral part of the Team to ensure information meets the service and commissioning needs.
We are looking for an enthusiastic individual with extensive data analysis experience. Applicants must be well organised, flexible and quick to learn as well as able to demonstrate an ability to work as a team member. Extensive and Advanced level of working knowledge and experience in the use of Excel functions, SPC charts and Basic understanding of SQL is essential. It will be necessary to travel between the London and Broadmoor Sites.
Please note that there will be a 30 minute test as part of the Interview Process
Main duties of the job
The post holder will be part of the Finance & Performance team whose responsibility is the provision of timely and accurate data to our internal management team and external stakeholders both on a regular basis and an ad hoc basis. The post holder will be expected to develop excellent working relationships with Directors and their management teams.
The post holder has a primary responsibility of providing analytical analysis and support to the Forensic service information, performance and quality improvement agenda as well as facilitating the generation of accurate and timely NLFC contract and internal performance reports.
To work alongside the Performance Manager in providing on-going analysis and benchmarking of the CSU's KPI performance in order to highlight problem areas and proactively engage with managers and clinicians to advise and resolve information reporting issues.
About us
West London NHS Trust is one of the most diverse healthcare providers in the UK, delivering a range of mental health and physical healthcare and community services. The Trust runs Broadmoor Hospital, one of three high secure hospitals in the country, with an international reputation.
Our high secure services care for patients from South of England and we provide low and medium secure services across eight London boroughs. The Trust also provides mental and physical healthcare in three London boroughs (Ealing, Hounslow and Hammersmith & Fulham). We employ 4,500 staff, of whom 56% are BME. Our turnover for 2023-24 is £426m.
The Trust is rated as 'Good' overallby the Care Quality Commission. Forensic services are rated as 'Outstanding'.
The Trust is an established partner and contributor in the development of the evolving North West London Integrated Care System and the Integrated Care Board. The Trust leads the NW London Children and Adolescent Mental Health provider collaborative.
Job description
Job responsibilities
The Candidate Pack provides an overview of the key tasks and responsibilities of the role, and the person specification outlines the qualifications, skills, experience and knowledge required. Please view as attached
The person specification below is not the full person specification, but outlines the criteria against which your application form will be assessed.
Job description
Job responsibilities
The Candidate Pack provides an overview of the key tasks and responsibilities of the role, and the person specification outlines the qualifications, skills, experience and knowledge required. Please view as attached
The person specification below is not the full person specification, but outlines the criteria against which your application form will be assessed.
Person Specification
Qualifications
Essential
- Degree in Mathematics / Statistics or equivalent relevant experience in Health Informatics or Information management.
- Evidence of ongoing relevant personal and professional development
Desirable
- Post Graduate qualification in Mathematics / Statistics or equivalent experience in health informatics
Experience
Essential
- Extensive experience in performance reporting and information analysis in healthcare
- Ability to analyse, investigate, summarise and present complex data sets
- Experience of providing regular & ad hoc information reports of a complex nature
- Experience of delivery of Statistical Process Control analysis.
- Experience in data query, extraction and manipulating tools, SQL, SQL reporting etc
- Experience in developing clear and concise information management reports, procedures and guidance documents
- Producing NHSE contract returns and adhering to performance monitoring frameworks requirements
- Use of Business Intelligence tools and development
- Data quality improvement initiatives
Desirable
- Experience of working within NHS mental health informatics services
- Experience of contributing to National and Local Benchmarking exercise
Knowledge
Essential
- Highly developed data analysis skills using SQL, Excel functions and SPC concepts to present reports
- Practical Knowledge of Statistical Process Control charts
- Knowledge and experience of using Business reporting systems, such as Tableau for building reports and data analysis and familiarity with data visualization techniques
- Working knowledge of data warehouse environment, structure and functioning
- Knowledge of the NHS Data dictionary and data sets specifically to MH Trusts
- Advanced working knowledge of software packages: Excel, Word and PowerPoint
Desirable
- Sound knowledge of NHS Statutory reporting, data flows and NHS performance reporting frameworks
- Excellent understanding, knowledge and experience of NHS activity data and performance management requirements
- Sharing skills and knowledge with other members of the team
- Working knowledge of RiO
Skills
Essential
- Expert Microsoft user specifically in Excel, Intermediate Structured Query Language (SQL) and/or Advanced Access and Excel report production
- Strong analytical skills required to tackle complex data queries and information requirements
- Managing change within area of responsibility
Desirable
- Experience of developing dashboards in business intelligence applications e.g. Tableau
Other Requirements
Essential
- Ability to challenge constructively & work collaboratively
- Proactive approach in the development of ideas and data quality initiatives
- Well-developed analytical and problem solving skills
- Highly methodical and organised and attention to details
- Ability to work autonomously to prioritise tasks and to manage conflicting demands on time and resources, to deliver objectives to deadlines
- Ability to develop effective working relationships and demonstrate professional credibility with colleagues at all levels
- Ability to manage change effectively
- Effective communicator (both verbal and written)
Desirable
- Able to identify and implement "smarter" ways of working
- Self-learner and maintaining CPD by attending short courses/training as relevant and appropriate to the role and needs of the service
Person Specification
Qualifications
Essential
- Degree in Mathematics / Statistics or equivalent relevant experience in Health Informatics or Information management.
- Evidence of ongoing relevant personal and professional development
Desirable
- Post Graduate qualification in Mathematics / Statistics or equivalent experience in health informatics
Experience
Essential
- Extensive experience in performance reporting and information analysis in healthcare
- Ability to analyse, investigate, summarise and present complex data sets
- Experience of providing regular & ad hoc information reports of a complex nature
- Experience of delivery of Statistical Process Control analysis.
- Experience in data query, extraction and manipulating tools, SQL, SQL reporting etc
- Experience in developing clear and concise information management reports, procedures and guidance documents
- Producing NHSE contract returns and adhering to performance monitoring frameworks requirements
- Use of Business Intelligence tools and development
- Data quality improvement initiatives
Desirable
- Experience of working within NHS mental health informatics services
- Experience of contributing to National and Local Benchmarking exercise
Knowledge
Essential
- Highly developed data analysis skills using SQL, Excel functions and SPC concepts to present reports
- Practical Knowledge of Statistical Process Control charts
- Knowledge and experience of using Business reporting systems, such as Tableau for building reports and data analysis and familiarity with data visualization techniques
- Working knowledge of data warehouse environment, structure and functioning
- Knowledge of the NHS Data dictionary and data sets specifically to MH Trusts
- Advanced working knowledge of software packages: Excel, Word and PowerPoint
Desirable
- Sound knowledge of NHS Statutory reporting, data flows and NHS performance reporting frameworks
- Excellent understanding, knowledge and experience of NHS activity data and performance management requirements
- Sharing skills and knowledge with other members of the team
- Working knowledge of RiO
Skills
Essential
- Expert Microsoft user specifically in Excel, Intermediate Structured Query Language (SQL) and/or Advanced Access and Excel report production
- Strong analytical skills required to tackle complex data queries and information requirements
- Managing change within area of responsibility
Desirable
- Experience of developing dashboards in business intelligence applications e.g. Tableau
Other Requirements
Essential
- Ability to challenge constructively & work collaboratively
- Proactive approach in the development of ideas and data quality initiatives
- Well-developed analytical and problem solving skills
- Highly methodical and organised and attention to details
- Ability to work autonomously to prioritise tasks and to manage conflicting demands on time and resources, to deliver objectives to deadlines
- Ability to develop effective working relationships and demonstrate professional credibility with colleagues at all levels
- Ability to manage change effectively
- Effective communicator (both verbal and written)
Desirable
- Able to identify and implement "smarter" ways of working
- Self-learner and maintaining CPD by attending short courses/training as relevant and appropriate to the role and needs of the service
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.
