In retail, employees come and go….A LOT!! There is a lot of turnover, a lot of part-time staff, a lot of temporary staff for busy periods, and a lot of new hires for high growth retailers. Retailers have multiple systems where employee information is required . Whether employee is a sales associate, store manager, buyer, warehouse staff, or executive, each and every employee must be maintained in multiple systems. How is this all managed? From my experience, poorly!!
Typically, this is a very manual and laborious process that is highly error prone. Retailers may spend hours a day adding and maintaining employees across all systems. When a new employee is entered in HR, the same basic information must be entered and shared in other systems too – POS, Sales Audit, Loss Prevention, CRM, Merchandising, WMS, etc. A change to that employee’s information or status will require similar changes across multiple systems. Employees need access to the right systems with the right permissions at the right time. A new employee arriving at a store but not being able to log into POS or Inventory Control systems, can be a costly error and wasted time. When did entering an employee become so complicated?
At RIBA Retail, we often see this situation, and the retailer ends up with many laborious steps, incomplete information, or data integrity issues. Here are 3 approaches to consider, from least preferable to most preferred:
- Manual - One internal system must “own” the Employee Master record and then share that with all other systems. Typically transmitted via paper or email, so that other system “owners” can update their systems, with the new or changed employee information. With a rigid process in place, this approach can work, but is obviously very laborious, untimely, and error-prone.
- Automated - As above, one internal system must be the “owner”, typically HR, and other systems are then automatically updated through integration or publish/subscribe type mechanisms. This works well if all the validation, error-handling, and synchronization is well accounted for. In some cases, additional employee information must be updated in the destination system, causing another set of manual steps that must occur in a timely fashion.
- Master Data Management (MDM) - Centralize the ownership of ALL employee data in one repository. From here, using automated integration or a publish/subscribe method, all other internal systems will receive these updates in a timely and automated fashion. If properly designed, the centralized MDM repository will have ALL information needed for ALL systems, and therefore employee data need only ever be touched in one place, resulting in automatic updates to all other systems.
We have successfully helped retailers improve their integration and automation using such techniques. What would you recommend? What techniques have you used? I would love to hear from you based on your own experience.



