Senior Data Engineer

Job summary

As a Senior Data Engineer, you will join a small team of Data Engineers, which compliment our wider disciplines in the Office of Data and Analytics, such as Business Intelligence, Analytics Engineering, Data Science and Insight functions.

We are embarking on a journey towards an EPR implementation (Electronic Patient Record), in addition to transitioning to modern architecture in Azure.

As a Senior Data Engineer, you will be pivotal to supporting us on this journey, aspiring to all our on prem architecture to be in the Azure platform. Regardless of your level of experience with Azure, this will provide you with the opportunity to continue your professional development in the Azure environment.

Our Data Engineering function is key to remodelling, developing and building our priority datasets in Azure to support our onward evolution of analytics and insights aligned to EPR.

Expert skills and experience in ETL processes is essential for this role, as is previous experience in an Informatics Department and NHS Data Warehousing.

Main duties of the job

Day to day, the Senior Data Engineer will be working on designing, developing, testing and deploying high priority datasets in our plan.

Debugging and problem solving complex technical issues under pressure is a daily occurrence, whilst balancing competing priorities.

You will design solutions, and conduct design review conversations with peers, and peer review work for other Data Engineers as part of closely aligned team.

You will be a good communicator in terms of progress of development, and provide progress updates of arising technical issues, assessing impact and bring to a resolution effectively without contributing to technical debt.

For further details, refer to the Job Description and Personal Specification.

About us

We are an acute trust caring for over one million people in Wakefield and Kirklees. Our 10,000 staff work in patients homes, the community, and our three hospitals in Pontefract, Dewsbury, and Pinderfields (Wakefield). We prioritise our people and values so we can deliver the best possible care to patients. Our team is friendly, passionate, and innovative, always seeking better ways to work. We support work-life balance and foster a diverse, inclusive environment where everyone belongs. Our staff networks offer safe spaces to share ideas and concerns so we can increase awareness and appreciation of equality, diversity, and inclusion. We welcome applicants from all backgrounds and especially encourage members of the LGBTQ+ community, ethnic minority groups, and people with disabilities or neurodivergence to apply, as they are currently underrepresented in the Trust. As a member of the team, you will have access to the NHS pension plan, a generous holiday allowance, employee health and wellbeing services and extensive benefits and support. These include onsite nurseries, childcare vouchers, home electronics schemes, working carers support, carer-friendly policies, and more. If you value caring, high standards, improvement, and respect, join the MY team to make a difference every day.

Job description

Job responsibilities

Essential person specification requirements

Qualifications:

  • Post grad qualification, or equivalent level of experience relevant to the post

Experience:

  • Highly experienced in full cycle of design, development, testing, and maintenance of complex technical ETL DW solutions
  • Design and development of dimensional and relational data models
  • Development across the MS SQL Server stack
  • Debugging, and resolving complex technical issues under pressure
  • Ability to ensure quality of development, creating repeatable test plans
  • Good communicator, with experience of translating non-technical requirements into formal technical specifications
  • Experience of working in a team, and the complexities of working in a technical team

Knowledge:

  • Data warehousing in NHS setting
  • Knowledge and understanding of SQL DML and DDL statements, and front end counterpart actions in SSMS
  • Data flow diagrams and appreciates importance
  • Good working knowledge of ERDs to describe relationships within datasets
  • Good working knowledge of star schema models and how to implement within a DW
  • Strong knowledge of NHS information standards, guidance and definitions

For further details, refer to the Job Description and Personal Specification.

Person Specification

Qualifications

Essential
  • Please click "apply now" to view the full person specification (there is no obligation to apply for this post).

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.

Employer details

Employer name

The Mid Yorkshire Teaching NHS Trust

Address

Dewsbury District Hospital

Dewsbury

West Yorkshire

WF13 4HS

United Kingdom

Employer's website

https://www.midyorks.nhs.uk/



Job Details

Company
The Mid Yorkshire Teaching NHS Trust
Location
Dewsbury, WF13 4HS, United Kingdom
Salary
£49387.00 to £56515.00
Posted