Data Engineer

Betsi Cadwaladr University Health Board

Information:

This job is now closed

Job summary

Betsi Cadwaladr LHB has a vacancy for a Data Engineer in the Information Development Team of the Data, Intelligence and Insight Department.

The team has responsibility for the design and maintenance of the organisation's data warehouse; its products and processes, delivery platform and all applications relating to the acquisition, maintenance and presentation of data. These information products support the organisation to strategically and operationally manage health services across North Wales.

The following are therefore essential:

Knowledge of data warehousing concepts and techniques

SQL skills

Experience of ETL processes

Knowledge of database design and the Microsoft SQL Server platform

Experience of designing/writing/supporting SSRS and PowerBI reports

Understanding of the importance of thorough testing

NHS experience or a background in working with healthcare data would be beneficial.

Candidates are required to attend a face to face interview at Abergele Hospital, working from home is supported, however, it is essential the applicant is able to regularly attend one of the 3 main offices (Wrexham, Abergele or Bangor).

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

Main duties of the job

Betsi Cadwaladr LHB has a vacancy for a Data Engineer in the Information Development Team of the Data, Intelligence and Insight Department.

The team has responsibility for the design and maintenance of the organisation's data warehouse; its products and processes, delivery platform and all applications relating to the acquisition, maintenance and presentation of data. These information products support the organisation to strategically and operationally manage health services across North Wales.

The following are therefore essential:

  • Knowledge of data warehousing concepts and techniques
  • SQL skills
  • Experience of ETL processes
  • Knowledge of database design and the Microsoft SQL Server platform
  • Experience of designing/writing/supporting SSRS and PowerBI reports
  • Understanding of the importance of thorough testing

NHS experience or a background in working with healthcare data would be beneficial.

Candidates are required to attend a face to face interview at Abergele Hospital, working from home is supported, however, it is essential the applicant is able to regularly attend one of the 3 main offices (Wrexham, Abergele or Bangor).

If this role sounds right for you we would encourage you to get in touch. In the first instance please contact:martin.parry2@wales.nhs.uk

michelle.mabbs@wales.nhs.uk

About us

If you relish a challenge, have a passion to help others or simply fancy a fresh start, then Betsi Cadwaladr University Health Board (BCUHB) North Wales, has all the right ingredients. The largest health organisation in Wales, providing a full range of primary, community, mental health, acute and elective hospital services for a population of around 700,000, across North Wales . Join our team and get the support you need, in line with our Organisational Values and 'Proud to Lead' competence framework.

Enjoy being part of working with engaged leadership at all levels, and be assured we are committed to promoting equality and diversity, and are proud to welcome applicants under the "Disability Confident Employer" scheme.

Please check your email account regularly. Successful applicants will receive all recruitment related correspondence via the email account registered on the application form.

Applications may be submitted in Welsh. Applications submitted in Welsh will not be treated less favourably than an application submitted in English.

Date posted

17 May 2023

Pay scheme

Agenda for change

Band

Band 5

Salary

£27,461 to £33,428 a year Per Annum

Contract

Permanent

Working pattern

Full-time, Home or remote working

Reference number

050-AC397-0523

Job locations

Bangor - Abergele - Wrexham

Abergele

LL22 8DP


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

Qualifications

Essential

  • Bachelor's degree in Science, Technology or a Maths subject or equivalent qualifications, knowledge or experience.
  • Proven experience in data engineering or similar in a development environment. Good knowledge of relational database systems and activities such as writing SQL scripts and/or stored procedures. Evidence of experience with Windows PC and server operating systems

Desirable

  • Foundation qualification in an agile development methodology (for example the BCS Foundation Agile)
  • Experience developing APIs / software for Clinical Information or Healthcare systems. Experience of working in an Agile Development environment (e.g. Scrum)
  • Ability to speak Welsh
  • Understands the Data Protection Act and its implications

Aptitude and Abilities

Essential

  • Ability to learn new technologies, programming languages and IT systems through both self-study and professional courses.
Person Specification

Qualifications

Essential

  • Bachelor's degree in Science, Technology or a Maths subject or equivalent qualifications, knowledge or experience.
  • Proven experience in data engineering or similar in a development environment. Good knowledge of relational database systems and activities such as writing SQL scripts and/or stored procedures. Evidence of experience with Windows PC and server operating systems

Desirable

  • Foundation qualification in an agile development methodology (for example the BCS Foundation Agile)
  • Experience developing APIs / software for Clinical Information or Healthcare systems. Experience of working in an Agile Development environment (e.g. Scrum)
  • Ability to speak Welsh
  • Understands the Data Protection Act and its implications

Aptitude and Abilities

Essential

  • Ability to learn new technologies, programming languages and IT systems through both self-study and professional courses.

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.

Certificate of Sponsorship

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

Certificate of Sponsorship

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).

Employer details

Employer name

Betsi Cadwaladr University Health Board

Address

Bangor - Abergele - Wrexham

Abergele

LL22 8DP


Employer's website

https://bcuhb.nhs.wales/train-work-live/ (Opens in a new tab)

Employer details

Employer name

Betsi Cadwaladr University Health Board

Address

Bangor - Abergele - Wrexham

Abergele

LL22 8DP


Employer's website

https://bcuhb.nhs.wales/train-work-live/ (Opens in a new tab)

For questions about the job, contact:

Senior Development Analyst

Michelle Mabbs

michelle.mabbs@wales.nhs.uk

03000850580

Date posted

17 May 2023

Pay scheme

Agenda for change

Band

Band 5

Salary

£27,461 to £33,428 a year Per Annum

Contract

Permanent

Working pattern

Full-time, Home or remote working

Reference number

050-AC397-0523

Job locations

Bangor - Abergele - Wrexham

Abergele

LL22 8DP


Supporting documents

Privacy notice

Betsi Cadwaladr University Health Board's privacy notice (opens in a new tab)