Job summary
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 of Business Intelligence tools 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, 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.
About us
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,
- 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?
Job description
Job 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
Job description
Job 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
Person Specification
Other
Desirable
- Welsh Speaker (Level 1) or willingness to work towards
Qualifications and Knowledge
Essential
- 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
Desirable
- Service improvement qualification
- Experience of working with Workforce data
Experience
Essential
- 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
Essential
- Ability to interpret highly complex informatics concepts
- Practical knowledge of Data Warehousing, relational Databases, and information systems
- Excellent verbal, written & presentation skills
- 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
Person Specification
Other
Desirable
- Welsh Speaker (Level 1) or willingness to work towards
Qualifications and Knowledge
Essential
- 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
Desirable
- Service improvement qualification
- Experience of working with Workforce data
Experience
Essential
- 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
Essential
- Ability to interpret highly complex informatics concepts
- Practical knowledge of Data Warehousing, relational Databases, and information systems
- Excellent verbal, written & presentation skills
- 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
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).
Additional information
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).
