Lead Data Engineer

Job summary

The Lead Data Engineer will contribute to the development and delivery of Data Warehousing, Reporting and Analytics output. They will enable data (from NHS data sets e.g. relating to acute activity) to be appropriately shared and disseminated within operational reports, published Management Information or Official Statistics.

The Lead Data Engineer will work closely with colleagues to develop robust processes for managing and automating regular outputs. The Lead Data Engineer must communicate plans and timescales to enable onward management of key stakeholders and should provide regular updates.

The Lead Data Engineer will feed into development priorities to understand potential efficiencies and savings in automated processes, to deploy and manage resources appropriately as the organisation progresses towards its strategic data solution.

The Lead Data Engineer will develop and implement new technologies to support robust and accurate data management and must ensure documentation (such as data dictionaries and data lineage information) is readily available across a range of stakeholders.

Please refer to the attached job description and person specification for further details.

Main duties of the job

• Technical lead for departmental work area, and overall data management framework.
• Embed improved ways of working with data across the wider team, including automation of manual tasks and data assurance.
• Strong skills in analysing, defining, sourcing and capturing data across strategic business systems, processes and areas of an organisation
• Strong experience of working with data and databases, ideally involving the development of new and existing data sources in a Data Warehouse environment.
• Good understanding of Data Warehouse techniques, including dimensional data modelling and relational database design and concepts (e.g. Kimball).
• Exceptional SQL experience and technical database expertise using relational databases such as Oracle Database & PL/SQL or Microsoft T-SQL.
• Excellent knowledge and experience of R and Python programming
• Experience of code reviews and ensuring coding standards are applied and met.
• Experience of defining and documenting data workflows across systems and operations, including capturing and documenting complex data definitions and business rules.
• Provide expert advice to the Directorate on matters of data platforms, data integration and visualisation tools.

Please refer to the attached job description and person specification for further details.

Job responsibilities

We are an acute trust caring for over one million people in Wakefield and Kirklees. Our 10,000 staff members work in patients homes, the community, and our three hospitals in Pontefract, Dewsbury, and Pinderfields (Wakefield). Committed to continuous improvement, we prioritise our people and values so we can deliver excellent patient experience. Our team is friendly, passionate and always seeking better ways to work through research and innovation. We support work-life balance and foster a diverse, inclusive environment where everyone belongs. Our staff networks offer safe spaces for honest conversations and to share ideas, thoughts and concerns so we can increase awareness and appreciation of equality, diversity, and inclusion. 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.