Senior Dashboard and Data Warehouse Developer

Health-Education-and-Improvement-Wales; Nantgarw; Hybrid; GBP 41,000 - 49,000; Full time

Benefits offered by this job

Flexible working

Job summary

Health Education and Improvement Wales seeks a Senior Dashboard and Data Warehouse Developer to lead the technical development of the HEIW Data Warehouse and reporting solutions. The role involves collaborating with the Analytics team to deliver data-driven insights across NHS Wales.

The post holder will use MS SQL, Azure, SSIS, Power BI and DAX to provide trusted data through a single version of the truth data platform, while ensuring data quality and stakeholder alignment.

Qualifications

• Proven experience with data warehousing and BI development.
• Strong knowledge of MS SQL, Power BI, DAX and reporting solutions.
• Experience delivering dashboards and BI content to provide business insights.

Responsibilities

• Develop and maintain the HEIW Data Warehouse and reporting solutions.
• Collaborate with stakeholders to scope and design BI content.
• Ensure data quality and standardisation across reports and dashboards.

Skills

MS SQL

Power BI

DAX

Data Warehousing

Python

Education

Degree in computing / informatics

Tools

SSIS

Azure

Job description

Main area Dashboard and Data Warehouse Developer Grade Band 6 Contract Permanent Hours 37.5 hours per week (An agile working model to allow flexibility between home and office-based working) Job ref 082-AC055-1026

• Full time
• Flexible working

Employer Health Education and Improvement Wales Employer type NHS Site Ty Dysgu Town Nantgarw Salary £40,559 - £48,841 per annum Salary period Yearly Closing 19/10/2026 23:59

Senior Dashboard and Data Warehouse Developer

Band 6

We are committed to promoting inclusion at HEIW and we welcome applications from everybody recognising the value that diversity brings to our workforce. To work in the UK, candidates who are not UK or Republic of Ireland (ROI) nationals require sponsorship via a Skilled Worker Visa, unless they have permission to work via another route. Please note that HEIW does not currently hold a licence to appoint skilled workers from overseas by sponsoring them to work in the UK. If successful, candidates from outside of the UK or ROI would be responsible for obtaining their own sponsorship or visa to enable them to work for HEIW - Work in the UK .

Job overview

Do you want to help shape the future workforce of the NHS in Wales? If so we have an exciting opportunity for a Senior Dashboard and Warehouse Developer to join our friendly and supportive Data and Analytics team within Health Education and Improvement Wales. We are a growing team with a wide remit providing analytical support both internally and externally across NHS Wales. Our mission is to empower NHS Wales to make better data driven decisions.

The postholder will be responsible for the technical development and maintenance of the HEIW Data Warehouse and reporting solutions. This will involve utilising all available technologies, for example, Power BI, Dax and MS SQL technologies to support seamless access to a wide range of informatics resources and reports via the Information Portal. The post holder will be required to work closely with stakeholders to scope, design and create content that answers key business questions and provide evidenced based business intelligence solutions using a single version of the truth data platform.

Main duties of the job

The postholder will be responsible for the development and delivery of HEIW Data Warehouse solution that will be the foundation for delivering operational insights for users within Health Education Improvement Wales and other stakeholders.

The post holder will work closely with the HEIW Analytics team and product owners to develop solutions for providing data from the data warehouse for dashboards which answer Key Business Questions and enable data driven decision making.

You will also be responsible for creating business intelligence solutions in accordance with standard operating procedures ensuring data standards and data quality elements as well as ongoing maintenance and review points lead to usable quality products.

You will need to have experience working within an information environment, interpreting highly complex informatics concepts alongside practical knowledge of Data Warehousing, Relational Databases, and information systems, alongside advanced IT and analytical and statistical skills and experience with knowledge of IT tools such as, MS SQL, Azure, Fabirc, SSIS, Power BI, DAX. Knowledge of working Python, R and APIs would also be desirable although not essential.

The ability to speak Welsh is desirable for this post; Welsh and/or English speakers are equally welcome to apply.

Working for our organisation

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.

What you can expect:

• a corporate induction and 90 day Welcome itinerary,
• 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?

Detailed job description and main responsibilities

Person specification

Other

• Welsh Speaker (Level 1) or willingness to work towards

Qualifications and Knowledge

• Degree in a relevant topic area (e.g., computing, informatics, mathematics) or equivalent experience
• Evidence of further development and or education and training
• Specialist knowledge of information requirements and standards within a healthcare /social care environment
• Experience of working with Workforce data

Experience

• Experience of working autonomously using own discretion
• Significant experience within an information environment
• Experience of working with multidisciplinary stakeholders.
• Knowledge of information requirements and standards within a healthcare and social care environment
• Previous experience of delivering projects within timescales.
• Advanced IT and analytical and statistical skills and experience with knowledge of IT tools such as, MS SQL, Power BI, DAX
• Experience of developing dashboards using e.g., Power BI

Skills and Attributes

• Ability to interpret highly complex informatics concepts
• Practical knowledge of Data Warehousing, relational Databases, and information systems
• Track record of delivering high quality work in demanding timescales
• Ability to develop and maintain effective team working and working relationships
• The ability to travel between sites in a timely manner

It is essential that your application demonstrates how you meet the job description / person specification for this post.

Employer certification / accreditation badges

Name Ian Baker Job title Data Warehouse and Architect Lead Email address [e-mail] Additional information

We would be delighted to hear from you and if you would like any further information or to have an informal chat, please contact [e-mail].