Crynodeb o'r swydd
- Prif leoliad
- IM&T
- Gradd
- Band 7
- Contract
- Parhaol
- Oriau
- Llawnamser - 37.5 awr yr wythnos (Hybrid working)
- Cyfeirnod y swydd
- 350-TWS7307119
- Cyflogwr
- Mersey Care NHS Foundation Trust
- Math o gyflogwr
- NHS
- Gwefan
- Hollins park house, Hollins Park
- Tref
- Winwick
- Cyflog
- £47,810 - £54,710 per annum
- Cyfnod cyflog
- Yn flynyddol
- Yn cau
- 13/08/2025 23:59
- Dyddiad y cyfweliad
- 11/09/2025
Teitl cyflogwr
Senior Report Builder and Data Specialist
Band 7
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Mersey Care NHS Foundation Trust celebrates diversity and promotes equal opportunities; we are committed to challenging and eliminating racism and other forms of discrimination and advancing and promoting equality of opportunity in the provision of services and creating an inclusive environment for all employees. We believe that everyone has the right to be treated with dignity and respect.
We take positive action to support disadvantaged groups and also particularly encourage applications from ethnically diverse, disabled and LGBTQIA+ people that are under-represented in our workforce. Furthermore we welcome applications from reservists and ex-armed forces personnel 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.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Trosolwg o'r swydd
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.
Prif ddyletswyddau'r swydd
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!
Gweithio i'n sefydliad
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.
Swydd-ddisgrifiad a phrif gyfrifoldebau manwl
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.
Manyleb y person
Values
Meini prawf hanfodol
- Continuous Improvement
- Accountability
- Respectfulness
- Enthusiasm
- Responsive to service users
- Engaging leadership style
- Strong customer service belief
- Transparency and honesty
- Discrete
Skills
Meini prawf hanfodol
- Able to work with large amounts of complex data and produce figures in a clear, accurate and meaningful manner
- Excellent attention to detail and ability to spot anomalies in data
- Able to analyse data and trends in order to draw conclusions and assist decision-making
- Able to integrate thinking to encompass multiple systems and data sources to deliver intelligence
- Able to concentrate over long periods of time, while also being able to deal with interruptions
- Ability to interpret national policy and standards and apply them locally
- Strong customer service skills with a willingness to adapt own priorities to meet their needs
- Good communication skills and approachable manner
- Able to work on own initiative
- Able to deal with all information in a highly confidential manner
- Able to cope with information that may at times be of a distressing and highly sensitive nature
- Flexible and adaptable to change
- Able to work under pressure and to agreed timescales
- Good team-working skills
- Able to liaise with staff at all levels of the organisation in order to develop or adapt reporting requirements and to ensure Information Systems used correctly
Experience
Meini prawf hanfodol
- Working with Information Systems in large organisations
- Providing statutory reports to external agencies
- Utilising system schemas to deliver reporting solutions
- Creating intelligence from data from multiple systems
- Writing query language scripts to manipulate and display data
- Experience of developing reports in visualisation software
- Experience of designing and implementing OLAP cubes
- Experience of integrating data from multiple systems into a data repository
Meini prawf dymunol
- Experience of managing staff
- Experience of software to version control script production
- Experience of data discovery work to aid services in decision making
- Experience of database administration
Knowledge
Meini prawf hanfodol
- Degree in computer science or related subject
- Highly numerate with minimum A-level in numerate subject
- Knowledge of software data flows
- Knowledge of visualisation software
- Knowledge of SQL based ETL processes
- Advanced knowledge and experience of using Microsoft Office
- Advanced knowledge of relational databases and associated software
- Knowledge of logical or physical data models
Meini prawf dymunol
- Member of ASSIST or UKCHIP
- Microsoft Certifications
- Knowledge of Mental Health Information
- Knowledge of Performance Management systems
- Knowledge of the NHS Data Manual
- Member of North West Leadership Mentoring scheme or equivalent
- Knowledge and experience of SharePoint
Bathodynnau ardystio / achredu cyflogwyr
Dogfennau i'w lawrlwytho
Rhagor o fanylion / cyswllt ar gyfer ymweliadau anffurfiol
- Enw
- Steven Foster
- Teitl y swydd
- Head of BI
- Cyfeiriad ebost
- [email protected]
Rhestr swyddi gyda Mersey Care NHS Foundation Trust yn Gwasanaethau Gweinyddol neu bob sector