Product Data Assistant

Purchase and Supply Chain Birmingham, United Kingdom


Description

Position at Connect Distribution Services Limited

Here at Connect Distribution, our aim is to be the first choice for home appliance after sales service, spare parts and accessories.

With over fifty years of experience, we are the largest independent home appliance and spare parts distribution organisation within the UK working with a number of household brands including Dyson, Whirlpool, Hotpoint, Hoover and Bosch to name a few!

 

We’re seeking a highly motivated data driven individual to join the Product Data team at Connect Distribution to assist in maintaining our part and model association dataset of over 60 million records. The role will combine elements of manipulating and cleansing large data sets. This is a great opportunity to showcase your analytical skills and join an expanding department

The role will involve:

  • Creating formulas and querying data in Excel to ensure validity
  • Extracting data from various sources
  • Formatting and cleansing data
  • Loading data onto in-house systems
  • Audit checks of data
  • Optimising data loading process
  • Providing ad-hoc reports
  • Collaborate with cross-functional teams to ensure model and parts data is readily available on websites
  • Maintaining current brand shops and creating new brand sections and categories when required

As Product Data Assistant you will need:

  • Advanced Microsoft Excel Skills (Macros, Pivot Tables, If Statements, Vlookups)
  • Excellent analytical and problem-solving skills
  • Previous experience of working with large data sets
  • Ability to work to dead line and manage own time effectively
  • Excellent written and verbal communication skills
  • A positive 'can-do' attitude

 

 

We would be really excited if you have:

  • SQL Knowledge
  • Working knowledge of Databases (Microsoft Acess and Lotus Approach)
  • White goods industry experience

What we offer:

  • Free on-site parking
  • 31 days annual leave (including bank holidays)
  • Pension scheme
  • Access to over 250 discounts including high street and online shopping, travel, technology, entertainment, food and drink and many more via Perkbox
  • Social events
  • Potential to win access to Football tickets for Birmingham City home games
  • Staff discounts on all products