Merchandising Administrator

Merchandising Administrator

Apprenticeship 24000 - 26000 £ / year (est.) No working from home possible
S

At a Glance

  • Tasks: Support merchandising through data management, analysis, and reporting while learning about ERP systems.
  • Company: Join a dynamic company transitioning to a new ERP system with a focus on data.
  • Benefits: Earn a competitive salary while gaining valuable skills and a Level 4 Data Analyst qualification.
  • Other info: Enjoy a supportive environment with growth potential and training in industry-standard tools.
  • Why this job: Kick-start your career in data with hands-on experience and professional development opportunities.
  • Qualifications: GCSE Maths and English at grade 4/C, plus a passion for data and merchandising.

The predicted salary is between 24000 - 26000 £ per year.

Kick-start your career in data with a unique opportunity to develop technical, analytical and business skills.

As part of a Level 4 Data Analyst apprenticeship, you'll support key business operations and contribute to an exciting ERP system transition, gaining valuable experience and highly sought-after industry skills.

The successful candidate will provide support to the Merchandising function through accurate data management, analysis, reporting and stock administration.

This is a development role combining practical experience in data analysis and merchandising with a Level 4 Data Technician apprenticeship.

The successful candidate will develop an understanding of how accurate product, stock and commercial data supports effective business decisions, while gaining practical experience of working with business systems and data.

The role will work closely with the Head of Merchandising and relevant teams across Production, Logistics, Quality Control, Finance, Wholesale and Retail.

A key part of the role will be supporting the Company's upcoming transition from its existing ERP system to a new ERP system.

The Apprentice will assist with data preparation, cleansing, validation, migration testing and documentation, gaining practical experience of data migration and systems implementation.

The role will develop over the course of the apprenticeship, with responsibility increasing as the Apprentice gains knowledge, confidence and technical capability.

Key Responsibilities

  • Support the Head of Merchandising with the day-to-day management and analysis ofstock information.
  • Assist with the collection, organisation and analysis of product, stock, sales, sell through and production data.
  • Maintain accurate datasets and reporting files, ensuring information is complete, consistent and up to date.
  • Support the preparation of regular and ad hoc reports including stock availability, sales, sell through, best sellers, and production reports.
  • ERP System Migration Project

The Apprentice will play a supporting role in the Company's upcoming transition from its existing ERP system to a new ERP system.

These duties will be variable and dependant on which system is chosen etc. but may include:

  • Supporting the preparation of existing data for migration into the new ERP system.
  • Supporting the review and mapping of existing data fields to the new system.
  • Assisting with data validation and reconciliation before and after migration.
  • Supporting the testing of migrated data to ensure information is accurate and complete.
  • Working with the Head of Merchandising and relevant projectstakeholdersto ensure data-related tasks are completed accurately and within agreed timescales.

You will not be expected to have prior ERP migration experience and will receive appropriate guidance and supervision while developing these skills.

  • Apprenticeship & Professional Development
  • Attend all required apprenticeship training and coaching sessions.
  • Complete apprenticeship assignments, assessments and workplace activities within agreed timescales.
  • Maintain an appropriate portfolio of evidence demonstrating the development of knowledge and skills.
  • Make effective use of the Company's working time allocated for off-the-job apprenticeship training.
  • Take responsibility for personal learning and development, with support from the line manager and Development Coach.
  • Apply learning from the apprenticeship directly to workplace activities.
  • Develop knowledge of data governance, GDPR, data security and responsible data handling.
  • Develop skills in data collection, migration, cleaning, transformation, analysis and visualisation.
  • Develop the ability to communicate data insights effectively to both technical and non-technical colleagues.
  • Entry requirements
  • A minimum grade of 4/C in GCSE Maths and English.
  • A genuine interest in data, analysis, merchandising and how data can support business decisions.
  • Previous experience using Excel or other data analysis tools.
  • Strong attention to detail and a methodical approach to work.
  • Good numerical and analytical skills.
  • Good organisational and time-managementskills.
  • Good communication and interpersonalskills.
  • Ability to follow processes and procedures while also identifying opportunities for improvement.
  • A proactive approach to problem-solving.
  • An interest in the jewellery industry.
  • Previous retail, wholesale, manufacturing or merchandising experience.
  • Basic knowledge of data analysis, reporting or visualisation.

Skills required

  • Analytical skills
  • Initiative
  • Training to be provided

As part of the Level 4 Data Analyst Apprenticeship, you'll develop the skills to collect, analyse and interpret data to support business decision-making.

You'll gain hands-on experience using industry-standard tools and techniques, including SQL and Python, while learning how to manage data projects, build reports and dashboards, and communicate insights effectively to stakeholders.

You'll also develop an understanding of data quality, governance and ethical data practices.

15 month practical period with a 12 week End Point Assessment.

Things to consider

Upon completion go the apprenticeship you will receive a level 4 certificate in Data Analyst Apprenticeship, which will allow you to join the British Computer Society (BCS) as an Associate Member.

  • Location
  • At a Glance

Salary

£ 24000per year

Working week

Monday-Friday

Duration

18 Months

Apprenticeship standard

  • Data analyst (Level 4)
  • #J-18808-Ljbffr

Merchandising Administrator employer: Skern Training

Bishop Ramsey C Of E School is an exceptional employer that fosters a supportive and inclusive Christian learning community for both staff and students. With a strong emphasis on professional development, apprentices will receive comprehensive training and mentorship while working in a dynamic environment that values collaboration and innovation. Located in Ruislip, the school offers a unique opportunity to contribute to the educational journey of young people while gaining valuable experience in IT support.

S

Contact Details:

Skern Training Recruitment Team

StudySmarter Expert Advice🤫

We think this is how you could land Merchandising Administrator

Get Involved in Data Science Communities

Dive into online forums like Kaggle or GitHub where data science enthusiasts hang out. Participating in competitions or contributing to open-source projects can really make you stand out and show off your skills!

Tap Into University Resources

Your uni career services are gold mines for apprenticeships! Attend any workshops or career fairs they host; you might just bump into employers looking to scout fresh talent for programmes like the one at Skern Training.

Work on Real-World Data Projects

Create your own data science projects or collaborate with classmates on interesting datasets. This not only sharpens your skills but also gives you something to showcase during interviews, setting you apart from the competition.

Show Off Your Passion

Don’t just rely on formal applications! Write blog posts about your data science journey or share insights on social media. This can catch the eye of Skern Training and show them you’re genuinely passionate about the field.

We think you need these skills to ace Merchandising Administrator

Data Analysis
Excel
Attention to Detail
Organisational Skills
Time Management
Communication Skills
Problem-Solving Skills

Some tips for your application 🫡

Show Off Your Relevant Skills:For a data science apprenticeship, make sure to highlight your skills in statistics, programming (especially Python or R), and data visualisation tools. Mention any relevant projects or coursework where you've applied these skills, even if it’s just in a school setting!

Tailor Your Motivation:In your cover letter, focus on why you want to dive into data science specifically. Share how this apprenticeship aligns with your career goals and learning aspirations. Remember, this is about showing us at Skern Training that you're eager to learn and grow in the data field!

Portfolio Power!:Even if it's an apprenticeship, having a small portfolio of your data projects can set you apart. Include any analyses, visualisations, or data science-related tasks you’ve completed, whether on your own or as part of your studies. This shows that you've got hands-on experience, which is super appealing.

Keep It Relevant and Concise:Your CV should be focused and relevant – keep it to one page if possible! Tailor it for the data science role by including specific coursework, skills, and any experience with data handling. If you’ve done any data-related activities in clubs or competitions, throw those in too—every bit counts!

How to prepare for a job interview at Skern Training

Brush Up on the Basics

Before your interview with Skern Training, we need to nail down the fundamentals of statistics and machine learning. As an apprenticeship candidate, they’ll be keen on your understanding of key concepts—so make sure you can talk about linear regression, classification, and maybe even some hands-on work with tools like Python or R.

Showcase Your Projects

Bring any portfolios or projects you've worked on that highlight your data analysis skills. Even if they're for school or personal projects, being able to demonstrate how you approached a problem, analysed data, and derived insights will give you a leg up. Don't just talk about the data—show them what you've done with it!

Get Comfortable with Technical Questions

Expect some technical questions that test your problem-solving skills! You might be asked to explain how you would approach a specific dataset or solve a classic data challenge. Practise explaining your thought processes clearly, as this will showcase your analytical abilities as well as your ability to communicate complex ideas.

Emphasise Your Willingness to Learn

As an apprentice, your eagerness to learn is your biggest asset. Be prepared to discuss what you're looking to gain from the apprenticeship at Skern Training. Whether it's mastering new programming tools or applying theoretical knowledge to real-life problems, let them know you're all about growing your skills and contributing to the team!