Job Summary
This role is critical in supporting the Organisation data infrastructure, enabling high-quality reporting, analytics, and data-driven decision-making to improve patient care and operational efficiency.
The post holder will be responsible for supporting for the design, development, and maintenance of the Trust data warehouse and associated reporting systems. They will work closely with clinical, operational, IT and BI colleagues to ensure data solutions meet the evolving needs of the organisation, including statutory reporting, service planning, and performance monitoring.
This role requires a strong understanding of data architecture, ETL processes, and business intelligence tools, along with a commitment to data quality, security, and governance. The successful candidate will play a key role in supporting the organisation’s digital transformation and strategic goals through innovative data solutions.
Role subject to job matching
Main duties of the job
- Support the day-to-day management and continuous development of the data warehouse and its associated systems, ensuring they are robust, scalable, and aligned with the evolving needs of the organisation.
- Proactively identify, manage, and deliver development projects to enhance the functionality, performance, and usability of the data warehouse and reporting infrastructure.
- Maintain and validate data systems to ensure they remain accurate, reliable, and compliant with national and local information governance standards, including statutory and regulatory reporting requirements.
- Stay abreast of emerging technologies and best practices in data warehousing, cloud platforms (e.g. Azure), and business intelligence, evaluating their relevance and applicability to the Trust’s needs.
- Commit to continuous professional development, including formal training, peer learning, and self-directed study, to keep pace with technological advancements and evolving data practices.
- Apply insights from research and learning to introduce and refine data warehousing and reporting processes that support evidence-based clinical and operational decision-making, contributing to the Trust’s strategic goals.
- Operate within a structured development framework to deliver high-quality, maintainable, and secure data solutions that meet user requirements and organisational priorities.
Person Specification
Education / Qualifications
Essential
- Degree or equivalent and / or relevant technical experience
- Evidence of continuous professional development
Desirable
- Project management qualification
Experience
Essential
- Extensive experience in designing and managing systems and reporting frameworks and tools such as Tableau or Microsoft Power BI
- Extensive experience in informatics roles and functions.
- Experience with data modelling (star/snowflake schemas), indexing, and partitioning.
Desirable
- Experience/Involvement in development and implementation of patient based information systems
- Experience of line management and providing support to other colleagues
Knowledge
Essential
- Strong proficiency in T-SQL for writing complex queries, stored procedures, and performance tuning.
- Familiarity with Azure Data Factory for ETL/ELT processes.
- Understanding of the importance of data quality, confidentiality and security and Information Governance principles
- Knowledge of Power BI Service (workspaces, datasets, gateways)
Desirable
- Expertise in building and optimizing data models (DAX, Power Query/M)
- Experience with Git-based version control
- Understanding of the current key targets for the NHS
Skills
Essential
- Well-developed interpersonal, communication, negotiation and influencing skills, with the ability to develop and manage positive relationships with a range of stakeholders
- Maintains own personal and professional development and supports the development of others
- Able to work under pressure and meet deadlines, dealing with changing and sometimes conflicting priorities
- Experience of implementing internal processes and procedures
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.
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
Closing Date: 09 September 2025
