Data Analyst – Insight Apprentice

Vacancy Details

  • SMG

  • London

Data Analyst

About SMG

We are the UK’s leading shopper media business, offering a unique and collaborative approach that brings retailers and brands together to deliver exceptional results. SMG is the parent company of three small-medium, fast-growing agencies; Capture, Lobster and Threefold, who each have a unique specialism and an unrivalled client list.

Across the group, we have a shared vision and mission to lead connected commerce marketing.

That means our three agencies, along with our group central teams, use their expertise to work with both brands & retailers. We believe that shopper media is the most valuable marketing money a brand can spend. We’re striving to make it more reliable, transparent and effective than any other media. Together with the brands we work with, our retail partnerships and trademarked technology tools, we are changing the category for the better. All of the work we do leads to happier shoppers and brilliant business results.

The role

By joining the team, you will gain experience and develop skills in a wide range of areas, including data cleansing, data quality assurance, sales analysis and process management. You will also be exposed to a wide range of clients across various categories within the FMCG market.

When you join the SMG central team as an Insight Apprentice, some of your responsibilities will include:

  • Creating, tracking and analysing campaigns through test and control analysis.
  • Evaluating campaign performance and uploading data to our in-house shopper insight portal Plan-Apps, which enables our clients to understand the performance and effectiveness of their campaigns.
  • Maintaining a tracker to facilitate the management of the client’s evaluation reviews.
  • Assuring that the data we work with is accurate to be shared with our clients and provides insightful results.

By the end of your 18 months, you will have:

  • Developed your technical skills through the daily use of Excel, R and python and be confident in cleansing and analysing data with good knowledge of creating complex formulas.
  • Built effective and collaborative relationships with internal teams as well as our clients providing solutions and insights to their campaign insights.
  • Acquired strong project management skills, by assisting the insight function in key strategic projects.
  • Developed your data skills and be comfortable in the day-to-day management of tracking trends across campaigns through test and control analysis, as well as interpreting large amounts of data.

The apprenticeship

  • Studying via Avado Learning a Data Analyst Level 4 Apprenticeship
  • Duration of 18 months 80% on the job & 20% learning.
  • Enrolment starts in September 2021.
  • Other optional qualifications include; BCS Diploma in Data Analysis Concepts (optional) and BCS Level 4 Certificate in Data Analysis Tools (optional).

To be eligible you must have:

  • Five GCSE grades C – A* (4-9) or equivalent, including English and
  • A-Levels in ICT/Computing/STEM, or;
  • An Apprenticeship in a similar subject (this must be at least the level below the planned programme), or;
  • A level 3 qualification in ICT or Maths, or;
  • A BTEC Extended Diploma in IT (180 credits), or;
  • Experience working within Data Analytics.

What we look for

  • Passion to grow career within Insight / Data.
  • Good numeracy skills and ability to process and review information quickly and effectively.
  • Computer literacy with some experience using Powerpoint and Excel.
  • Clear organisation ability, with high attention to detail.
  • Eager to learn to use (and improve) new technologies.
  • Ambition, determination, and a curious approach to work.

Our values and behaviours play an important role in determining the behaviours we’d expect to see in someone when they come into the Group. Within each role across the business, we look for the following traits in everyone:

What to expect

By joining SMG, you’ll have excellent development opportunities and will be supported and coached by an established team of professionals.

Other benefits include a competitive package, 25 days’ annual leave, 4pm finish on Fridays, plus many more. In addition, we’ve recently launched a Hybrid Working policy, we understand that life is not all about us – we like to flex around you too so trust our employees and managers to work where best for them. We welcome employees to ask about the flexibility they need and in return we will always explore what is possible.

We are proud to be an equal opportunities employer. We are fully committed to providing equality in the workplace and ensure all opportunities for, and during employment, will be afforded to individuals fairly and irrespective of age, disability, gender, gender reassignment, marital or civil partnership status, pregnancy or maternity, race including colour, ethnic or national origins and nationality, religion or belief or sexual orientation (“the protected characteristics”).

About our agencies

Capture provide a one-stop agency solution removing the barriers to great shopper campaigns. Working across all touchpoints that can influence a shopper to buy (from point of sale to programmatic), which in today’s marketing landscape goes far beyond just ‘cardboard in-store’. We put time, attention and insight into making sure we reach the right shoppers, in the right stores, with the right message, on the right media.

Lobster combines our proprietary software platform Plan-Apps and data analytics with media planning and buying to help clients deliver and demonstrate increasing returns on shopper media investment. We work as consultants within shopper marketing teams and showcase this unique offering to FMCG businesses, sharing expertise across three core services areas, Technology, Trading and Training.

Threefold act as true shopper media partners to retailers, creating happier shoppers, better brand awareness and brilliant business results. We have partnerships with The Very Group, Co-op, Deliveroo and Signet Jewellers. Our Threefold team’s mission is to use creative thinking and precision planning to manage every part of a retailer’s media estate – boosting both their brands and their bottom line.

Location – SE1 3HP