Job summary
Mersey Care NHS Foundation Trust provides specialist inpatient and community mental health, learning disabilities, addiction services and acquired brain injury services for the people of Liverpool, Sefton and Kirkby, Merseyside. We also provide community physical health services across Lancashire, Greater Manchester, Cheshire and Merseyside.
We work closely with service users, carers and partner organisations, we've been able to make real improvements to our diverse range of services, from health and social care, right through to high secure provision.
Mersey Care's vision and values drive our organisation and the way we work together to deliver services. Applicants will be expected to demonstrate that their behaviour supports our values of Continuous Improvement, Accountability, Respect, Enthusiasm and Support (CARES).
An exciting opportunity has arisen to work within the Addictions services. The successful candidate will utilise Transact-SQL (T-SQL) and the Microsoft Office suite of products to analyse complex large datasets into meaningful information for senior managers.
Any experience of SQL Server Reporting Services (SSRS) or Power BI would be beneficial but is not essential. The post holder will also have responsibility for completing national returns, internal performance reporting and ad hoc requests.
If you feel you have the skills to add to our expert team we would be delighted to hear from you.
Main duties of the job
As a result of the post-holder being effective in their role, The Trust would expect to see the following outcomes for the Trust, service users and the wider community:1. Mersey Care NHS Trust as a leading provider of mental health care, addiction services and learning disability care.2. Service users receive a high quality service and one which is free from stigma, discrimination and harm.3. Staff are engaged with the delivery, innovation and continuous improvement of services to benefit service users.4. The Trust values of Continuous Improvement, Accountability, Respectfulness andEnthusiasm will be embedded across the division for all staff and evident to service users.5. Available informative performance reports that meet Divisions, directorates, teams and individual requirements.6. Increased confidence in the quality of data included within the reports.7. Real time reporting becomes the standard with front line staff being able to access reports applicable to them from their base.
If you feel you have the skills to add to our expert team we would be delighted to hear from you.
About us
Mersey Care is one of the largest trusts providing physical and mental health services in the North West, serving more than 11 million people.
We offer specialist inpatient and community services that support physical and mental health and specialist inpatient mental health, learning disability, addiction and brain injury services. Mersey Care is one of only three trusts in the UK that offer high secure mental health facilities.
At the heart of all we do is our commitment to 'perfect care' - care that is safe, effective, positively experienced, timely, equitable and efficient. We support our staff to do the best job they can and work alongside service users, their families, and carers to design and develop future services together. We're currently delivering a programme of organisational and service transformation to significantly improve the quality of the services we provide and safely reduce cost as we do so.
Job description
Job responsibilities
1. Create and produce reports from the Trusts Information Systems so as to provide high quality, accurate and timely information to assist decision making and support service provision within the Trust, and to enable monitoring of the Trusts performance by its staffand Commissioners.2. Support teams in the extraction and analysis of data.3. Assist in the completion and submission of aggregate statutory returns and information to support audits etc.4. Provide information on request to key stakeholders, and in line with Freedom of Information requirements.5. Provide support in ensuring that all information is of a high standard so as to accurately reflect performance and progress against standards and targets, and to highlight any dataquality issues to the Solutions and Data Architect.6. Assist the Data Modeller in the design and production of a suite of regular online performance reports, enforcing version control throughout.7. Support the Data Modeller in developing processes so as to provide assurances to the Trust Board on performance.8. Work closely with the Trusts teams and divisions, participating in quality and business meetings and ensuring that any information issues are fed back.9. Support the Solutions and Data Architect and Data Modeller in ensuring that accurate and consistent data is used for all Trust information reporting, by following agreed procedures for extraction, collation and storage of data.10. Assist in the collation and storage of information from different sources to enable monitoring of performance against targets and objectives, capacity and business planning and benchmarking against other organisations.11. Liaise with outside agencies, e.g. CCGs, TDA, CQC, Auditors etc. regarding submissions and queries.12. Act as the first line of support for queries around the interpretation of information, targets and trends within the Trusts performance reports.13. Work to tight deadlines in order to ensure that accurate information is made available to the Board, Committees, Divisional teams etc. as well as auditors and other key stakeholders.14. Assist in the production of information to support Business Planning and business development.15. Utilise performance reporting tools to identify areas of good and poor performance and to assist in the production of information statements etc. in order to support the delivery of perfect care.16. Providing data to support project work as required.17. To assist in the development of bespoke reports to enable analysis to improve practice.18. Attend Trust groups when required as representative for the Informatics and Performance Improvement directorate.19. Assist in the creation and implementation of procedures and processes to promote the accuracy of information produced and the maintenance of high standards within the Performance Team
Job description
Job responsibilities
1. Create and produce reports from the Trusts Information Systems so as to provide high quality, accurate and timely information to assist decision making and support service provision within the Trust, and to enable monitoring of the Trusts performance by its staffand Commissioners.2. Support teams in the extraction and analysis of data.3. Assist in the completion and submission of aggregate statutory returns and information to support audits etc.4. Provide information on request to key stakeholders, and in line with Freedom of Information requirements.5. Provide support in ensuring that all information is of a high standard so as to accurately reflect performance and progress against standards and targets, and to highlight any dataquality issues to the Solutions and Data Architect.6. Assist the Data Modeller in the design and production of a suite of regular online performance reports, enforcing version control throughout.7. Support the Data Modeller in developing processes so as to provide assurances to the Trust Board on performance.8. Work closely with the Trusts teams and divisions, participating in quality and business meetings and ensuring that any information issues are fed back.9. Support the Solutions and Data Architect and Data Modeller in ensuring that accurate and consistent data is used for all Trust information reporting, by following agreed procedures for extraction, collation and storage of data.10. Assist in the collation and storage of information from different sources to enable monitoring of performance against targets and objectives, capacity and business planning and benchmarking against other organisations.11. Liaise with outside agencies, e.g. CCGs, TDA, CQC, Auditors etc. regarding submissions and queries.12. Act as the first line of support for queries around the interpretation of information, targets and trends within the Trusts performance reports.13. Work to tight deadlines in order to ensure that accurate information is made available to the Board, Committees, Divisional teams etc. as well as auditors and other key stakeholders.14. Assist in the production of information to support Business Planning and business development.15. Utilise performance reporting tools to identify areas of good and poor performance and to assist in the production of information statements etc. in order to support the delivery of perfect care.16. Providing data to support project work as required.17. To assist in the development of bespoke reports to enable analysis to improve practice.18. Attend Trust groups when required as representative for the Informatics and Performance Improvement directorate.19. Assist in the creation and implementation of procedures and processes to promote the accuracy of information produced and the maintenance of high standards within the Performance Team
Person Specification
Experience
Essential
- Providing Statutory Reports to External agencies
Desirable
- Member of ASSIST or UKCHIP
Knowledge
Essential
- Numerate with GCSE Mathematics at Grade C or above
Knowledge
Essential
- Advanced knowledge and Experience of using Microsoft Office, excel, access and word
Skills
Essential
- Able to work with large amounts of complex data
Desirable
Skills
Essential
- Excellent Attention to detail
skills
Essential
- able to concentrate over long periods of time
skills
Essential
- Flexible and adaptable to change
skills
Essential
Qualifications
Essential
- Degree or equivalent level qualification o Numerate with GCSE Mathematics at grade C or above
Desirable
- Knowledge of Mental Health Information o Knowledge of Performance Management systems o Knowledge of the NHS Data Manual o Knowledge of relational databases o Experience of using visualisation software to develop online reports
Person Specification
Experience
Essential
- Providing Statutory Reports to External agencies
Desirable
- Member of ASSIST or UKCHIP
Knowledge
Essential
- Numerate with GCSE Mathematics at Grade C or above
Knowledge
Essential
- Advanced knowledge and Experience of using Microsoft Office, excel, access and word
Skills
Essential
- Able to work with large amounts of complex data
Desirable
Skills
Essential
- Excellent Attention to detail
skills
Essential
- able to concentrate over long periods of time
skills
Essential
- Flexible and adaptable to change
skills
Essential
Qualifications
Essential
- Degree or equivalent level qualification o Numerate with GCSE Mathematics at grade C or above
Desirable
- Knowledge of Mental Health Information o Knowledge of Performance Management systems o Knowledge of the NHS Data Manual o Knowledge of relational databases o Experience of using visualisation software to develop online reports
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.
