Customer Service Asst Analyst - French Speaker

PepsiCo · New Cairo

Overview

The VMI Analyst ensures efficient inventory management by monitoring, analyzing, and optimizing stock levels at customer or distributor locations. This role involves coordinating data flows, ensuring accuracy, and collaborating with internal stakeholders (Supply Chain, Sales, Logistics, Finance) and external partners to ensure products are available when needed, costs are optimized, and customer service levels are met.

Responsibilities

Inventory Monitoring & Management

Track customer or distributor inventory levels (by SKU), sales velocity, and consumption trends.
Use VMI agreements/data sharing to trigger replenishment orders.
Identify overstock and stockout risks, implement corrective actions.
Maintain Days on Hand (DOH) targets.
Coordinates NPD execution for his/her customer (weekly) - minimizes obsoletes and maximizing speed to shelve

Order Replenishment & Optimization

Create and process replenishment orders, ensuring accuracy in quantities, pricing, delivery schedules.
Optimize logistics (e.g. combining shipments, full truckloads) to reduce costs.
Manage order changes, cancellations, exceptions.
Align closely with the Transportation Team to ensure timely and accurate deliveries.
Respond promptly to any transportation issues, ensuring quick problem resolution and client communication.
Check Daily and Weekly reports related to orders issues like (open orders, incomplete orders, gtms…)

Data Quality & Systems Management

Ensure data feed/flows between customer systems, PoS, ERP, and VMI tools are accurate and timely.
Identify and correct data errors (discrepancies in inventory, forecasting, order processing).
Be a key user / liaison for any tools supporting VMI (systems implementation, data integration, dashboards).

Customer Communication & Relationship Management

Serve as the primary point of contact for client’s concerns.
Proactively communicate Out of Stock (OOS) situations to clients in advance and collaborate with the Product Availability Team to resolve them.
Host weekly operational meetings with clients and monthly business reviews with stakeholders to provide updates on KPIs, issues, and improvement actions.
Maintain strong business relationships with clients and internal Business Units (BUs) to build trust and improve collaboration.
Manage and respond to client inquiries via Cisco hotline during assigned shifts.

Continuous Improvement

Identify root causes of recurrent issues.

Implement process improvements, standardization, automation where relevant.

Support system rollouts or upgrades related to VMI.

Qualifications

Skills & Qualifications:

Bachelor’s degree (Supply Chain / Logistics / Business / Engineering) or equivalent.
Experience in supply chain / inventory management, ideally with VMI or similar models in FMCG or consumer goods.
Strong analytical skills; ability to work comfortably with large data sets.
Good knowledge of forecasting, inventory planning and replenishment techniques.
Proficiency with relevant software: Excel (advanced), ERP tools, VMI systems, data dashboards (e.g. BI tools).
Strong attention to detail, and ability to work across multiple SKUs, customers, regions.
Good communication skills; capable of working with internal teams and external partners.
Fluency in English/French (written & spoken).
Ability to handle change, ambiguity; proactive mindset.