# Data Warehouse Manager > NHS job listing from Job Clerk for Health Education and Improvement Wales. ## Canonical URLs - **HTML:** https://www.jobclerk.com/job/data-warehouse-manager/62e420b0-6ceb-417f-b7f4-e8db709db7d2 - **Markdown:** https://www.jobclerk.com/job/data-warehouse-manager/62e420b0-6ceb-417f-b7f4-e8db709db7d2.md ## Summary - **Status:** Live - **Employer:** Health Education and Improvement Wales - **Location:** Cardiff - **Profession:** Administrative and IT - **Salary:** £50129.00 to £57365.00 - **Contract type:** Permanent - **Employment type:** Full time, Flexible working, 37.5 hours per week (An agile working model to allow flexibility between home and office-based working.) - **Closing date:** 2026-08-20T23:59:00.000Z - **Posted:** 2026-08-07T09:26:58.440Z - **Source information URL:** https://www.healthjobsuk.com/job/-v8153633 - **Application URL:** https://apps.trac.jobs/job-advert/8153633?ShowJobAdvert=&feedid=9002 - **Employer website:** https://heiw.nhs.wales/ ## Job Content ### Job overview The Data Warehouse Manager is responsible for leading the design, implementation, management and continuous development of HEIW's workforce data warehouse, providing a robust, secure and high-quality information platform to support workforce planning, strategic decision-making and organisational performance. The post holder will act as the organisation's expert in SQL database architecture, data warehousing and workforce modelling, ensuring the effective integration, governance and analysis of complex workforce data from multiple internal and external sources. Working collaboratively with stakeholders across HEIW, NHS Wales, Welsh Government and partner organisations, they will develop innovative data solutions and workforce data models, ensuring compliance with data governance and GDPR requirements. The role also provides leadership for the Data Warehouse team, driving continuous improvement in data quality, reporting, system development and analytical capability while supporting the delivery of national workforce intelligence and organisational performance objectives. ### Main duties of the job The post holder 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. The ability to speak Welsh is desirable for this post; Welsh and/or English speakers are equally welcome to apply. ### Detailed job description and main responsibilities 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. ### Applicant requirements Welsh language skills are desirable ## Person Specification ### 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 ### 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 ## Documents - [llyfryn heiw (pdf, 1.5mb)](https://www.healthjobsuk.com/documents?edoc=3002) - [heiw brochure (pdf, 1.6mb)](https://www.healthjobsuk.com/documents?edoc=3001) - [jdps english (pdf, 259.5kb)](https://www.healthjobsuk.com/documents?vdoc=10521614) - [sdmp cymraeg (pdf, 264.7kb)](https://www.healthjobsuk.com/documents?vdoc=10521615) - [privacy notice (pdf, 404.2kb)](https://www.healthjobsuk.com/documents?edoc=2352) - [oh form - ig ffurflen (docx, 101.3kb)](https://www.healthjobsuk.com/documents?vdoc=10521585) - [guidance notes for applicants (pdf, 322.5kb)](https://www.healthjobsuk.com/documents?edoc=2847) ## Agent Notes - This Markdown page is generated from the same Job Clerk job record as the HTML job detail page. - Use the canonical HTML URL for user-facing references. - Use the application URL when the user wants to apply on the source NHS site.