Commercial Team Admin Apprentice – Bilston, Wolverhampton

Level 3 Data Foundations

Company: British Car Auctions

Full Address: Bessemer Close, Bilston, Wolverhampton WV14 0RZ

Weekly Hours Worked: 8:30 AM to 5:30 PM with 1-hour lunch

Salary: £14,500 PA

Interview process will be 1 interview in the office.

Please contact Ami on Ami.Wilson@estio.co.uk or call 01133 500 333

About the company:

British Car Auctions (BCA) is the UK’s largest used vehicle business. They offer end-to-end vehicle remarketing services in the UK and Europe. Here are some key points about BCA:

Scale and Services: BCA provides a wide range of services to meet the needs of an impressive portfolio of customers. These services include:

• Portside New Car Activity: Handling new cars at ports
• Refurbishment: Preparing used vehicles for sale
• Storage: Safekeeping of vehicles
• Imaging: Creating visual content for marketing
• Funding Solutions: Assisting with financing
• Logistics: Managing transportation1

Remarketing Operation: BCA plays a crucial role in the growing used vehicle sector. They connect various services to ensure efficient remarketing of vehicles, both online and at physical auction houses1.

Accessibility: BCA operates car auctions across the UK, making it accessible to both buyers and sellers. Whether you’re participating in physical auctions or exploring their online platform, BCA offers valuable information and support for those interested in buying or selling vehicles2.

In summary, BCA is a significant player in the European used car marketplace, providing comprehensive services to facilitate the buying and selling of vehicles.

Brief job description:

Estio Training have an exciting new opportunity for a Data Technician Apprentice with British Car Auctions, a Vehicle auction company based in Wolverhampton.

Job Description:

This is an exciting opportunity for a talented individual looking for a Commercial Team Admin Apprentice. This opportunity will suit an individual working towards Commercial Team Executive or a candidate with a natural desire to succeed, striving to take the next step in their career.

Purpose of Job:

You will be working alongside Commercial Team Executive responsible for supporting in providing accurate pricing analysis. These analyses enable commercial decisions to be made based upon clear presentation of data.

Your duties and responsibilities in this role will consist of:

Key responsibilities and duties – daily tasks will include but not be limited to:

• Pricing Vehicles on daily basis ensuring all vehicles are identified correctly, any anomalies are passed to Auctions for further investigation also ensuring model is producing values within agreed tolerance anything outside is referred to Commercial Team Executive for further detailed analysis.
• Recording Auction’s responses correctly in data base and ensuring it’s kept up to date.
• Producing Auctions sales files for remarketing mangers.
• Ensure all Pre-sale reports are received within agreed SLA with minimum queries left to investigate.
• Investigating any missing data or inconsistencies in Sales files.
• Supporting Commercial Team Executive with Daily/weekly and monthly P&L analysis.
• Send operational reports to remarketing managers.
• Pricing vehicles to purchase ensuring risk is mitigated and smooth delivery is possible within agreed SLA.
• Support Commercial Team Executive in building new reports as requested by Head of remarketing or other internal / external customers
• Use your Microsoft Excel skills to create detailed spreadsheets for ad-hoc tasks whilst developing them further with the help of Commercial Team Executive.
• Build understanding of R pricing model and run daily Analysis.
• Update and provide cube reports to relevant customers.
• Stock Analysis on daily basis chasing auctions for any vehicles not entered in sales within agreed SLA keeping remarketing managers informed at all times.
• Build a good working relationship with auctions and understand their daily challenges and how we can support them.
• Ultimately Commercial department is responsible for identifying vehicles correctly, pricing them as accurately as possible and smooth running of auctions.
• Some knowledge of Microsoft Excel is required but we will provide complete training for the right candidate.

Qualifications:

5 GCSEs grades A*-C/9-4 or equivalent (including English Language and Maths)

Skills & Personal Qualities Required:

• Communication skills
• Organisation skills
• Experience with Excel
• Microsoft Office packages
• Willingness to learn
• Driven to succeed

Future prospects:

The role offers long term security and the opportunity to progress into a permanent position.

Training to be provided:

Estio apprenticeship training programmes are delivered virtually by our fully qualified and industry experienced training team. Using their expert knowledge, we’ve purposefully built our programmes around the real-world use of modern technology, so that the skills we create can be directly applied in the workplace.

Throughout the apprenticeship learners receive coaching, help and guidance from a dedicated team who are there to ensure they get the most from their work experience.

Successful completion of this apprenticeship gives you an accredited Level 3 Data Technician, with training in how to:

• Identify the right data sources for your business to inform decision making.
• Collect, compile and cleanse data accurately and securely.
• Identify, anaylse and interpret data, trends and patterns.
• Produce dashboards and reports to aid visualization and comparison.
• Summarise and present the results of data analysis, making recommendations for business improvement.
• Store and archive data in line with data protection legislation.