Data Warehouse Manager
Health Education and Improvement Wales
Cardiff, CF15 7QQView on map(opens Google Maps in a new tab)
Salary
£50,129 to £57,365
Contract
Permanent
Hours
Not specified
Closing date
29 October 2026
9 days leftJob description
The Data Warehouse Manager is responsible for leading the design, implementation, management and continuous development of HEIW's workforce data wareh...
You will lead the design, development, implementation and management of HEIW's workforce data warehouse, ensuring the delivery of a secure, reliable and scalable platform to support workforce planning, operational delivery and strategic decision-making across NHS Wales. They will be responsible for the development and maintenance of SQL database solutions, including database architecture, complex queries, data integration processes, reporting interfaces and the migration of existing on-premises SQL solutions to Azure cloud-based architecture.
The post holder will ensure effective data governance, quality and compliance with GDPR, information governance standards and data-sharing agreements, integrating workforce data from multiple sources including the ESR Data Warehouse and external datasets. They will provide expert analysis, develop workforce intelligence products, dashboards and reports, and apply advanced analytical techniques and workforce modelling methodologies to support forecasting, scenario planning and strategic workforce planning.
Working collaboratively with stakeholders across HEIW, NHS Wales, Welsh Government and partner organisations, the post holder will provide specialist advice, improve data capability and lead innovation in data analysis and visualisation. They will also provide leadership and direction to the Data Warehouse team, supporting staff development, continuous improvement and the effective delivery of workforce information services.
You will be able to find a full Job description and Person Specification attached within the supporting documents or please click Apply now to view in Trac.
The ability to speak Welsh is desirable for this post; Welsh and/or English speakers are equally welcome to apply.
Health Education and Improvement Wales (HEIW) is the strategic workforce body for NHS Wales with statutory functions that include education and training, workforce planning, workforce development and transformation, leadership and succession planning, and careers. Our purpose is to develop a workforce that delivers excellent care to patients/service users and excellent population health. We are a Special Health Authority working closely with our partners; Social Care Wales, education providers, professional and regulatory bodies and Welsh Government.
HEIW's is committed to developing an internal culture of choice. Our Values reflect our thoughts, feelings and beliefs in how we will, and will not, behave and treat others:
- Respect for All in every contact we have with others
- Ideas that Improve: Harnessing creativity and continuously innovating, evaluating and improving
- Together as a Team: Working with colleagues across NHS Wales and with partner organisations.
HEIW received the HPMA Award for Employee Engagement in 2019.
- a corporate induction and 90 day Welcome itinerary
- compassionate leadership
- a meaningful values based performance appraisal process
- the opportunity to impact upon health and social care services and the lives and wellbeing of the people of Wales.
Many of our colleagues and stakeholders have commented on the buzz and atmosphere we create by working together as "One HEIW Team". Do you want to join that team?
Experience
Essential
- Data Warehouse Design
- Demonstrable success in building, leading, motivating, managing and developing teams.
- Excellent analytical, communication and presentation skills.
Desirable: - Azure and Cloud based technologies
Qualifications & Knowledge
Essential: - In-depth knowledge of MS SQL; - Knowledge and practical use of Microsoft Azure & Fabric; - Python
Desirable: - Prince 2 Foundation or equivalent
Skills
Essential
- Able to write high quality workforce reports and documentation for both technical and non-technical audiences.
- Ability to work autonomously, prioritise, meet deadlines and solve problems.
- Able to focus, concentrate and accurately complete tasks within given timeframes whilst dealing with unscheduled interruptions.
Desirable: - Welsh Language Skills
How to apply
Applications are handled entirely by the employer on the original advert. We do not collect CVs, supporting statements or application data.
Provenance
Source
NHS Jobs
First seen
16 October 2026
Last checked
20 October 2026
Salary, closing date and description are taken from the employer's advert. The original advert always takes precedence.
About the employer
NHS organisation
This listing was structured from NHS Jobs. Vacancy details and the application process remain the responsibility of the original source.
Explore related