CPM Inventory Analyst (Diageo)

at  CPM Ireland

Are you a Data & Insights professional with Inventory experienced in stock control and stock analysis functions. Do you pride yourself on your attention to detail? If yes, we may have the role for you! The CPM Stores team are responsible for the management of Diageo beer dispense equipment across warehouses in Kilcock, Belfast and several sub stores across Ireland. They are a key link in ensuring consumers always receive the perfect pint of Diageo’s market leading draught beer brands such as Guinness, Harp, Rockshore, Carlsberg or Smithwick’s in every on-trade account across the Island of Ireland.
The Analyst will be responsible for monitoring and analysing inventory levels, identifying gaps and trends, and making recommendations to optimize Sales Performance & inventory management. This role will work closely with our client Diageo and the wider QSP management team to ensure inventory accuracy and availability to meet business demand. The role will be based between our main store in Kilcock, County Kildare and our head office in Cookstown, Dublin
Every member of the CPM team contributes to the overall growth of our business. People are at the core of CPMs business proposition so as a key member of the QSP team this role is expected to make a significant contribution to delivering value for our client demonstrating initiative to drive best practice and continuous improvement. A “can-do” attitude combined with a customer-centric focus is essential for success in this role.

REQUIREMENTS

• Previous experience of working in an Inventory Analyst role or in similar roles.
• Can clearly demonstrate a strong knowledge of inventory management principles and best practices
• High degree of numeracy.
• Strong analytical and problem-solving skills to analyse data and present back in concise and understandable format, such as dashboards, graphs, tables and diagrams.
• Excellent working knowledge of Microsoft Excel is essential (VBA, lookups, pivots, macros and databases).
• Experience and knowledge of Salesforce and Power Bi desirable.
• Good understanding of financial aspects and KPIs as they relate to inventory management.
• An acute eye for detail and numbers.
• Self-motivated with the ability to work independently and meet deadlines.
• Effective communication and interpersonal skills.
• Ability to work collaboratively with cross-functional teams.
• Highly organised and methodical.
• Knowledge of beer dispense equipment desirable.

• Be the go-to subject matter expert for the analysis, tracking and reporting of all stock CPM manage for our client Diageo.
• Work with Asset Track, our stock management system designers, to ensure accurate reports and dashboards are developed and implemented to meet CPM and our Client Diageo’s needs.
• Ensure all Diageo beer dispense equipment is accurately recorded and tracked from supplier delivery to storage in warehouse and Rep vans to installation in outlet and develop accurate reports to highlight any variations or discrepancies in this process.
• Work with the QSP Management team to ensure equipment is accurately recorded in trade on an ongoing basis.
• Establish a robust control environment with reconciliation and audit processes in place to mitigate risks associated with inventory management.
• Ensure all stock movements are mirrored on the Asset Track stock system and ensure stocks are reconciled on a weekly basis.
• Ensure all held stock provisions and write-offs are accounted for in Asset Track.
• Hands on inventory management with the primary objective of maintaining accurate inventory records across both our systems and physical locations.
• Regular monitoring and reporting of inventory levels, age, condition, and turnover to ensure that value is maximised and that actions are developed and executed expediently to address any discrepancies or deviations.
• Effectively plan, manage, and control all stock and perpetual inventory management checks.
• Continually review the replenishment process.
• Support Diageo when launching any new draught or draught spirit brands.
• Be able to identify variances in actual demand vs planned demand and to make informed changes to forecasts and supply chain plans to minimise shortages and overstocks.
• Identify potential stock shortages, excess stock and stock errors.
• Work with the Diageo to ensure an accurate Demand planning process is in place.
• Implement processes to flag potential issues before inventory is replenished.
• Implement processes to facilitate short term and long-term supply planning to achieve adherence to schedule in production scheduling and On Time Delivery.