This job has expired

Senior Data Warehouse Developer PLICS Data

Mersey Care NHS Foundation Trust
£41,659 to £47,672 a year per annum
Closing date
7 Jun 2023

View more

Other Health Profession
Band 7
Contract Type
Full Time
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 to create data loads for patient level costing systems and deliver reporting for customers within and external to the Trust.

Previous applicants need not apply

Shortlisting date is planned for 8th June 2023

Interview date is planned for 15th June 2023

Main duties of the job

The post-holder will be working within the Trust's Business Intelligence team and will liaise with the Finance team to lead on the technical aspects of the Trust's Patient Level Information and Costing System (PLICS) feeds.

The role will include technical solution design, technical documentation, implementation and maintenance.

The role will create automated feeds from Trust systems into and out of costing systems utilising the latest technologies in the Trust's data warehousing platforms.

The role will develop visualisations including dashboards, balanced score cards and reporting suites using the latest visualisation software available to the Trust. These reports will service the needs of Executive teams, Divisions and Directors to support the development of the Trust's Strategy and Financial Planning.

A key function will be to work with the Head of Costing to deliver activity information to feed into NHSI Costing Returns in line with the National Costs Collection framework.

About us

Mersey Care is one of the largest trusts providing physical health 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

Principal Responsibilities:
  • Work with teams to understand their data requirements and develop online reports and olap cubes that meet their needs.
  • Work with the Systems and Data Architect to integrate data from Trust systems into the Trust data warehouse
  • Develop the Trust ETL to deliver efficiencies in processing
  • Create and produce reports on the Trusts 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 Trusts performance by its staff and Commissioners.
  • Update the logical data model to reflect changes in Trust systems
  • Update the physical data model under guidance from the Systems and Data Architect
  • Provide an intelligence function to the wider Trust, encompassing triangulation of data from multiple systems into meaningful information
  • Provide modelling expertise to areas of the Trust looking to redevelop pathways
  • Develop new visualisations that allow greater insight into Trust services utilising new technologies, software and latest thinking around visualisation
  • Provide a benchmarking function for all aspects of Trust services
  • Support teams in the extraction and analysis of data.
  • Manage, mentor and coach staff
  • Manage the completion and submission of aggregate statutory returns and information to support audits etc.
  • Provide information on request to key stakeholders, and in line with Freedom of Information requirements.
  • 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.
  • Design automated aggregate performance reporting that allows ward to board vision and deliver products to underpin the Trust strategy, enforcing version control throughout.
  • Develop processes so as to provide assurances to the Trust Board on performance.
  • Work closely with the Trusts teams and divisions, participating in quality and business meetings and ensuring that any information issues are fed back.
  • 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.
  • Liaise with outside agencies, e.g. CCGs, TDA, CQC, Auditors etc. leading on submissions, adhoc reporting and queries.
  • Act as the first line of support for queries around the interpretation of information, targets and trends within the Trusts performance reports.
  • 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.
  • Lead and develop on the production of information to support business planning and business development.
  • 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.
  • Develop bespoke reports to enable analysis to improve practice.
  • Attend internal and external meetings when required as representative for the Informatics and Performance Improvement directorate.
  • Create and implement procedures and processes to promote the accuracy of information produced and the maintenance of high standards within the Performance Team.

  • Person Specification



    • 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


    • Experience of database administration



    • 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


    • Knowledge of Mental health Information
    • Knowledge of NHS Data Manual



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



    • 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

    Employer details

    Employer name

    Mersey Care NHS Foundation Trust


    Hollins Park House

    Hollins Lane, Winwick


    WA2 8WA

    Any attachments will be accessible after you click to apply.


    Get job alerts

    Create a job alert and receive personalised job recommendations straight to your inbox.

    Create alert