Job summary
The role of the Business Intelligence team is to promote and support the effective use of data, information, knowledge and technology to provide excellent quality clinical care to patients in the Black Country, in conjunction with its partners throughout the wider health community.
The post holder will be responsible for supporting the Business Intelligence team in developing and maintaining the Trust's information infrastructure, ensuring it is relevant, operationally stable and efficient.
The post holder will take responsibility for managing the Trust's Data Reporting Servers and lead on the maintenance and development of the Trust's clinical information and reporting system.
The post holder will have full understanding of relational databases in order to provide analytical expertise, develop reporting solutions and ensure managers and clinicians have trusted information to assist them in delivering high quality services to service users.
To liaise with external agencies and suppliers as required ensuring business continuity of the Trust's BI Reporting System is not compromised.
Main duties of the job
- Provide specialist knowledge and understanding of clinical systems and electronic patient record (EPR) architecture and the database schema.
- Assist in the development of new datasets required to support the ever changing requirements and business processes of the Trust
- Develop scripts in MSSQL
- To investigate and report on how to best manage a multi MSSQL Server database environment taking into account such aspects as maintenance, tuning, backup and restoration and disaster recovery. To discuss the implementation of any findings and to lead on implementing these plans in partnership with ICT / External System Suppliers. To include SSIS and SSRS.
- Responsible for the development, maintenance and interpretation of a large number of diverse and highly complex information data sources and extracts.
- Work with finance, workforce, governance, estates and other corporate colleagues to develop the integrated reporting framework.
- To have a thorough understanding of the NHS, its data items, its Key Performance Indicators (KPI's), its working practices and its legislation relating to data and information handling.
- Develop and maintain reports as required to support statutory returns, research and audit, commissioning, service review, clinical/operational and performance management.
- Work with the Business Intelligence team to develop automated reporting solutions.
About us
Black Country Healthcare NHS Foundation Trust provides specialist mental health, learning disability, and community healthcare services for the population of the Black Country.
Across the whole of the region we provide:
- Adult and older adult mental health services
- Specialist learning disability services
- Mental health services for children and young people
- Community healthcare services for children, young people and families in Dudley
Black Country Healthcare NHS Foundation Trust was formed on 1 April 2020, with the merger of Black Country Partnership NHS Foundation Trust and Dudley and Walsall Mental Health Partnership NHS Trust. Combining resources, strategies and talented workforce enables us to deliver a wider variety of outstanding services that are based on best practice and are continually improving.
Job description
Job responsibilities
- Provide specialist knowledge and understanding of clinical systems and electronic patient record (EPR) architecture and the database schema.
- Assist in the development of new datasets required to support the ever changing requirements and business processes of the Trust
- To be the trust lead for extremely complex problems or issues with applications or interfaces. To be able to identify root causes and to recommend, plan and implement solutions using resources from the across the BI, ICT and Software Development Teams where appropriate.
- Develop scripts in MSSQL
- To investigate and report on how to best manage a multi MSSQL Server database environment taking into account such aspects as maintenance, tuning, backup and restoration and disaster recovery. To discuss the implementation of any findings and to lead on implementing these plans in partnership with ICT / External System Suppliers. To include SSIS and SSRS.
- To work alongside stakeholders to develop new database proposals and recommendations for the use of specific database design to meet client needs and present these proposals to the target audience using negotiation and persuasion skills to ensure that the client understands the options presented and to ensure that the best outcome is reached.
- To provide information and advice to clients with regard to 3rd party procurement projects. To lead on delivering any aspect of these procurements that falls within the jurisdiction of BI and to monitor these plans and implementation.
- To lead on defining and implementing good practice in all aspects of database development in accordance with internationally recognised standards. To ensure that any databases, reports, extracts or interfaces developed by the Trust are both robust and fit for purpose.
- Responsible for the development, maintenance and interpretation of a large number of diverse and highly complex information data sources and extracts.
- Work with finance, workforce, governance, estates and other corporate colleagues to develop the integrated reporting framework.
- To have a thorough understanding of the NHS, its data items, its Key Performance Indicators (KPIs), its working practices and its legislation relating to data and information handling.
- To make recommendations on the impact of new legislation to both internal and external parties which may impact on the BI and Development Team.
- Analyse data from multiple sources, investigate core errors, resolve complex statistical and analytical queries/issues and determine the best solution. This involves the interpretation and presentation of large volumes of highly complex, sensitive data from a variety of sources to individuals and groups of professionals.
- Develop and maintain reports as required to support statutory returns, research and audit, commissioning, service review, clinical/operational and performance management.
- Work with the Business Intelligence team to develop automated reporting solutions.
- To provide ad hoc query support to the department ensuring a timely and accurate response to requests from clinicians/managers
- Develop strong working relationships with corporate and directorate managers to ensure reports meet their needs and help staff to interpret reports.
Job description
Job responsibilities
- Provide specialist knowledge and understanding of clinical systems and electronic patient record (EPR) architecture and the database schema.
- Assist in the development of new datasets required to support the ever changing requirements and business processes of the Trust
- To be the trust lead for extremely complex problems or issues with applications or interfaces. To be able to identify root causes and to recommend, plan and implement solutions using resources from the across the BI, ICT and Software Development Teams where appropriate.
- Develop scripts in MSSQL
- To investigate and report on how to best manage a multi MSSQL Server database environment taking into account such aspects as maintenance, tuning, backup and restoration and disaster recovery. To discuss the implementation of any findings and to lead on implementing these plans in partnership with ICT / External System Suppliers. To include SSIS and SSRS.
- To work alongside stakeholders to develop new database proposals and recommendations for the use of specific database design to meet client needs and present these proposals to the target audience using negotiation and persuasion skills to ensure that the client understands the options presented and to ensure that the best outcome is reached.
- To provide information and advice to clients with regard to 3rd party procurement projects. To lead on delivering any aspect of these procurements that falls within the jurisdiction of BI and to monitor these plans and implementation.
- To lead on defining and implementing good practice in all aspects of database development in accordance with internationally recognised standards. To ensure that any databases, reports, extracts or interfaces developed by the Trust are both robust and fit for purpose.
- Responsible for the development, maintenance and interpretation of a large number of diverse and highly complex information data sources and extracts.
- Work with finance, workforce, governance, estates and other corporate colleagues to develop the integrated reporting framework.
- To have a thorough understanding of the NHS, its data items, its Key Performance Indicators (KPIs), its working practices and its legislation relating to data and information handling.
- To make recommendations on the impact of new legislation to both internal and external parties which may impact on the BI and Development Team.
- Analyse data from multiple sources, investigate core errors, resolve complex statistical and analytical queries/issues and determine the best solution. This involves the interpretation and presentation of large volumes of highly complex, sensitive data from a variety of sources to individuals and groups of professionals.
- Develop and maintain reports as required to support statutory returns, research and audit, commissioning, service review, clinical/operational and performance management.
- Work with the Business Intelligence team to develop automated reporting solutions.
- To provide ad hoc query support to the department ensuring a timely and accurate response to requests from clinicians/managers
- Develop strong working relationships with corporate and directorate managers to ensure reports meet their needs and help staff to interpret reports.
Person Specification
Qualifications
Essential
- oUndergraduate degree or equivalent
- oMasters degree in relevant subject area or demonstrable equivalent experience
- oEvidence of continued professional development
Desirable
- oProject management qualification
Experience
Essential
- oSignificant NHS experience in an analytical role
- oProven experience of resolving complex information issues that have minimum guidelines or no precedent
- oExperience of handling, analysing and manipulating large highly complex datasets
- oDemonstrate delivery of successfully working to multiple high priority deadlines
- oReport writing and verbal presentations
- oEvidence of successfully managing projects
- oWorking securely with confidential sensitive patient information
- oExperience of complex statistical analysis and report writing
- oExperience of writing procedures
Desirable
- oExperience of working with mental health data
Knowledge
Essential
- oExcellent knowledge of SQL
- oUnderstanding of the EPR architecture and the database schema
- oBe conversant with the use of functions
- oFull understanding or relational database and the processes of normalisation, primary/complex keys, foreign keys and indexes
- oExcellent knowledge of how to interpret and analyse complex clinical information in an health/social care environment
- oKnowledge of national data set requirements
- oUnderstanding of statutory requirements for mental health
- oKnowledge of the NHS, including national/regional structures and an understanding of how services are managed at operational level
Skills
Essential
- oHighly advanced skills in using software products to problem solve, analyse and interpret complex information e.g. SQL, MS Excel, Power BI
- oAnalytical and judgement skills to interpret highly complex externally defined datasets and undertake in-depth analysis
- oAbility to show attention to detail and accuracy
- oAbility to think strategically to endure the team continues meet the requirements of the organisation
- oExcellent time management skills to ensure multiple competing deadlines are met
- oHighly literate and numerate
- oEffective communication skills both verbally and written to communicate highly complex information to others who may not have a strong understanding of that information
- oAble to question and challenge existing practices and working methods in order to create innovative workable solutions
- oExcellent team worker
- oAble to work on own initiative, prioritise own workload and work under pressure to tight deadlines whilst dealing with conflicting priorities
Person Specification
Qualifications
Essential
- oUndergraduate degree or equivalent
- oMasters degree in relevant subject area or demonstrable equivalent experience
- oEvidence of continued professional development
Desirable
- oProject management qualification
Experience
Essential
- oSignificant NHS experience in an analytical role
- oProven experience of resolving complex information issues that have minimum guidelines or no precedent
- oExperience of handling, analysing and manipulating large highly complex datasets
- oDemonstrate delivery of successfully working to multiple high priority deadlines
- oReport writing and verbal presentations
- oEvidence of successfully managing projects
- oWorking securely with confidential sensitive patient information
- oExperience of complex statistical analysis and report writing
- oExperience of writing procedures
Desirable
- oExperience of working with mental health data
Knowledge
Essential
- oExcellent knowledge of SQL
- oUnderstanding of the EPR architecture and the database schema
- oBe conversant with the use of functions
- oFull understanding or relational database and the processes of normalisation, primary/complex keys, foreign keys and indexes
- oExcellent knowledge of how to interpret and analyse complex clinical information in an health/social care environment
- oKnowledge of national data set requirements
- oUnderstanding of statutory requirements for mental health
- oKnowledge of the NHS, including national/regional structures and an understanding of how services are managed at operational level
Skills
Essential
- oHighly advanced skills in using software products to problem solve, analyse and interpret complex information e.g. SQL, MS Excel, Power BI
- oAnalytical and judgement skills to interpret highly complex externally defined datasets and undertake in-depth analysis
- oAbility to show attention to detail and accuracy
- oAbility to think strategically to endure the team continues meet the requirements of the organisation
- oExcellent time management skills to ensure multiple competing deadlines are met
- oHighly literate and numerate
- oEffective communication skills both verbally and written to communicate highly complex information to others who may not have a strong understanding of that information
- oAble to question and challenge existing practices and working methods in order to create innovative workable solutions
- oExcellent team worker
- oAble to work on own initiative, prioritise own workload and work under pressure to tight deadlines whilst dealing with conflicting priorities
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).
