Data Analytics - Business Administration Apprentice STEPHENSONS ONLINE LTD

To support the business in the provision, maintenance, and development of data analysis via a suite of reports. Creating bespoke reports to provide Brand, Sales, and Stock information to enhance performance in all areas of the business.

Sign in to apply

Closing date: 31 Mar 2023

Apprenticeship summary

  • Annual wage


  • Working week

    Monday - Friday, 08:00 - 17:00

    Total hours per week: 40.0

  • Expected duration

    18 Months

  • Possible start date

    04 Apr 2023

  • Date posted

    05 Mar 2023

  • Apprenticeship level

    Level 3 (A level)

  • Reference number


  • Positions

    1 available

What will the apprentice be doing?

  • Identify and carry out the correct collection and utilisation of raw data for use in a variety of Excel models for reporting purposes
  • Navigate and maintain an array of formulas within existing Excel models and design new ones to ensure reports remain fit for purpose
  • Identify and raise sales trends to your line manager, SLT & CEO
  • To identify, collect and migrate data to and from a range of internal and external systems; manipulating and linking different data sets as required
  • To perform regular data quality checking and cleansing tasks on existing reporting models to ensure that the data being reported on is correct and accurate
  • To use a range of analytical techniques such as forecasting and modelling to identify and predict trends and patterns in sales
  • To produce and maintain performance dashboards and reports
  • To apply the tools and techniques for data analysis, data visualisation and presentation
  • To summarise and present the results of data analysis to a range of stakeholders and make recommendations to improve business performance based on that analysis
  • To produce data reports using excel for Platform Management department
  • To monitor the @reports inbox and reply or escalate queries to the relevant member of staff
  • To make amendments and maintain the Banned Ingredients file, ensuring the file runs correctly and is updated when new banned ingredients are identified

What training will the apprentice take and what qualification will the apprentice get at the end?

  • Business Administrator Level 3 Apprenticeship Standard
  • Training to take place at Booth Lane, Northampton College, NN3 3RF - 1 Day a month

What is the expected career progression after this apprenticeship?

  • Potential for a full-time position once the apprenticeship is complete and progression within the company.

Requirements and prospects

Desired skills and personal qualities

Communication skills, IT skills, Attention to detail, Organisation skills, Administrative skills, Analytical skills, Logical, Team working, Initiative


GCSE or equivalent English (Grade 4/C) Essential
GCSE or equivalent Maths (Grade 4/C) Essential

About the employer

Stephensons Online LTD is a global 3rd party retailer of Health and Beauty brands. We partner directly with brands and brand owners to deliver the brands global 3rd party platform strategy whilst buying and selling their brand across the world. Started by 2 entrepreneurs' with just £10, today, Stephensons Online LTD has an annual turnover of $10 million and has never taken a loan, investment or even an overdraft. Now employing over 25 people based in Northampton we continue to show outstanding growth in all elements including brands joining us, sales and countries sold into. This is a highly exciting time to be joining such a fast pace and successful company, with a truly inspiring story.




Primus House

Cygnet Drive

Swan Valley


You must have JavaScript enabled to view a map of the location


Training provider



Isobel McColgan

01604 734138

Apprenticeship standard

Business administrator

Level 3 (A level)

Before you apply

Before you apply for an apprenticeship you must first create an account. If you already have an account you'll need to sign in.