Data Technician with Business Insights and Analytics
Level 3 Apprenticeship
Funding band: £13,000
Duration: 16 months
Delivery Style: 1:1 In person and online, Live virtual classrooms, 247 on demand learning resources
Apprenticeship training is fully funded. Apprentices are not required to pay.
Employers, please visit our Funding, Grants & Payments section.
Searching for a Data Technician apprenticeship that gives you more?
We’ve reimagined our Data Technician apprenticeship to drive change, incorporating new features and tools. Apprentices will learn data management, analysis techniques to gain real world insights, with access to new learn members and optional qualifications.
Data Technician Blended Learning Masterclass Modules:
As well as learning all of the above using leading VLE platforms, apprentices will attend a series of Masterclass modules, delivered live virtual by our expert tutor team.
Duration | 4 Days
Workplace Essentials: Safeguarding & Prevent Duty, Health, Safety & Wellbeing, Equality, Diversity & Inclusion, British Values, Business Etiquette, Professionalism, Team Roles & Motivation
- Communication & Skills Development: Functional skills, mental health & resilience, networking, digital adoption
- Digital Careers: Industry roles, future-proofing careers, behaviours & standards expected
- Web & Internet Technologies: Modern web technologies, social networking, internet infrastructure, DNS, emails, cloud computing
- Programming & Databases: Intro to programming languages (C, Java, Python, etc.), data modelling, SQL
- AI & Cybersecurity: Emerging AI tools, cybersecurity, data protection, ethical & legal issues
Duration | 4 Days
- Excel Fundamentals
- Excel Pivot Tables
- Excel Tips and Advanced Techniques
- Excel Power Query for Beginner
- Cleaning Data with Power Query
- Excel Power Query Tips and Best Practices
- Excel Data Visualisations
- Excel Creating a dashboard
- Introduction to Power Pivot and Data Modelling
- Excel Tips and Advanced Techniques
Duration | 4 Days
- Stakeholders Identification and Management
- The value of Data Sources and Data Classification in Organisations
- Applications of Algorithms and Data Systems
- Collaboration and Communication with Data Storytelling
Duration | 4 Days
- Fundamentals of Databases and Data Modelling
- Entity Relationship Diagrams and Normalisation
- Introduction to SQL
- Managing Databases with SQL
Duration | 4 Days
- Introduction to Project Management: Project Lifecycle Phase and Project’s Key Concept
- The role of effective communication for key stakeholders’ identification and management, Prioritisation of Tasks, Resource Optimisation and Track Progress
- Project Management Methodologies
- Working Collaboratively: Motivation in Teams and Problem-Solving Techniques
Data Technician with Excel for Business Insights and Analytics
We’ve crafted the Level 3 Data Technician apprenticeship standard for Business Insights and Analytics, in close collaboration with employer partners seeking a program surpassing the Business Administrator apprenticeship. This apprenticeship equips learners to excel in data management, report accuracy, and data dashboard creation using Excel.
Enrollees in this NowSkills apprenticeship will undergo structured data and database sessions, learning essential techniques, and an intensive Excel training week covering advanced features like XLOOKUP, Pivot Charts, and Power Query. Upon completion, apprentices will adeptly manage data and tools, with potential progression to our Level 4 analyst program.
Trusted by leading employers
Flexible, blended learning:
Our apprenticeships are designed to be flexible and employer-driven, creating unique learning journeys tailored to each individual. We combine engaging live online Masterclass Modules with up-to-date Online Learning Courses to ensure a well-rounded experience. Every month, our Professional Development Reviews bring together the Tutor, Apprentice, and Mentor, either online or in person, to discuss progress and set goals.
We invite apprentices and their mentors to join our NowSkills Insights webinar series, where renowned speakers explore current trends in the digital landscape. Apprentices also have the chance to earn industry-recognised certifications that extend beyond their core apprenticeship training.
More course details
This apprenticeship emphasises tasks like data sourcing, collation, presentation, and analysis, supported by comprehensive behavioural development. It offers opportunities to work independently and collaboratively. Ideal for those who enjoy logical thinking and problem-solving, it leads to roles like Data Support Analyst, Technician, or Junior Analyst post-apprenticeship.
Learner Journey
Technical skills, knowledge and behaviours you will gain:
- How to access data from a range of sources that are already identified.
- How to compile and format data according to industry best practices.
- Data formats and their importance for analysis.
- Practical skills in communication methods, formats, and techniques.
- How to combine a wide range of data from different sources.
- Algorithms and how they function with a step-by-step solution to a problem, or rules to follow to solve the problem, as well as the possibility of applying automation.
- How to filter details, focusing on information relevant to the data project.
- Basic statistical methods and simple data modeling to extract relevant data and normalise unstructured data to make data-driven decisions.
- Different methods of validating data and understanding the importance of taking corrective action.
- Understanding the range of common data quality issues that can arise e.g., misclassification, duplicate entries, spelling errors, and obsolete data.
- Legal and regulatory requirements and how to ethically use data.
- The role of data in the context of the digital world.
Apprentices must have:
(Entry requirements vary depending on the employer’s requirements.)
- The right to work in the UK
- Lived in the UK continuously for the past 3 years
- GCSE English and maths minimum requirement at grade 3 or above (or equivalent)
Level 3 Data Technician Apprenticeship
Level 3 Data Technician Apprenticeship, awarded by the Institute for Apprenticeships and Technical Education
Optional examination for MO-200: Microsoft Excel
(The following optional certification exam may be taken following completion of all training sessions.)
Optional examination for MO-200: Microsoft Excel
- Additional fee applies, an exam cannot be funded by an apprenticeship fee
- More information about the Certified Microsoft Excel exam
Tutor 1:1s
These take place monthly, either at the workplace or live online with the tutor.
- Teaching delivery sessions, in areas of training need to be agreed upon with the tutor
- Professional Development Reviews (PDRs), which employers must partake in
- Updating of the Professional Development Plan (PDP)
- Provision of ongoing career education, information, advice & guidance (CEIAG)
- Feedback on an apprentice’s work from a skills coach
- English, maths, and wider digital relevant skills development
- A meaningful discussion about the apprentice’s achievements
- Identifying areas for improvement, and agreeing on a consequent target plan
- Looking at progress made to date
Support in understanding and applying:
- Safeguarding; fundamental British values; health, safety, & wellbeing; and equality, diversity, and inclusion
Ongoing professional development
Apprentices will be guided by a NowSkills tutor and their workplace mentor throughout the duration of the Data Technician apprenticeship training. For a level 3 apprentice, this must be 6 hours of their working week and if they aren’t attending training in the centre, it may likely consist of:
- Mentoring sessions with the nominated suitable employer mentor
- Training in the workplace, relevant to the standard
- Producing/collating evidence for the apprentice’s summative portfolio
- Work shadowing
- Industry visits
- Attendance at competitions
- Online learning
- Studying or researching and teaching delivery
Gateway to EPA
This is the period in which the apprentice crosses the threshold phase, from the learning and formative assessment period to the end-point assessment phase. This decision will be made by the employer, training provider, and apprentice based on the apprentice’s progress. To move onto the end-point assessment phase, it is essential to have passed all the knowledge modules and/or vendor qualifications or professional qualifications and to provide a portfolio of work.