Mid-Yorkshire-Teaching-Nhs-Trust
Dewsbury, Yorkshire
Contact information For further information about this role, please email Beck Kestle (Senior Data Architect) via , Ibrar Khan (Lead Data Engineer) via , or Mark Akers (Lead Data Engineer) via About the role 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. This vacancy may close early if sufficient applications are received. Therefore, we encourage you to submit your application as soon as possible. Please refer to the attached job description and person specification for further details. Main duties 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. Essential person specification requirements Qualifications: Educated to Masters level or equivalent level or equivalent experience of working at a senior level in specialist area, plus Postgraduate management diploma qualification. Experience: Experience of exporting data from various source data systems, transforming data against required business rules and data models, or data storage and analysis requirements, and loading data in various storage platforms. Excellent communication and collaboration skills to determine data requirements. Experience of implementing digital/information/data change programmes. 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. Knowledge & Awareness: Extensive working knowledge and experience with ETL and data integration. Knowledge and expertise of IT architecture and infrastructure. Current knowledge of the public sector/NHS. Skills & Attributes: Excellent analytical, IT Keyboard and numerical skills - confident with statistics and their presentation. Excellent verbal and written communication (including presentation) skills. Ability to analyse highly complex issues where material is conflicting and drawn from multiple sources (verbal, written and numerical). Significant ability to analyse numerical and written data, assess options and draw appropriate initiatives. Demonstrable ability to plan over short, medium and long-term timeframes and adjust plans and resource requirements accordingly. Demonstrable ability to work effectively between competing activities where required. Please refer to the attached job description and person specification for further details. Be part of MY team 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. If you value caring, high standards, improvement, and respect, join the MY team to make a difference every day. Application guidance: We understand that more applicants are using artificial intelligence (AI) technology to help with their applications. While these tools can be useful, they cannot fully capture your skills, knowledge, and experience. It's important that you personalise your application. Relying solely on AI is not recommended, as it may reduce your chances of success. Our screening process is thorough, so if you have used AI, please make sure to disclose this on your application form. Our benefits Access to the NHS pension plan Generous holiday allowance of 27 days plus bank holidays, increasing with 5 and 10 years of service Exceptional employee health and wellbeing services Extensive benefits and support, including: Onsite nurseries and childcare salary sacrifice scheme Home electronics scheme Cycle to work scheme - subject to eligibility criteria Car lease salary sacrifice scheme - subject to eligibility criteria Working carers support and advice, carers network and carers passport Flexible working options and family and carer friendly policies Established staff networks, including LGBTQ+ and Race Equality Career progression, training and support Skilled worker sponsorship You can find out more about skilled worker and health and care visas on our careers site.
Contact information For further information about this role, please email Beck Kestle (Senior Data Architect) via , Ibrar Khan (Lead Data Engineer) via , or Mark Akers (Lead Data Engineer) via About the role 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. This vacancy may close early if sufficient applications are received. Therefore, we encourage you to submit your application as soon as possible. Please refer to the attached job description and person specification for further details. Main duties 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. Essential person specification requirements Qualifications: Educated to Masters level or equivalent level or equivalent experience of working at a senior level in specialist area, plus Postgraduate management diploma qualification. Experience: Experience of exporting data from various source data systems, transforming data against required business rules and data models, or data storage and analysis requirements, and loading data in various storage platforms. Excellent communication and collaboration skills to determine data requirements. Experience of implementing digital/information/data change programmes. 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. Knowledge & Awareness: Extensive working knowledge and experience with ETL and data integration. Knowledge and expertise of IT architecture and infrastructure. Current knowledge of the public sector/NHS. Skills & Attributes: Excellent analytical, IT Keyboard and numerical skills - confident with statistics and their presentation. Excellent verbal and written communication (including presentation) skills. Ability to analyse highly complex issues where material is conflicting and drawn from multiple sources (verbal, written and numerical). Significant ability to analyse numerical and written data, assess options and draw appropriate initiatives. Demonstrable ability to plan over short, medium and long-term timeframes and adjust plans and resource requirements accordingly. Demonstrable ability to work effectively between competing activities where required. Please refer to the attached job description and person specification for further details. Be part of MY team 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. If you value caring, high standards, improvement, and respect, join the MY team to make a difference every day. Application guidance: We understand that more applicants are using artificial intelligence (AI) technology to help with their applications. While these tools can be useful, they cannot fully capture your skills, knowledge, and experience. It's important that you personalise your application. Relying solely on AI is not recommended, as it may reduce your chances of success. Our screening process is thorough, so if you have used AI, please make sure to disclose this on your application form. Our benefits Access to the NHS pension plan Generous holiday allowance of 27 days plus bank holidays, increasing with 5 and 10 years of service Exceptional employee health and wellbeing services Extensive benefits and support, including: Onsite nurseries and childcare salary sacrifice scheme Home electronics scheme Cycle to work scheme - subject to eligibility criteria Car lease salary sacrifice scheme - subject to eligibility criteria Working carers support and advice, carers network and carers passport Flexible working options and family and carer friendly policies Established staff networks, including LGBTQ+ and Race Equality Career progression, training and support Skilled worker sponsorship You can find out more about skilled worker and health and care visas on our careers site.