Senior Report Builder and Data Specialist | Mersey Care NHS Foundation Trust
| Posting date: | 21 July 2025 |
|---|---|
| Salary: | Not specified |
| Additional salary information: | £47,810 - £54,710 per annum |
| Hours: | Full time |
| Closing date: | 20 August 2025 |
| Location: | Winwick, WA2 8WA |
| Company: | Mersey Care NHS Foundation Trust |
| Job type: | Permanent |
| Job reference: | 7307119/350-TWS7307119 |
Summary
Are you passionate about transforming data into actionable insights? Do you thrive in a dynamic environment where your skills in data engineering and data visualisation can make a real difference? If so, we have an exciting opportunity for you.
As a Senior Report Builder and Data Specialist within the Trust, you will play a pivotal role in harnessing the power of data to drive decision-making and improve patient outcomes. You will work with cutting-edge data engineering and visualisation technologies to analyse complex datasets and present your findings in a clear, impactful manner.
We will enhance your existing skills in tools such as SQL or Python and develop your cloud skills in our Microsoft Azure Data Lakehouse.
If you are ready to take on this challenge and grow your career in a supportive and innovative environment we would love to hear from you!
Mersey Care is one of the largest trusts providing physical health and mental health services in the North West, serving more than 1.4 million people across our region and are also commissioned for services that cover the North West, North Wales and the Midlands.
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.
Flexible working requests will be considered for all roles.
Please see the attached Job Description document.
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
1. Provide a benchmarking function for all aspects of Trust services
1. Support teams in the extraction and analysis of data.
1. Manage, mentor and coach staff
1. Manage the completion and submission of aggregate statutory returns and information to support audits etc.
1. Provide information on request to key stakeholders, and in line with Freedom of Information requirements.
1. 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.
1. Design automated aggregate performance reporting that allows ward to board vision and deliver products to underpin the Trust strategy, enforcing version control throughout.
1. Develop processes so as to provide assurances to the Trust Board on performance.
1. Work closely with the Trust’s teams and divisions, participating in quality and business meetings and ensuring that any information issues are fed back.
1. 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.
2. Liaise with outside agencies, e.g. CCGs, TDA, CQC, Auditors etc. leading on submissions, adhoc reporting and queries.
2. Act as the first line of support for queries around the interpretation of information, targets and trends within the Trust’s performance reports.
2. 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.
2. Lead and develop on the production of information to support business planning and business development.
This advert closes on Wednesday 13 Aug 2025