Job summary
This is a brilliant opportunity for a motivated data engineer to take the next step in their career whilst supporting critical workstreams. If you are someone with the drive to improve patient outcomes, with the desire and aptitude to implement technical initiatives then this role is perfect for you.
This role will be supporting the work on combining the current DHCW Enterprise Data Warehouse (EDW) with the National Data Resource using Google Cloud technology. Full training will be provided.
The ideal candidate will combine a blend of strong team skills with technical flair in developing and coordinating key data flows into the new environment, to support new and existing critical workstreams.
The ideal candidate will be well-versed in Health and Care data, whilst demonstrating proficiency in database methodologies and the Structured Query Language (SQL), data modelling and ETL and Cloud technologies.
Depending on experience we may offer the post as a Band 5 Data Engineer. If appointed as a Data Engineer, progression to the next pay band is dependent on meeting an agreed set of competency criteria managed through Personal Development Review (PDR). Once those criteria are met you will automatically progress to a Band 6.
Main duties of the job
Experience of working of the NHS and clinical knowledge would be advantageous, however practical experience and knowledge of the following would be particularly desirable:
- SQL proficiency
- The ability to build comprehensive Extract, Transform and Load (ETL) routines
- Managing Stakeholder requirements, expectations
- Delivering technically innovative solutions in a timely manner
- Comprehensive documentation skills
- A champion of Data Warehouse methodologies and best-practice.
- Problem solving ability
- Proficient communication ability (verbal and written)
The ability to speak Welsh is desirable for this post; English and/or Welsh speakers are equally welcome to apply.
About us
Digital Health and Care Wales (DHCW) is part of the NHS Wales family and has an important role in changing the way health and care services are delivered through technology and data. The organisation supports frontline staff with modern systems and access to important information about their patients, while empowering the people of Wales to manage their own health through digital NHS Wales services.
Working for DHCW offers lots of employee benefits, including flexible working, a competitive salary, 28 days of annual leave plus Bank Holidays and opportunities for career development. We are committed to recognising and celebrating our staff as the most valuable part of our organisation.
Join our game changing, life-saving team and start making a real difference to health and care services in Wales.
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.
We welcome informal enquires to discuss any aspect of the role.
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.
We welcome informal enquires to discuss any aspect of the role.
Person Specification
Qualifications and/or Knowledge
Essential
- Relevant degree qualification or equivalent work experience.
- Evidence of continued professional development.
- Expert knowledge of SQL Server.
Desirable
- Knowledge of NHS information flows.
- Knowledge of Google Cloud/Big Query
Experience
Essential
- Experience of creating and maintaining objects in SQL Server.
- Experience of complex querying in SQL.
- Experience of creating and maintaining SSIS packages
- Experience of providing training to staff in the uses of information.
- Proven attention to detail and ability to produce complete and accurate information.
- Advanced experience of data manipulation
Desirable
- NHS experience, preferably within an Information environment
Aptitude and Abilities
Essential
- Proven experience of problem solving.
- Proven experience of programmable code.
- Proven ability to understand and comply with detailed procedures.
- Proven ability to work under pressure and manage deadlines and conflicting priorities.
- Excellent planning and organisational skills.
- Ability to deal with people at all levels.
- Ability to work well in a team and be supportive of team members
- Ability to work on own initiative, receiving broad guidance and expectations but determining own methodology for achievement of objectives.
- Motivated, keen to learn and eager to succeed.
- Analytical thinker.
Desirable
- Ability to Speak Welsh to Level 1
Person Specification
Qualifications and/or Knowledge
Essential
- Relevant degree qualification or equivalent work experience.
- Evidence of continued professional development.
- Expert knowledge of SQL Server.
Desirable
- Knowledge of NHS information flows.
- Knowledge of Google Cloud/Big Query
Experience
Essential
- Experience of creating and maintaining objects in SQL Server.
- Experience of complex querying in SQL.
- Experience of creating and maintaining SSIS packages
- Experience of providing training to staff in the uses of information.
- Proven attention to detail and ability to produce complete and accurate information.
- Advanced experience of data manipulation
Desirable
- NHS experience, preferably within an Information environment
Aptitude and Abilities
Essential
- Proven experience of problem solving.
- Proven experience of programmable code.
- Proven ability to understand and comply with detailed procedures.
- Proven ability to work under pressure and manage deadlines and conflicting priorities.
- Excellent planning and organisational skills.
- Ability to deal with people at all levels.
- Ability to work well in a team and be supportive of team members
- Ability to work on own initiative, receiving broad guidance and expectations but determining own methodology for achievement of objectives.
- Motivated, keen to learn and eager to succeed.
- Analytical thinker.
Desirable
- Ability to Speak Welsh to Level 1
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).
