Data engineer

ST1386, data engineer level 5

This is a summary of the key things that you – the apprentice and your employer need to know about your end-point assessment (EPA). You and your employer should read the EPA plan for the full details. It has information on assessment method requirements, roles and responsibilities, and re-sits and re-takes.

What is an end-point assessment and why it happens

An EPA is an assessment at the end of your apprenticeship. It will assess you against the knowledge, skills, and behaviours (KSBs) in the occupational standard. Your training will cover the KSBs. The EPA is your opportunity to show an independent assessor how well you can carry out the occupation you have been trained for.

Your employer will choose an end-point assessment organisation (EPAO) to deliver the EPA. Your employer and training provider should tell you what to expect and how to prepare for your EPA.

The length of the training for this apprenticeship is typically 24 months. The EPA period is typically 4 months.

The overall grades available for this apprenticeship are:

• fail

• pass

• merit

• distinction

When you pass the EPA, you will be awarded your apprenticeship certificate.

EPA gateway

The EPA gateway is when the EPAO checks and confirms that you have met any requirements required before you start the EPA. You will only enter the gateway when your employer says you are ready.

The gateway requirements for your EPA are:

• achieved English and mathematics qualifications in line with the apprenticeship funding rules

• for the project evaluation report, presentation and questions, the project's title and scope must be agreed with the EPAO and a project summary submitted

Assessment methods

Project with report

You will complete a project and write a report. You will be asked to complete a project. The title and scope must be agreed with the EPAO at the gateway. The report should be a maximum of 3500 words (with a 10% tolerance).

You will have 10 weeks to complete the project and submit the report to the EPAO.

You need to prepare and give a presentation to an independent assessor. Your presentation slides and any supporting materials should be submitted at the same time as the project output. The presentation with questions will last at least 50 minutes. The independent assessor will ask at least 6 questions about the project and presentation.

Professional discussion

You will have a professional discussion with an independent assessor. It will last 80 minutes. They will ask you at least 10 questions. The questions will be about certain aspects of your occupation. You can use it to help answer the questions.

The EPAO will confirm where and when each assessment method will take place.

Who to contact for help or more information

You should speak to your employer if you have a query that relates to your job.

You should speak to your training provider if you have any questions about your training or EPA before it starts.

You should receive detailed information and support from the EPAO before the EPA starts. You should speak to them if you have any questions about your EPA once it has started.

Reasonable adjustments

If you have a disability, a physical or mental health condition or other special considerations, you may be able to have a reasonable adjustment that takes this into account. You should speak to your employer, training provider and EPAO and ask them what support you can get. The EPAO will decide if an adjustment is appropriate.

This document explains the requirements for end-point assessment (EPA) for the data engineer apprenticeship. End-point assessment organisations (EPAOs) must follow this when designing and delivering the EPA.

Data engineer apprentices, their employers and training providers should read this document.

A full-time data engineer apprentice typically spends 24 months on-programme (this means in training before the gateway). The apprentice must spend at least 12 months on-programme and complete the required amount of off-the-job training in line with the apprenticeship funding rules.

The apprentice must complete their training and meet the gateway requirements before starting their EPA. The EPA will assess occupational competence.

An approved EPAO must conduct the EPA for this apprenticeship. Employers must select an approved EPAO from the register of end-point assessment organisations (RoEPAO).

This EPA has 2 assessment methods.

The grades available for each assessment method are below.

Assessment method 1 - project evaluation report, presentation and questions:

• fail

• pass

• distinction

Assessment method 2 - professional discussion:

• fail

• pass

• distinction

The result from each assessment method is combined to decide the overall apprenticeship grade. The following grades are available for the apprenticeship:

• fail

• pass

• merit

• distinction

The EPA is taken in the EPA period. The EPA period starts when the EPAO confirms the gateway requirements have been met and is typically 4 months.

The EPAO should confirm the gateway requirements have been met and start the EPA as quickly as possible.

The apprentice’s employer must be content that the apprentice has attained sufficient KSBs to complete the apprenticeship. The employer may take advice from the apprentice's training provider, but the employer must make the decision. The apprentice will then enter the gateway.

The apprentice must meet the gateway requirements before starting their EPA.

They must:

• confirm they are ready to take the EPA
• have achieved English and mathematics qualifications in line with the apprenticeship funding rules

• submit a project brief for the project evaluation report, presentation and questions

• confirm that they have completed a suitable project that meets the knowledge, skills and behaviours.

The apprentice must submit the gateway evidence to their EPAO, including any organisation specific policies and procedures requested by the EPAO.

The assessment methods can be delivered in any order.

The result of one assessment method does not need to be known before starting the next.

Overview

A project involves the apprentice completing a significant and defined piece of work that has a real business application and benefit. The project must meet the needs of the employer’s business and be relevant to the apprentice’s occupation and apprenticeship.

The agreed project will present a typical business task, appropriate for demonstrating the skills and knowledge on the standard. The agreed project will be comparable in terms of content and complexity for all apprentices - it is the context within which the knowledge, and skills must be demonstrated that will vary. The project is undertaken and completed on programme and pre-gateway to the EPA. The project itself is not part of the EPA. The project will typically be undertaken on the employer’s premises.

This assessment method has 2 components:

• project with a project output

• presentation with questions and answers

Together, these components give the apprentice the opportunity to demonstrate the KSBs mapped to this assessment method. They are assessed by an independent assessor.

Rationale

This assessment method is being used because:

A project evaluation report is the most valid method as it allows the demonstration of professional competence.

The project is based on a real life example of the apprentices’ everyday work in their industry. Therefore, ensuring that they can demonstrate the KSBs in practice.

Producing a project evaluation report and presentation reflects normal professional practice, so this assessment method is appropriate.

Apprentices are required to be concise and precise in their use of language in written and verbal communication.

The project evaluation report offers a realistic opportunity to combine project management, examples of data products and formal writing enabling the apprentice to reflect on approaches taken.

It is a holistic assessment method, allowing the apprentice to demonstrate KSBs in an integrated way.

By writing the evaluation report on the project and being questioned to understand rationale for choices made, risks and problems identified, resolutions and areas where further action could be required. This method will enable the apprentice to showcase their professional competency.

The project is completed before gateway and is not graded. The project evaluation report is assessed and must be completed after gateway.

Delivery

The apprentice must complete a project based on any of the following:

• a specific problem
• a recurring issue
• an idea or opportunity

To ensure the project allows the apprentice to meet the KSBs mapped to this assessment method to the highest available grade, the EPAO must sign-off the project’s title and scope at the gateway to confirm it is suitable. The EPAO must refer to the grading descriptors to ensure that projects are pitched appropriately.

The project output must be in the form of a report and presentation.

The apprentice must start the project before gateway. The project evaluation report must be completed after gateway. The employer should ensure the apprentice has the time and resources, to plan and complete their project.

The apprentice may work as part of a team to complete the project, which could include internal colleagues or technical experts. The apprentice must however, complete their project report and presentation unaided and they must be reflective of their own role and contribution. The apprentice and their employer must confirm this when the report and any presentation materials are submitted.

Component 1: Project report

The report must include at least:

• an executive summary (or abstract)
• an introduction
• the scope of the project (including key performance indicators, aims and objectives)
• a project plan
• research outcomes
• data product outcomes
• project outcomes
• discussion of findings
• recommendations and conclusions
• references
• appendix containing mapping of KSBs to the report.

The report must also include:

To ensure the project allows the apprentice to meet the KSBs mapped to this assessment method to the highest available grade, the EPAO should sign-off the project evaluation report's title and scope at the gateway to confirm it is suitable.

The project output must be in the form of an evaluation report.

The apprentice must start the project evaluation report after the gateway. They must complete and submit the report to the EPAO by the end of week 10 of the EPA period.

The employer should ensure the apprentice has the time and resources, within this period, to plan and complete their project evaluation report. The apprentice must complete their project evaluation report and the production of its components unaided.

The apprentice may work as part of a team to complete the project which could include technical internal or external support. However, the project evaluation report must be the apprentice’s own work and reflective of their own role and contribution. The apprentice and their employer must confirm that the project evaluation report is the apprentice’s own work when it is submitted.

The project report must have a word count of 3500 words. A tolerance of 10% above or below is allowed at the apprentice’s discretion. Appendices, references and diagrams are not included in this total. The apprentice must produce and include a mapping in an appendix, showing how the report evidences the KSBs mapped to this assessment method.

The apprentice must complete and submit the report and any presentation materials to the EPAO by the end of week 10 of the EPA period.

Component 2: Presentation with questions

The presentation with questions must be structured to give the apprentice the opportunity to demonstrate the KSBs mapped to this assessment method to the highest available grade.

The apprentice must prepare and deliver a presentation to an independent assessor. After the presentation, the independent assessor must ask the apprentice questions about their project, report and presentation.

The presentation should cover:

• an overview of the project
• the project scope (including key performance indicators)
• summary of actions undertaken by the apprentice
• project outcomes and how these were achieved

The presentation with questions must last 50 minutes. This will typically include a presentation of 20 minutes and questioning lasting 30 minutes. The independent assessor must use the full time available for questioning. The independent assessor can increase the time of the presentation and questioning by up to 10%. This time is to allow the apprentice to complete their last point or respond to a question if necessary.

The independent assessor must ask at least 6 questions. They must use the questions from the EPAO’s question bank or create their own questions in line with the EPAO’s training. Follow up questions are allowed where clarification is required.

The purpose of the independent assessor's questions is:

• to verify that the activity was completed by the apprentice
• to seek clarification where required
• to assess those KSBs that the apprentice did not have the opportunity to demonstrate with the report, although these should be kept to a minimum
• to assess level of competence against the grading descriptors

The apprentice must submit any presentation materials to the EPAO at the same time as the report - by the end of week 10 of the EPA period. The apprentice must notify the EPAO, at that point, of any technical requirements for the presentation.

During the presentation, the apprentice must have access to:

• audio-visual presentation equipment
• flip chart and writing and drawing materials
• computer

The independent assessor must have at least 2 weeks to review the project report and any presentation materials, to allow them to prepare questions.

The apprentice must be given at least 2 weeks’ notice of the presentation with questions.

Assessment decision

The independent assessor must make the grading decision. They must assess the project components holistically when deciding the grade.

The independent assessor must keep accurate records of the assessment. They must record:

• the KSBs demonstrated in the report and presentation with questions
• the apprentice’s answers to questions
• the grade achieved

Assessment location

The presentation with questions must take place in a suitable venue selected by the EPAO for example, the EPAO’s or employer’s premises. It should take place in a quiet room, free from distractions and influence.

The presentation with questions can be conducted by video conferencing. The EPAO must have processes in place to verify the identity of the apprentice and ensure the apprentice is not being aided.

Question and resource development

The EPAO must develop a purpose-built assessment specification and question bank. It is recommended this is done in consultation with employers of this occupation. The EPAO must maintain the security and confidentiality of EPA materials when consulting with employers. The assessment specification and question bank must be reviewed at least once a year to ensure they remain fit-for-purpose.

The assessment specification must be relevant to the occupation and demonstrate how to assess the KSBs mapped to this assessment method. The EPAO must ensure that questions are refined and developed to a high standard. The questions must be unpredictable. A question bank of sufficient size will support this.

The EPAO must ensure that the apprentice has a different set of questions in the case of re-sits or re-takes.

EPAO must produce the following materials to support the project:

• independent assessor EPA materials which include:
  • training materials
  • administration materials
  • moderation and standardisation materials
  • guidance materials
  • grading guidance
  • question bank
• EPA guidance for the apprentice and the employer

The EPAO must ensure that the EPA materials are subject to quality assurance procedures including standardisation and moderation.

Overview

In the professional discussion, an independent assessor and apprentice have a formal two-way conversation. It gives the apprentice the opportunity to demonstrate the KSBs mapped to this assessment method.

Rationale

This assessment method is being used because:

It provides the apprentice with the opportunity to discuss and show case their depth of understanding the knowledge, skills and behaviours that may not naturally occur as part of the project.

It allows the independent assessor to consider the context and sector that the apprentice operates within, giving flexibility to ensure that all the KSBs can be assessed appropriately.

The professional discussion is cost effective, and it allows consideration of the potential need to conduct the EPA remotely.

Delivery

The professional discussion must be structured to give the apprentice the opportunity to demonstrate the KSBs mapped to this assessment method to the highest available grade.

An independent assessor must conduct and assess the professional discussion.

The apprentice may choose to end the assessment method early. The apprentice must be confident they have demonstrated competence against the assessment requirements for the assessment method. The independent assessor or EPAO must ensure the apprentice is fully aware of all assessment requirements. The independent assessor or EPAO cannot suggest or choose to end any assessment methods early unless in an emergency. The EPAO is responsible for ensuring the apprentice understands the implications of ending an assessment early if they choose to do so. The independent assessor may suggest the assessment continues. The independent assessor must document the apprentice’s request to end the assessment early.

The EPAO will ask ten questions, two for each of the themes:

• Data quality and performance
• Problem solving
• Regulatory Compliance
• Continuous Improvement
• Continuous professional development

The EPAO must give an apprentice 2 weeks' notice of the professional discussion.

The professional discussion must last for 80 minutes. The independent assessor can increase the time of the professional discussion by up to 10%. This time is to allow the apprentice to respond to a question if necessary.

The independent assessor must ask at least 10 questions. The independent assessor must use the questions from the EPAO’s question bank or create their own questions in line with the EPAO’s training. Follow-up questions are allowed where clarification is required.

The independent assessor must make the grading decision.

The independent assessor must keep accurate records of the assessment. They must record:

• the apprentice’s answers to questions
• the KSBs demonstrated in answers to questions
• the grade achieved 

Assessment location

The professional discussion must take place in a suitable venue selected by the EPAO for example, the EPAO’s or employer’s premises.

The professional discussion can be conducted by video conferencing. The EPAO must have processes in place to verify the identity of the apprentice and ensure the apprentice is not being aided.

The professional discussion should take place in a quiet room, free from distractions and influence.

Question and resource development

The EPAO must develop a purpose-built assessment specification and question bank. It is recommended this is done in consultation with employers of this occupation. The EPAO must maintain the security and confidentiality of EPA materials when consulting with employers. The assessment specification and question bank must be reviewed at least once a year to ensure they remain fit-for-purpose.

The assessment specification must be relevant to the occupation and demonstrate how to assess the KSBs mapped to this assessment method. The EPAO must ensure that questions are refined and developed to a high standard. The questions must be unpredictable. A question bank of sufficient size will support this.

The EPAO must ensure that the apprentice has a different set of questions in the case of re-sits or re-takes.

The EPAO must produce the following materials to support the professional discussion:

• independent assessor assessment materials which include:
  • training materials
  • administration materials
  • moderation and standardisation materials
  • guidance materials
  • grading guidance
  • question bank
• EPA guidance for the apprentice and the employer

The EPAO must ensure that the EPA materials are subject to quality assurance procedures including standardisation and moderation.

Performance in the EPA determines the overall grade of:

• fail

• pass

• merit

• distinction

An independent assessor must individually grade the project evaluation report, presentation and questions and professional discussion in line with this EPA plan.

The EPAO must combine the individual assessment method grades to determine the overall EPA grade.

If the apprentice fails one assessment method or more, they will be awarded an overall fail.

To achieve an overall pass, the apprentice must achieve at least a pass in all the assessment methods. Both assessment methods are weighted equally in their contribution to the overall EPA grade.

Grades from individual assessment methods must be combined in the following way to determine the grade of the EPA overall.

If the apprentice fails one assessment method or more, they can take a re-sit or a re-take at their employer’s discretion. The apprentice’s employer needs to agree that a re-sit or re-take is appropriate. A re-sit does not need further learning, whereas a re-take does. The apprentice should have a supportive action plan to prepare for a re-sit or a re-take.

The employer and the EPAO should agree the timescale for a re-sit or re-take. A re-sit is typically taken within 3 months of the EPA outcome notification. The timescale for a re-take is dependent on how much re-training is required and is typically taken within 6 months of the EPA outcome notification.

If the apprentice fails the project assessment method, they must amend the project output in line with the independent assessor’s feedback. The apprentice will be given 4 weeks to rework and submit the amended report.

Failed assessment methods must be re-sat or re-taken within a 6-month period from the EPA outcome notification, otherwise the entire EPA will need to be re-sat or re-taken in full.

Re-sits and re-takes are not offered to an apprentice wishing to move from pass to a higher grade.

The apprentice will get a maximum EPA grade of pass for a re-sit or re-take, unless the EPAO determines there are exceptional circumstances.

The EPAO must have reasonable adjustments arrangements for the EPA.

This should include:

• how an apprentice qualifies for reasonable adjustment
• what reasonable adjustments may be made

Adjustments must maintain the validity, reliability and integrity of the EPA as outlined in this EPA plan.

Internal quality assurance refers to the strategies, policies and procedures that an EPAO must have in place to ensure valid, consistent and reliable EPA decisions.

EPAOs for this EPA must adhere to the requirements within the roles and responsibilities table.

They must also appoint independent assessors who:

• have recent relevant experience of the occupation or sector to at least occupational level 6 gained in the last 5 years or significant experience of the occupation or sector

Affordability of the EPA will be aided by using at least some of the following:

• completing applicable assessment methods online (for example computer-based assessment)

• using the employer’s premises

• conducting assessment methods on the same day

This apprenticeship is not aligned to professional recognition.