Getting Started with your
Junior Data Analyst Apprenticeship

Welcome to your Junior Data Analyst Apprenticeship with The JGA Group. This page will help you get started with your apprenticeship.

On this page:

Apprenticeship Overview

The Junior Data Analyst apprenticeship programme is an 24-month programme and the standard is made up of 9 core modules. There will also be project work and time allocated for EPA preparation. Seminars are held remotely via Teams or Zoom, supplemented with online learning tools and self-study materials. Progress is recorded via an online tool (OneFile).

It is a requirement of the government that over the course of the apprenticeship you spend at least 20% of your time completing activities which are not part of your day-to-day job role. This is called off-the-job training. If you do not have GCSE/O Level grades A-C/4-9 in English and maths, JGA will provide you with teaching to achieve an equivalent Functional Skills qualification.

Module Summary

  • The types, sources and formats of data
  • Access and extraction of data and the role of data in a complex digital world
  • Describing data in a sales and marketing context
  • How data adds value to business and marketing activities
  • Data storage methods
  • The impact of data protection legislation on storage and distribution of data
  • Exploring the ethical use of data
  • How to collate and format data in line with industry standards
  • Data cleansing and use of tools such as OpenRefine
  • Industry trends and use of formatting tools, for example Excel, Access, CRM, Google Analytics, Hubspot
  • Test and assess confidence in the data and its integrity
  • Presenting data for review and analysis by others, using a range of formats, media and methods of communication
  • The importance of collaborative working
  • Assessing the different formats and techniques used for communication
  • Analysing the different communication needs for internal and external stakeholders/customers
  • Explain data and initial thoughts and interpretation
  • Discuss and debate different ways of presenting results
  • Using database queries to interrogate data
  • How interrogation can enable personalised marketing and customer retention
  • Blending data sets from multiple sources and presenting in a format appropriate to the objective
  • Manipulating and linking data sets
  • Using tools and techniques to identify data trends and patterns
  • Cleaning data ready for blending and analysis
  • Using algorithms to find solutions, solve problems and identify trends and patterns in data
  • Automation and its use in data analysis
  • Basic statistical methods to identify trends and patterns in data
  • Filtering details to the needs of the project and relevance of the data
  • Using data modelling to extract relevant data and normalise unstructured data
  • Common quality issues that can arise when working with data
  • Review different methods of validating data
  • Know the importance of taking corrective action
  • Apply cross-checking techniques for identifying faults and data results to project requirements
  • Conduct data audits
  • How to format data for analysis
  • Use of tools to communicate results
  • Producing clear and consistent technical documentation
  • Explaining data results to audiences in a way that aids understanding
  • Cleansing data ready for blending, manipulation, interrogation and analysis
  • Conducting analysis of data

Your Tutors & Coaches

Owen Twidale
Tutor, Coach and Progress Advisor

I will be your Tutor, Skills Coach and Progress Advisor, supporting you throughout your apprenticeship journey.

Explaining the Roles

There are three key roles in the team which will support your apprenticeship. Some members of staff cover more than one of these.

Your tutor will lead you through your workshops or seminars and deliver a large proportion of the knowledge elements of your apprenticeship with you.

Your coach will meet with you each month to help develop and evidence your skills and behaviours within the workplace. Your line manager will attend part of this session. They will help you gather evidence to demonstrate your overall competency.

Your learner progress adviser will help provide additional support where needed and monitor your progress. You will meet with them, and your line manager, every three months.

Your E-Portfolio: OneFile

We use OneFile as our e-portfolio system. This is where your assignments will be set, you will submit your work and you will log your off-the-job training.

Your regular reviews will be stored on here as will some resources for your course. You will complete a learning journal, be able to monitor your progress towards your Knowledge, Skills and Behaviours and refer to your workplace training plan.

Our training video covers all the key features of OneFile you need to know. Visit the Support and FAQs page if you have questions or issues.

Mandatory Units

The JGA Group is strongly committed to practices that protect children, young people and adults from the risk of abuse, neglect or significant harm. Staff recognise and accept their responsibility to develop an awareness of the risks and issues involved with Safeguarding.

Therefore, as part of your enrolment process for your apprenticeship, we require you to complete the JGA Safeguarding – ETF Learners Side-by-Side Courses. Which will introduce you to key topics within Safeguarding.

Side-by-Side is a Prevent resource for learners from the Education and Training Foundation.

The modules will cover:

  • Radicalisation and Extremism
  • Staying Safe Online
  • What can you trust?
  • British Values

Please create a login and complete the Side-by-Side training.

You will be required to complete the module and assessment (short quiz) for the topics in order for you to unlock your certificate.

When you have achieved all four modules mentioned above, please download ALL FOUR certificates, attach and submit them to your assigned task named: JGA Safeguarding (This task will be assigned to you on OneFile after attending your OneFile training session).

Once your certificates have been checked, you will complete your JGA Safeguarding learning aim and it will appear as 100% completed.

View more information and a video guide

For ETF account support please email ETF support directly.

Workplace Training Plan

A Workplace Training Plan is developed with you, your Line Manager and JGA to agree the off-the-job training provided. It will include any specific role related training needs you have to connect with your KSB’s (Knowledge, Skills and Behaviours) and career aspirations.

Delivery to meet the 20% off the job is defined in detail within the workplace training plan. It is a key tool to individualise the apprenticeship to your needs and that of the business.

Programmed Activities

Learner Handbook

Alongside this learner zone, the handbook will help you understand the general expectations of how each party to the apprenticeship should behave (you, your employer and us). It outlines the academic code, how to write assignments and what is unacceptable practice.

Safeguarding, Prevent, Welfare & British Values

Paula Wakelin
Paula WakelinSafeguarding & Prevent Officer
There is nothing more important than keeping you safe. If you or someone you know is at risk, click on the button below to raise your concerns.
We are strongly committed to practices that protect you from the risk of abuse, neglect or significant harm. Our staff recognise and accept their responsibility to develop an awareness of the risks and issues involved in safeguarding. All staff and learners should have zero tolerance for abuse, bullying, neglect and violence.

Prevent is about safeguarding people and communities from the threat of terrorism. At the heart of Prevent is safeguarding children and adults and providing early intervention to protect and divert people away from being drawn into terrorist activity.

We provide expert support to help you on your apprenticeship journey. This includes mental health and neurodiversity, careers guidance and academic and financial challenges.

We want to help you achieve your full potential. We offer careers consultancy to ensure you have impartial and constructive information and guidance to help you decide and then to action your career decisions.

We aim to create an equal, diverse, inclusive and respectful culture. All of us contribute towards this culture through our actions and words. JGA aims to address any barriers to equality in our systems, policies and decision making as well as in our behaviour and ways of working.

The Fundamental British Values underpin what it is to be a citizen in a modern and diverse United Kingdom, valuing our community and celebrating diversity.

There is a code of conduct which applies to you and all learners on our programmes. This lays out the expectations for your behaviour whilst on the apprenticeship.