Job summary
An exciting opportunity to complete a two year fully funded Data Engineering apprenticeship while earning a Band 5 salary. The successful candidate will be fully supported to undertake the Cambridge Spark Level 5 Data Engineering qualification course and to build skills in SQL Server technologies and Python. The course combines work-based and academic learning. The post holder will receive remote training and work towards the formal qualification whilst developing technical and professional skills.
Responsible as part of a team to deliver high quality business and complex clinical reporting structures from disparate systems within a consistent and stable framework that is monitored and assured.
We are proud to be a diverse and inclusive organisation and there is a choice of staff networks that help you meet like-minded people. The Christie supports flexible working, enquiries welcomed.
Main duties of the job
To deliver and maintain data transfer pipelines between clinical/operational source systems and the Christie Central Data Repository (CCDR). Ensure that all extract, transform and load (ETL) processes are robust, operate efficiently and fully documented.
Learn and assist in the development of new tools, technologies and methods of working as they are identified to ensure that they deliver the intended benefits. Support the migration process from legacy reporting and database systems
Provide a technical support service to all users of Data Engineering, understanding and communicating detailed technical requirements/processes with non-technical staff, managing priorities and expectation of service users. Manage unpredictable support workload.
About us
The Christie is one of Europe's leading cancer centres, treating over 60,000 patients a year. We are based in Manchester and serve a population of 3.2 million across Greater Manchester & Cheshire, but as a national specialist around 15% patients are referred to us from other parts of the country.
We provide radiotherapy through one of the largest radiotherapy departments in the world; chemotherapy on site and through 14 other hospitals; highly specialist surgery for complex and rare cancer; and a wide range of support and diagnostic services. We are also an international leader in research, with world first breakthroughs for over 100 years.
We run one of the largest early clinical trial units in Europe with over 300 trials every year. Cancer research in Manchester, most of which is undertaken on the Christie site, has been officially ranked the best in the UK.
Job description
Job responsibilities
DUTIES AND RESPONSIBILITIES
- Plan, develop and maintain data transfer pipelines from source systems to the CCDR. Pipeline design will vary considerably depending on the needs of each project.
- Analyse and interpret complex technical requirements and specifications from the Data Engineering Analysts to inform solution design, development and assurance.
- Support the appropriate design and development methodologies agreed for use within the team.
- Produce highly detailed technical specifications and documentation for the support, maintenance, monitoring and quality assurance of Data Engineering processes.
- Investigate, support, correct and prevent issues relating to existing Trust-developed Data Engineering systems and processes, identifying issues and implementing resolutions in a timely manner.
- Provide a technical support service to all users of Data Engineering, understanding and communicating detailed technical requirements/processes with non-technical staff, managing priorities and expectation of service users. Manage unpredictable support workload.
- Participate in the regular sprint planning process to determine durations and any dependencies with own planned development work. Plan own development work according to DE development standards. Be responsible for all allocated work.
- Develop test plans, and supporting test data, to validate the stability and maintainability of products, and their operation against requirements.
- As requested, provide reports on progress, status and achievements for own work.
- Complete the requirements of the Data Engineering Apprenticeship course.
- Ensure that additional skills and knowledge required for the role are acquired through professional development.
- Make recommendations on new tools, technologies and techniques that can be adopted by the team.
- Participate in regular exercises to test business continuity and disaster recovery plans.
- Provide guidance for staff from own or other disciplines on own subject area, when required.
- Be responsible for the safe and efficient use of hardware, software and financial resources.
- Ensure the post holder adheres to Trust Standing Financial Instructions (SFIs) and procurement guidelines.
- Participate in the development and implementation of projects as part of planned development sprint cycles.
- Ensure project tasks, where required, are successfully delivered in line with agreed timescales and budgets.
- Lead work projects required as part of apprentice qualification.
- Ensure any project management documentation or reports are delivered in line with agreed standards and timescales.
- Act as an ambassador for Digital Services by developing and maintaining excellent working relationships with users across the organisation to deliver a high quality professional service as part of the a development team.
- Pro-actively participate in ensuring that Digital services delivered within the Trust reflect best practice with respect to organisational, NHS and legislative requirements and guidelines including IT Infrastructure Library (ITIL), Data Protection Act 2018, Information Standards, Information Security and compliance with NHS Information Governance.
- Ensure all documentation relating to own area is complete and fit for purpose and all releases relating to hardware, software and documentation are controlled.
- Ensure all development and deployment meets DE standards and follows the Digital Services Change Approval Process.
- Contribute to Root Cause Analysis (RCA) for allocated incidents and problems; instigating action when required, liaising with other team members and managers, as appropriate.
- Be familiar with the Trust and Department level Business Continuity Plan and personal responsibilities within, where applicable.
Job description
Job responsibilities
DUTIES AND RESPONSIBILITIES
- Plan, develop and maintain data transfer pipelines from source systems to the CCDR. Pipeline design will vary considerably depending on the needs of each project.
- Analyse and interpret complex technical requirements and specifications from the Data Engineering Analysts to inform solution design, development and assurance.
- Support the appropriate design and development methodologies agreed for use within the team.
- Produce highly detailed technical specifications and documentation for the support, maintenance, monitoring and quality assurance of Data Engineering processes.
- Investigate, support, correct and prevent issues relating to existing Trust-developed Data Engineering systems and processes, identifying issues and implementing resolutions in a timely manner.
- Provide a technical support service to all users of Data Engineering, understanding and communicating detailed technical requirements/processes with non-technical staff, managing priorities and expectation of service users. Manage unpredictable support workload.
- Participate in the regular sprint planning process to determine durations and any dependencies with own planned development work. Plan own development work according to DE development standards. Be responsible for all allocated work.
- Develop test plans, and supporting test data, to validate the stability and maintainability of products, and their operation against requirements.
- As requested, provide reports on progress, status and achievements for own work.
- Complete the requirements of the Data Engineering Apprenticeship course.
- Ensure that additional skills and knowledge required for the role are acquired through professional development.
- Make recommendations on new tools, technologies and techniques that can be adopted by the team.
- Participate in regular exercises to test business continuity and disaster recovery plans.
- Provide guidance for staff from own or other disciplines on own subject area, when required.
- Be responsible for the safe and efficient use of hardware, software and financial resources.
- Ensure the post holder adheres to Trust Standing Financial Instructions (SFIs) and procurement guidelines.
- Participate in the development and implementation of projects as part of planned development sprint cycles.
- Ensure project tasks, where required, are successfully delivered in line with agreed timescales and budgets.
- Lead work projects required as part of apprentice qualification.
- Ensure any project management documentation or reports are delivered in line with agreed standards and timescales.
- Act as an ambassador for Digital Services by developing and maintaining excellent working relationships with users across the organisation to deliver a high quality professional service as part of the a development team.
- Pro-actively participate in ensuring that Digital services delivered within the Trust reflect best practice with respect to organisational, NHS and legislative requirements and guidelines including IT Infrastructure Library (ITIL), Data Protection Act 2018, Information Standards, Information Security and compliance with NHS Information Governance.
- Ensure all documentation relating to own area is complete and fit for purpose and all releases relating to hardware, software and documentation are controlled.
- Ensure all development and deployment meets DE standards and follows the Digital Services Change Approval Process.
- Contribute to Root Cause Analysis (RCA) for allocated incidents and problems; instigating action when required, liaising with other team members and managers, as appropriate.
- Be familiar with the Trust and Department level Business Continuity Plan and personal responsibilities within, where applicable.
Person Specification
Qualifications
Essential
- Degree qualification or equivalent experience
- 3 A level qualifications (or equivalent)
- Maths and English GCSE
Desirable
- Maths or Computer Science A level (or equivalent)
Experience
Essential
- Experience of Microsoft SQL Server.
- Experience of delivering complex data and reporting projects to meet varying requirements.
- Experience of successfully managing a number of equally important tasks to completion.
Desirable
- Source control processes and branching strategies.
- Data transfer using a web API.
- Experience of SQL Server database/data warehouse development maintenance and support.
- Experience of handling ETL solutions and issues.
- Experience in creating and updating system documentation.
- Experience of providing a technical support service to users.
- Experience of designing data solutions.
Skills
Essential
- T-SQL query writing.
- Microsoft Office literate.
- Ability to work to deadlines, prioritise and manage own workload in a busy and changing environment.
- Strong problem solving approach.
- Undertaking in-depth data analysis.
- Ability to think creatively.
- Ability to explain technical issues to a non-technical audience.
- Ability to manage difficult conversations, prioritising different users requirements for support.
- Balance extensive focused development work with non routine demands for user support.
Desirable
- Azure DevOps.
- Python.
- C#.
- Source control.
- Creating SQL Server Integration Services packages.
- Creating SQL Server Reporting Services reports.
- Using Visual Studio for database and business intelligence development.
- Project management skills.
Knowledge
Essential
- Good knowledge of key concepts involved in data analytics
- Understanding of data security standards
Desirable
- SQL Server query optimisation techniques.
- Best practices relating to the Microsoft SQL Server stack.
- Understanding of data governance standards
Values
Essential
- Ability to demonstrate the organisational values and behaviours
Other
Essential
- Evidence of continuing professional and personal development.
- Ability to travel to Christie managed sites as necessary.
- Ability to undertake shift working including out-of-hours, weekend and Public Holidays as required.
- On limited occasions, by exception, the post holder may be required to work unsociable hours to support and/or enable the delivery of key programmes or projects.
Person Specification
Qualifications
Essential
- Degree qualification or equivalent experience
- 3 A level qualifications (or equivalent)
- Maths and English GCSE
Desirable
- Maths or Computer Science A level (or equivalent)
Experience
Essential
- Experience of Microsoft SQL Server.
- Experience of delivering complex data and reporting projects to meet varying requirements.
- Experience of successfully managing a number of equally important tasks to completion.
Desirable
- Source control processes and branching strategies.
- Data transfer using a web API.
- Experience of SQL Server database/data warehouse development maintenance and support.
- Experience of handling ETL solutions and issues.
- Experience in creating and updating system documentation.
- Experience of providing a technical support service to users.
- Experience of designing data solutions.
Skills
Essential
- T-SQL query writing.
- Microsoft Office literate.
- Ability to work to deadlines, prioritise and manage own workload in a busy and changing environment.
- Strong problem solving approach.
- Undertaking in-depth data analysis.
- Ability to think creatively.
- Ability to explain technical issues to a non-technical audience.
- Ability to manage difficult conversations, prioritising different users requirements for support.
- Balance extensive focused development work with non routine demands for user support.
Desirable
- Azure DevOps.
- Python.
- C#.
- Source control.
- Creating SQL Server Integration Services packages.
- Creating SQL Server Reporting Services reports.
- Using Visual Studio for database and business intelligence development.
- Project management skills.
Knowledge
Essential
- Good knowledge of key concepts involved in data analytics
- Understanding of data security standards
Desirable
- SQL Server query optimisation techniques.
- Best practices relating to the Microsoft SQL Server stack.
- Understanding of data governance standards
Values
Essential
- Ability to demonstrate the organisational values and behaviours
Other
Essential
- Evidence of continuing professional and personal development.
- Ability to travel to Christie managed sites as necessary.
- Ability to undertake shift working including out-of-hours, weekend and Public Holidays as required.
- On limited occasions, by exception, the post holder may be required to work unsociable hours to support and/or enable the delivery of key programmes or projects.
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.
