We’re looking for a Supply Planning Specialist who is responsible for developing, executing, and maintaining tactical replenishment plans, monitoring daily stock levels, optimizing inventory parameters (safety stocks, ROP, ABC-XYZ), and tracking purchase order lifecycles through ERP systems to ensure high service levels and prevent stockouts.

This role requires strong quantitative rigor, advanced modeling skills in Microsoft Excel and Power Query, working knowledge of SQL and Python for data extraction and automation, and disciplined cross-functional collaboration with procurement, warehouse, logistics (3PL), and commercial teams.

Key Responsibilities

• Operational Replenishment & Supply Planning: Build, execute, and adjust tactical replenishment schedules aligned with demand forecasts, warehouse capacity constraints, and target service levels.

• Inventory Control & Policy Maintenance: Monitor SKU-level stock positions daily to eliminate stockout risks while avoiding excess inventory; calculate dynamic safety stocks, reorder points (ROP), and conduct ABC-XYZ analyses to optimize working capital.

• PO Lifecycle Management & Supply Tracking: Plan, generate, release, and monitor purchase orders (POs) in ERP systems (SAP, Rahkaran), ensuring supplier delivery dates match agreed lead times.

• Cross-Functional & Partner Coordination: Collaborate daily with suppliers, 3PL logistics providers, warehouse operations, procurement, and commercial teams to resolve fulfillment bottlenecks and inbound delivery variances.

• Supplier Performance & KPI Monitoring: Track and report vendor metrics—including lead time variability, On-Time In-Full (OTIF), and fill rates—supporting supplier review and performance improvement initiatives.

• Data Extraction & Dashboard Maintenance: Query transactional data using SQL and ERP platforms; build and maintain operational KPI dashboards in Excel (Power Query) and Power BI.

• Process Automation & Modeling: Assist in automating recurring planning calculations, inventory simulations, and data pipelines using Python (pandas, NumPy) and advanced Excel models.

• Discrepancy Resolution & Audit Support: Participate in periodic physical stock counts and investigate root causes of system-versus-physical inventory discrepancies.

Qualifications & Requirements

• Bachelor’s degree in Industrial Engineering, Supply Chain Management, Operations Management, Business Administration, or a related quantitative field.

• 1–2 years of hands-on experience in supply planning, inventory control, or supply chain data operations.

• Advanced proficiency in Microsoft Excel and Power Query for data reconciliation and automated replenishment modeling.

• Working proficiency in SQL (T-SQL/PostgreSQL) for transactional data extraction from relational databases.

• Hands-on experience with ERP/MRP platforms (such as SAP or Rahkaran) for PO tracking and inventory parameter maintenance.

• Solid understanding of core inventory concepts: safety stock formulas, lead-time variance, EOQ, ROP, and service level trade-offs.

• Strong analytical, root-cause investigation, and cross-functional communication skills.

Preferred Qualifications (Nice to Have)

• Practical experience using Python (pandas, NumPy) for operational scripting, simulations, or reporting automation.

• Experience building interactive supply chain dashboards in Power BI or Tableau.

• Familiarity with APICS frameworks (CPIM/CSCP fundamentals) and Sales & Operations Planning (S&OP) cadences.

• Prior supply chain experience within fast-paced B2B e-commerce, retail distribution, or FMCG environments.

What Makes This Role Unique

Supply planning is the operational bridge between commercial demand and physical fulfillment. In this role, you hold direct influence over platform availability, stock turnover, and capital efficiency—leveraging data analytics, SQL, and automation tools to solve real-world inventory challenges and build scalable replenishment workflows across a growing marketplace network.