welcome-2016-no-text.jpg

Working for us

Go to a more accessible version of this jobs board
Please wait, loading

Senior Report Builder and Data Specialist

NHS AfC: Band 7

Main area
Corporate Services
Grade
NHS AfC: Band 7
Contract
Permanent
Hours
Full time - 37.5 hours per week (flexi time between 8am and 6pm. Core hours between 10-12 and 2-4)
Job ref
350-COR3016152
Site
V7 Building
Town
Prescot
Salary
£38,890 - £44,503 Dependant on experience
Salary period
Yearly
Closing
15/04/2021 23:59

Mersey Care NHS Foundation Trust provides specialist inpatient and community mental health, learning disabilities, addiction and acquired brain injury services for the people of Liverpool, Sefton and Kirkby, Merseyside. We also provide community physical health services in Liverpool, Sefton, secure mental health services for the North West of England, the West Midlands and Wales and specialist learning disability services across Lancashire, Greater Manchester, Cheshire and Merseyside.

We work closely with service users, carers and partner organisations; we have been able to make real improvements to our diverse range of services, from health and social care, right through to high secure provision. This passion to improve has been recognised by the CQC who have recently rated us “Good”.

Mersey Care’s vision and values of Continuous Improvement, Accountability, Respect, Enthusiasm and Support (CARES) drive our organisation and the way we work together to deliver services. Applicants will be expected to demonstrate, during recruitment and any subsequent employment with the Trust, that their behaviour supports our values.

The CQC stated “It was clear that most staff across the organisation understood, and were committed to, the vision and values of the organisation. These were well communicated and the work to win both hearts and minds was apparent”.

We take positive action to support disadvantaged groups and also particularly encourage applications from BAME, disabled and LGBT people that are under-represented in our workforce. Furthermore we welcome applications from reservists and ex-armed forces as we recognise the benefits of the values, skills, training and experience that they bring to their work with us. We encourage all applicants to share their equality information with us.

Flexible working requests will be considered for all roles.

Job overview

An exciting opportunity has arisen to work within the Business Intelligence department at Mersey Care NHS FT. The successful candidate will utilise the full Microsoft BI stack and Power BI visualisation tools to deliver reporting for customers within and external to the Trust.

Shortlisting is planned for: 16th April 2021

Interviews are planned for: 23rd April 2021

Main duties of the job

Excellent skills in SQL Server Integration Services (SSIS) & SQL Server Reporting Services (SSRS) are essential to be able to deliver the Trust's self service online portal and to integrate multiple data sources into the Trust's data warehouse solution. Any experience of Power BI would be beneficial.

Working for our organisation

Mersey Care NHS Foundation Trust provides specialist inpatient and community mental health, learning disabilities, addiction and acquired brain injury services for the people of Liverpool, Sefton and Kirkby, Merseyside. We also provide community physical health services in Liverpool, Sefton, secure mental health services for the North West of England, the West
Midlands and Wales and specialist learning disability services across Lancashire, Greater Manchester, Cheshire and Merseyside.


Our ambition is to deliver perfect care to become the world’s leading organisation in holistic health and well being.


Mersey Care’s vision and values of Continuous Improvement, Accountability, Respect, Enthusiasm and Support (CARES) drive our organisation and the way we work together to deliver services. Applicants will be expected to demonstrate, during recruitment and any subsequent employment with the Trust, that their behaviour supports our values.

Detailed job description and main responsibilities

Job Outcomes:

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 and Enthusiasm 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.

 

Principal Responsibilities:

  1. Work with teams to understand their data requirements and develop online reports and olap cubes that meet their needs.
  2. Work with the Systems and Data Architect to integrate data from Trust systems into the Trust data warehouse
  3. Develop the Trust ETL to deliver efficiencies in processing
  4. Create and produce reports on the Trust’s Executive Information System so as to provide high quality, accurate and timely information to assist decision making and support service provision within the Trust. This will enable monitoring of the Trust’s performance by its staff and Commissioners.
  5. Update the logical data model to reflect changes in Trust systems
  6. Update the physical data model under guidance from the Systems and Data Architect
  7. Provide an intelligence function to the wider Trust, encompassing triangulation of data from multiple systems into meaningful information
  8. Provide modelling expertise to areas of the Trust looking to redevelop pathways
  9. Develop new visualisations that allow greater insight into Trust services utilising new technologies, software and latest thinking around visualisation
  10. Provide a benchmarking function for all aspects of Trust services
  11. Support teams in the extraction and analysis of data.
  12. Manage, mentor and coach staff
  13. Manage the completion and submission of aggregate statutory returns and information to support audits etc.
  14. Provide information on request to key stakeholders, and in line with Freedom of Information requirements.
  15. Ensure that all information is of a high standard so as to accurately reflect performance and progress against standards and targets and to highlight any data quality issues to the Solutions and Data Architect.
  16. Design automated aggregate performance reporting that allows ward to board vision and deliver products to underpin the Trust strategy, enforcing version control throughout.
  17. Develop processes so as to provide assurances to the Trust Board on performance.
  18. Work closely with the Trust’s teams and divisions, participating in quality and business meetings and ensuring that any information issues are fed back.
  19. Lead on 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.
  20. Liaise with outside agencies, e.g. CCGs, TDA, CQC, Auditors etc. leading on submissions, adhoc reporting and queries.
  21. Act as the first line of support for queries around the interpretation of information, targets and trends within the Trust’s performance reports.
  22. 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.
  23. Lead and develop on the production of information to support business planning and business development.
  24. 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.
  25. Develop bespoke reports to enable analysis to improve practice.
  26. Attend internal and external meetings when required as representative for the Informatics and Performance Improvement directorate.
  27. Create and implement procedures and processes to promote the accuracy of information produced and the maintenance of high standards within the Performance Team.

Generic Responsibilities for all staff:

All post holders will agree to:

  • Commit to the vision of supporting Mersey Care in becoming a leading organisation in the provision of mental health care, addiction services and learning disability care, and in doing so fully utilise their skills and experience to support the objectives of the Trust.
  • Role model the values of the Trust – Continuous Improvement, Accountability, Respectfulness and Enthusiasm – in all activities and interactions with employees, service users and other stakeholders
  • Challenge the stigma associated with mental health and learning difficulties.
  • Comply with the Duty of Candour, defined by Francis as: 'The volunteering of all relevant information to persons who have or may have been harmed by the provision of services, whether or not the information has been requested and whether or not a complaint or a report about that provision has been made.’
  • Work across professional and organisational boundaries to improve services for all.
  • Maintain their specific knowledge base and develop new skills.
  • Value the contribution of the patient / service user voice.
  • Operate within any organisational codes of practice or those from a relevant professional body.
  • Respect equality and diversity across all areas of working practice and communications with staff, service users and other stakeholders.
  • Take responsibility for the accurate and timely collection and recording of data and ensuring all personally identifiable information is protected and used only for the purposes for which it was intended.
  • Comply with all health and safety legislation and local policies and procedures.
  • Adhere to all organisational policies.

Person specification

Experience

Essential criteria
  • Working with information systems in large organisations
  • Utilising system schemas to deliver reporting solutions
  • Creating intelligence from data from multiple systems
  • Using SQL
  • Utilising Visualisation Software
Desirable criteria
  • Experience of managing staff
  • Experience of database administration

Knowledge

Essential criteria
  • Degree in computer science or related subject or experience
  • Knowledge of Visualisation Software
  • Knowledge of SQL based ETL processes
  • Expert knowledge of relational databases
  • Knowledge of data models
Desirable criteria
  • Knowledge of Mental health Information
  • Knowledge of NHS Data Manual
  • Knowledge and experience of sharepoint

Values

Essential criteria
  • Continuous Improvement
  • Respectfulness
  • Enthusiasm
  • Strong Customer Service Belief

Skills

Essential criteria
  • Able to work with large amounts of complex data and produce clear information
  • Excellent Attention to Detail
  • Concentration
  • Ability to interpret national policy and standards
  • Good communication skills
  • Able to work on own initiative
  • Flexible and adaptable to change
  • Good team working skills
Armed Forces CovenantVeteran AwareApprenticeships logoNo smoking policyPositive about disabled peopleMindful employer.  Being positive about mental health.Disability confident employerCare quality commission - GoodArmed Forces Covenant (Silver Award)CTP The Ministry of Defence partnering with Right ManagementStep into health

Documents to download

Apply online now

Further details / informal visits contact

Name
Steven Foster
Job title
Head of Business Intelligence
Email address
steven.foster@merseycare.nhs.uk
Telephone number
0151 472 4032