Data Technician

Course details

Level

shield with tick

Level 3

Duration

calendar

13 months

One-to-one support

handshake

Every 4 weeks

You will achieve

Level 3 Data Technician
BCS

Common job roles

  • Data technician
  • Data support analyst
  • Junior data analyst
  • Junior information analyst

Roles you may progress into

  • Data manager
  • Data scientist
  • Data engineer

Delivery of programme

Phase one

Pre-Induction

Before your induction, a member of Estio’s Apprenticeship Onboarding team will contact you and your employer representative to discuss your job role and the apprenticeship standard. During this initial consultation, you will also begin your personalised Vocational Scorecard, which assesses your current skill levels against the apprenticeship standard.

The scorecard ensures we fully understand your starting point, so that we can work with your employer to develop an individual learning plan that is tailored to your needs, and gives you the best opportunity to achieve at the highest level.

Induction

Your induction will take place within the first two weeks of starting your employment and will be facilitated by the Onboarding team at your nearest Estio training centre. You will go through an overview of your chosen apprenticeship programme and be given details of what dedicated support is in place for you throughout your learning journey. In addition, you will receive login details for our Virtual Learning Environment, which you will use to complete both mandatory and optional training modules as part of your programme. Any outstanding diagnostic assessments and enrolment documents will be completed, and you can ask any last questions you may have before you formally begin your training.

Functional skills

We use BKSB tests to determine your current level of knowledge, to assess if you need further support with English and/or Maths.

If you do, our Functional Skills Training team will work with you to supply these skills. You will be supported through remote training sessions and workshops, which run for 3 days (for each).

Once you feel comfortable, you can sit the Level 2 Maths and/or English exams. These qualifications are equivalent to an A* – C (4-9) grade at GCSE, they are fully certified by City & Guilds and can be used to further enhance your CV and skillset.

Phase two

Core modules

The first 7 months of the level 3 Data Technician programme is made up of core modules. Once the core modules are complete you can then specialise on one of our three specialist pathways.

Essential mathematics skills to reach a minimum required standard for data analysis.

In this preparatory module, learners will learn fundamental professional skills, for example working in a team, communication skills and how to deal with customer issues. These skills will then be applied throughout the apprenticeship in ‘real-life’ scenarios. Learners will be presented with different learning techniques, assessing their own learning style and explore ways to improve it.

In this module, learners will learn about different data sources of data in the digital world and how to recognise types of data, for example structured and unstructured, numerical and categorical data. They will learn about data legislation and regulation, including creation and the use of open, public and proprietary data and GDPR rules. After this module learners will be ready to recognise and use different types of files like json, xml, bak etc.

In this module, learners will discuss different features of quality data. This is necessary when identifying sources of data and establishing whether is it reliable or fit for the purpose. They will learn how to integrate data from different formats, as well as transform, prepare and work with data. Finally, they will learn how to present data using Exploratory Data Analysis methods.

This module will include the use of advanced formulae in Excel and the creating and analysis of pivot tables. Learners will learn how to clean data, handle missing data, perform descriptive analysis and effectively report the results. Along with these technical skill, they will acquire soft skills like communication, time management and working in a team.

In this module, learners will recognise and use quality data from different sources and integrate them together, applying Extract-Transform-Load methods in Power BI. They will follow the data analytics life cycle to prepare the data, transform it to be fit for purpose and to create reports and interactive dashboards. They will also model the data using drilling down /up, filters, slicers and DAX language.

In this module, learners will create new databases, integrate data from different formats, transform, and prepare data using a SQL server. They learn how to design, normalise and interrogate a database, as well as how how to normalise it and how to interrogate it.

In this module, learners will continue to work in SQL Server, using some advanced features like aggregate functions, views, and stored procedures. They will apply the communication and presentation skills they’ve developed using the results from the projects

Specialist pathways

Pathway 1: Excel

In this unit, more advanced topics are presented data structures, sub setting, imputing and normalising data using Excel (VBA & macros).

In this module, we discuss about basic statistics and descriptive methods, applied in Excel.

Using Excel, in this module, learners will use all the knowledge, skills and behaviours acquired in the previous months in projects created especially for them. They can combine using Power BI, Excel or even SQL Server to prepare the data and then can use a language like R or Python for performing some data analysis tasks. They have the opportunity to use and practice skills like collaboration, communication, writing reports and presenting the results.

Pathway 2: R

In this unit, more advanced topics are presented data structures, sub setting, imputing and normalising data using R and R Studio.

In this module, we discuss about basic statistics and descriptive methods, applied in  R. Also, all the methods used in the core modules about cleaning and preparing data will be re-introduced using R.

Using R, in this module, learners will use all the knowledge, skills and behaviours acquired in the previous months in projects created especially for them. They can combine using Power BI, Excel or even SQL Server to prepare the data and then can use a language like R or Python for performing some data analysis tasks. They have the opportunity to use and practice skills like collaboration, communication, writing reports and presenting the results.

Pathway 3: Python

In this unit, more advanced topics are presented data structures, sub setting, imputing and normalising data using Python

In this module, we discuss about basic statistics and descriptive methods, applied in  Python. Also, all the methods used in the core modules about cleaning and preparing data will be re-introduced using Python.

Using Python, in this module, learners will use all the knowledge, skills and behaviours acquired in the previous months in projects created especially for them. They can combine using Power BI, Excel or even SQL Server to prepare the data and then can use a language like R or Python for performing some data analysis tasks. They have the opportunity to use and practice skills like collaboration, communication, writing reports and presenting the results.

People icon

One-to-one support

You will have a Technical Specialist and a Progress Management Co-ordinator (PMC) assigned to support you throughout your apprenticeship.

Your PMC will contact you every 4 weeks to discuss your progress made to date, check you’re understanding your training modules, and support you with gathering evidence for your portfolio. Every 12 weeks a review meeting will take place between you, your employer representative and your PMC to assess how your new learning and skills development is being applied in your job role and its impact on your wider industry skills.

The Technical Specialist will work with you to develop your portfolio of evidence for End Point Assessment, and with your employer representative to agree the various workplace projects you will be required to undertake. They will also support your employer representative to complete your Employer Reference, a document which highlights key behaviours you have demonstrated for the final assessment as part of the End Point Assessment.

In every one-to-one session, we will agree actions and SMART targets for you to complete, so that you can progress confidently and with the right support.

portfolio

Your portfolio

Throughout the apprenticeship, you will contribute evidence towards your online e-portfolio. We use e-portfolios as they are accessible from anywhere, and enable you to track your progress throughout your apprenticeship.

You’ll have access to your personal dashboard, which shows you a number of key milestones and deadlines coming up, such as the training you have completed, work that is due, and any gaps in your portfolio of evidence.

Your Technical Specialist and Progress Management Co-ordinator will be available to contact at any point throughout the apprenticeship and will advise you how to provide the best evidence.

20 percent pie chart

Off-the-job training

Off-the-job (OTJ) training is comprised of, but not limited to activities such as: training with Estio, shadowing, journal entries and projects for e-portfolio. Completed within working hours as agreed with the employer but average at 6 hours per week (20% of your time on your apprenticeship).

You can track your OTJ progress on your e-portfolio.

Phase three

Assessment Gateway, preparation & administration week

The Gateway week is used to finetune your skills and offer a simulated Synoptic Project for systems familiarisation, and to ensure that your Summative Portfolio and Employer Reference are completed before entering into EPA.

Phase four

End Point Assessment

Learners are assessed by an End Point Assessment Organisation, chosen by the Employer. Included in EPA is Evidence Submission (portfolio & certificates), Employer Reference, Synoptic Project and an Interview.
The Independent Assessor will feedback the results (Pass, Merit or Distinction) and the ESFA will provide your certificate.

Where can this apprenticeship take you?

The Data Technician standard will give you the skills and experience to work as a data technician, data analyst, network technician, systems administrator or a business analyst. Over the course of your career you can then become a senior expert in one of these fields.

To further your education within this industry, we recommend that you progress onto a Level 4 Data Analyst apprenticeship to further your knowledge and experience.

Level 4 Data Analyst roles

Data Analyst, Data Manager, Data Scientist

You can find out more about our level 4 Data Analyst role by clicking here.

Alternatively more information can be found on the institute for apprenticeships website.

Get in touch!

Call our team on 01133 500 333 or fill out our enquiry form below