level 5 Data Engineer Apprenticeship

Summary

This role offers an opportunity to gain hands-on experience in the world of data engineering, where you'll work closely with experienced professionals, develop your technical skills, and learn how to use data to solve real-world problems, based at Medhurst Communications in Hampshire.

Annual wage

£25,584 a year

Minimum wage rates (opens in new tab)

Salary: £25,584 - £30,559

Training course

Data engineer (level 5)

Hours

Monday - Friday working pattern (37 hours per week) 52 weeks per year, working hours TBC

37 hours a week

Possible start date

Thursday 30 January

Duration

2 years

Positions available

1

Work

As an apprentice, you’ll work at a company and get hands-on experience. You’ll gain new skills and work alongside experienced staff.

What you’ll do at work

Assisting in data integration projects by extracting data from various sources (e.g., databases, APIs, flat files) and transforming it into a usable format for analysis and reporting
Performing data cleansing and transformation activities, including identifying and correcting errors, standardising formats, and enriching data using various techniques
Supporting the development of data models by creating and maintaining documentation, assisting with data mapping, and contributing to the design of database schemas
Collaborating with the data engineering team on projects related to migrating data to a cloud-based platform
Contributing to the creation of data visualisations and reports to present insights to stakeholders

Where you’ll work

17 Brunel Way

Fareham

PO15 5TX

Training

An apprenticeship includes regular training with a college or other training organisation. At least 20% of your working hours will be spent training or studying.

College or training organisation

QA LIMITED

Your training course

Data engineer (level 5)

Equal to higher national diploma (HND)

Course contents

Collate, evaluate and refine user requirements to design the data product.
Collate, evaluate and refine business requirements including cost, resourcing, and accessibility to design the data product.
Design a data product to serve multiple needs and with scalability, efficiency, and security in mind.
Automate data pipelines such as batch, real-time, on demand and other processes using programming languages and data integration platforms with graphical user interfaces.
Produce and maintain technical documentation explaining the data product, that meets organisational, technical and non-technical user requirements, retaining critical information.
Systematically clean, validate, and describe data at all stages of extract, transform, load (ETL).
Work with different types of data stores, such as SQL, NoSQL, and distributed file system.
Identify and troubleshoot issues with data processing pipelines.
Query and manipulate data using tools and programming such as SQL and Python. Manage database access, and implement automated validation checks.
Communicate downtime and issues with database access to stakeholders to mitigate the operational impact of unforeseen issues.
Evaluate opportunities to extract value from existing data products through further development, considering costs, environmental impact and potential operational benefits.
Maintain a working knowledge of data use cases within organisations.
Use data systems securely to meet requirements and in line with organisational procedures and legislation.
Identify new tools and technologies and recommend potential opportunities for use in own department or organisation.
Optimise data ingestion processes by making use of appropriate data ingestion frameworks such as batch, streaming and on-demand.
Develop algorithms and processes to extract structured data from unstructured sources.
Apply and advocate for software development best practice when working with other data professionals throughout the business. Contribute to standards and ways of working that support software development principles.
Develop simple forecasts and monitoring tools to anticipate or respond immediately to outages and incidents.
Identify and escalate risks with suggested mitigation/resolutions as appropriate.
Investigate and respond to incidents, identifying the root cause and resolution with internal and external stakeholders.
Identify and remediate technical debt, assess for updates and obsolescence as part of continuous improvement.
Develop, maintain collaborative relationships using adaptive business methodology with stakeholders such as, business users, data scientists, data analysts and business intelligence teams.
Present, communicate, and disseminate messages about the data product, tailoring the message and medium to the needs of the audience.
Evaluate the strengths and weaknesses of prototype data products and how these integrate within an organisation’s overarching data infrastructure.
Assess and identify gaps in existing tools and technologies in respect of implementing changes required.
Identify data quality metrics and track them to ensure the quality, accuracy and reliability of the data product.
Selects and apply sustainable solutions to contribute to net zero and environmental strategies across the various stages of product and service delivery.
Horizon scanning to identify new technologies that offer increased performance of data products.
Implement personal strategies to keep up to date with new technology and ways of working.
Collate, evaluate and refine user requirements to design the data product.
Collate, evaluate and refine business requirements including cost, resourcing, and accessibility to design the data product.
Design a data product to serve multiple needs and with scalability, efficiency, and security in mind.
Automate data pipelines such as batch, real-time, on demand and other processes using programming languages and data integration platforms with graphical user interfaces.
Produce and maintain technical documentation explaining the data product, that meets organisational, technical and non-technical user requirements, retaining critical information.
Systematically clean, validate, and describe data at all stages of extract, transform, load (ETL).
Work with different types of data stores, such as SQL, NoSQL, and distributed file system.
Identify and troubleshoot issues with data processing pipelines.
Query and manipulate data using tools and programming such as SQL and Python. Manage database access, and implement automated validation checks.
Communicate downtime and issues with database access to stakeholders to mitigate the operational impact of unforeseen issues.
Evaluate opportunities to extract value from existing data products through further development, considering costs, environmental impact and potential operational benefits.
Maintain a working knowledge of data use cases within organisations.
Use data systems securely to meet requirements and in line with organisational procedures and legislation.
Identify new tools and technologies and recommend potential opportunities for use in own department or organisation.
Optimise data ingestion processes by making use of appropriate data ingestion frameworks such as batch, streaming and on-demand.
Develop algorithms and processes to extract structured data from unstructured sources.
Apply and advocate for software development best practice when working with other data professionals throughout the business. Contribute to standards and ways of working that support software development principles.
Develop simple forecasts and monitoring tools to anticipate or respond immediately to outages and incidents.
Identify and escalate risks with suggested mitigation/resolutions as appropriate.
Investigate and respond to incidents, identifying the root cause and resolution with internal and external stakeholders.
Identify and remediate technical debt, assess for updates and obsolescence as part of continuous improvement.
Develop, maintain collaborative relationships using adaptive business methodology with stakeholders such as, business users, data scientists, data analysts and business intelligence teams.
Present, communicate, and disseminate messages about the data product, tailoring the message and medium to the needs of the audience.
Evaluate the strengths and weaknesses of prototype data products and how these integrate within an organisation’s overarching data infrastructure.
Assess and identify gaps in existing tools and technologies in respect of implementing changes required.
Identify data quality metrics and track them to ensure the quality, accuracy and reliability of the data product.
Selects and apply sustainable solutions to contribute to net zero and environmental strategies across the various stages of product and service delivery.
Horizon scanning to identify new technologies that offer increased performance of data products.
Implement personal strategies to keep up to date with new technology and ways of working.

Your training plan

Data Engineer Level 5.

Whilst working for Greenwood Academies Trust (GAT) you will be undertaking a significant amount of your apprenticeship training at Medhurst Communications, who are an education focused Managed Service Provider (MSP) and technology provider and will provide the professional development and support, in addition to your line management within GAT.

Requirements

Essential qualifications

GCSE in:

English (grade 4/C)
maths (grade 4/C)

Let the company know about other relevant qualifications and industry experience you have. They can adjust the apprenticeship to reflect what you already know.

Skills

Communication skills
IT skills
Attention to detail
Organisation skills
Problem solving skills
Number skills
Analytical skills
Logical
Team working
Creative
Initiative

About this company

The Greenwood Academies Trust (GAT) currently has 39 open academies educating approximately 17,000 pupils across seven local authority areas.

https://www.greenwoodacademies.org/ (opens in new tab)

Company benefits

* Hundreds of global and local perks, available online 24/7 * Shopping discounts from big brands, all year round * Save money on everything from the supermarket shop to summer holidays * A free Employee Assistance Programme from Health Assured

After this apprenticeship

There may be the possibility of a permanent role within Greenwood Academies Trust after qualification, however this would not be based at Medhurst Communications in Hampshire.

Ask a question

The contact for this apprenticeship is: