Job summary
An opportunity has arisen for a highly motivated and enthusiastic Senior Data Engineer to join the Business Intelligence team at an exciting time in the department.
We are currently going through a period of evolution where we are re-shaping how information services are delivered within the organisation by improving accessibility of data across the organisation and supporting the expansion of the Trust's research agenda. The successful candidate will be playing a key role in the review, development & improvement of data management as we strive to deliver a best-in-class BI service.
This role would suit someone with strong attention to detail, keen eye for data modelling, who can meticulously follow specifications and spot even the smallest data anomaly. You may also be a trailblazer who loves experimenting and finding fresh approaches to resolving data problems and establishing new best practice processes.
Main duties of the job
You will be using your advanced knowledge of data engineering to lead and contribute to transformation projects that will support our strategy of improving availability of data, transforming ETL/ELT processes, and optimising productivity wherever possible. You will also simultaneously provide continuity of service to support the wider BI and research teams and ultimately the performance of the Trust. We are looking for someone with great communication skills, which will be required to engage with colleagues in the BI team and beyond, define comprehensive specifications and structure data in an accessible and clear way. This diverse role will involve working with a wide variety of data sources, creating and maintaining ETL/ELT processes, maintaining data dictionaries, creating data flows, improving existing data structures, and creating complex research data sets.
We are looking for a self-motivated individual who will relish a challenge. Applicants should be able to demonstrate a strong understanding of data warehousing and be able to prioritise their own workload to ensure that deadlines are met and high standards are maintained. Experience of working with SQL Server tools is essential.
About us
Our benefits
We offer a range of benefits to support our staff including:
- Access to the NHS Pension Scheme, providing generous benefits upon retirement, as well as a lump sum and pension for dependants
- 27 days holiday rising to 33 days (depending on NHS Trust service)
- A variety of different types of paid and unpaid leave covering emergency and planned leave
- Confidential advice and support on personal, work, family and relationship issues, 24/7, from our Employee Assistance Programme
- NHS Car Lease scheme and Cycle to Work scheme
- An extensive range of learning and development opportunities
- Discounts on restaurants, getaways, shopping, motoring, cinema and finance from a range of providers
For further information on the fantastic range of benefits we offer please visit the Trust's dedicated Staff Benefits pages.
The NHS Staff Council has accepted the pay offer made by the government for Agenda for Change staff in England, which you will see is reflected on the salary for this role. Thenew salary rates for this year(2023/24)willtake effect from 1 April 2023. Eligible staff can expect to receive the additional 2022/23 payment and the new 2023/24 pay rates (including back pay to 1 April) as part of their pay in June.
Job description
Job responsibilities
A full description of the role is available in the attachment: job description.
Working for the Trust
Across our organisation, people are guided by values that were co-developed with staff: we are kind; we are open; and we pursue excellence.
Our values play into our ambition to develop a more diverse workforce, truly representative of our communities. We welcome applications from everyone, while working with our Staff Networks - including our Race Equality, LGBTQ+, Disability and Carers Networks - to increase the number of applications we receive from different backgrounds. If there is anything we can do to make our application process more accessible to you, please contact: yhs-tr.recruitment@nhs.net
As part of seeking to become more inclusive, we will consider requests for flexible working from the start of your employment. It may not be suitable for every role, but we will try and be supportive where we can. We would encourage you to speak to the recruiting manager named within this advert to discuss any requirements you may have.
Armed Forces Friendly Employer
We are holders of the Gold Award from the Defence Employer Recognition Scheme, which is helping actively promote SaBRE - Supporting Britains Reservists and Employers. This means that we have made a statement of intent to support all Defence personnel, including with applications for employment.
COVID-19 Vaccination Requirements
Our Trust continues to strongly encourage our staff to be vaccinated against COVID19, this remains our best defence to protect our patients, ourselves and everyone else.
Job description
Job responsibilities
A full description of the role is available in the attachment: job description.
Working for the Trust
Across our organisation, people are guided by values that were co-developed with staff: we are kind; we are open; and we pursue excellence.
Our values play into our ambition to develop a more diverse workforce, truly representative of our communities. We welcome applications from everyone, while working with our Staff Networks - including our Race Equality, LGBTQ+, Disability and Carers Networks - to increase the number of applications we receive from different backgrounds. If there is anything we can do to make our application process more accessible to you, please contact: yhs-tr.recruitment@nhs.net
As part of seeking to become more inclusive, we will consider requests for flexible working from the start of your employment. It may not be suitable for every role, but we will try and be supportive where we can. We would encourage you to speak to the recruiting manager named within this advert to discuss any requirements you may have.
Armed Forces Friendly Employer
We are holders of the Gold Award from the Defence Employer Recognition Scheme, which is helping actively promote SaBRE - Supporting Britains Reservists and Employers. This means that we have made a statement of intent to support all Defence personnel, including with applications for employment.
COVID-19 Vaccination Requirements
Our Trust continues to strongly encourage our staff to be vaccinated against COVID19, this remains our best defence to protect our patients, ourselves and everyone else.
Person Specification
Education, Qualifications and Training
Essential
- Educated to degree level or equivalent experience
- Ongoing professional development / qualifications e.g. relevant MS Certification, training courses, demonstrable experience
Experience and Knowledge
Essential
- Knowledge of managing large relational database schemas and models
- Knowledge of ETL/ELT processes, especially using SSIS
- Experience of designing & building data flows using Power BI
- Experience working on an enterprise level data warehouse
- MS SQL Server database (On premise and/or the cloud) skills including SQL Server Management Studio, T-SQL, SSIS packages, stored procedures, functions, indexing and query tuning.
- Knowledge across the Software Development Cycle.
Skills and Attributes
Essential
- Ability to contribute to the management and maintenance of a complex data warehouse
- Ability to analyse potential issues proactively, logically and systematically.
- Ability to work with the requestors of data to understand the underlying question and explain it to colleagues.
- Provide oversight and advice to more inexperienced members of the team.
- Understand how the data engineering standards, tools and technologies fit into the data arc
Person Specification
Education, Qualifications and Training
Essential
- Educated to degree level or equivalent experience
- Ongoing professional development / qualifications e.g. relevant MS Certification, training courses, demonstrable experience
Experience and Knowledge
Essential
- Knowledge of managing large relational database schemas and models
- Knowledge of ETL/ELT processes, especially using SSIS
- Experience of designing & building data flows using Power BI
- Experience working on an enterprise level data warehouse
- MS SQL Server database (On premise and/or the cloud) skills including SQL Server Management Studio, T-SQL, SSIS packages, stored procedures, functions, indexing and query tuning.
- Knowledge across the Software Development Cycle.
Skills and Attributes
Essential
- Ability to contribute to the management and maintenance of a complex data warehouse
- Ability to analyse potential issues proactively, logically and systematically.
- Ability to work with the requestors of data to understand the underlying question and explain it to colleagues.
- Provide oversight and advice to more inexperienced members of the team.
- Understand how the data engineering standards, tools and technologies fit into the data arc
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.
