استخدام supply planning specialist

توضیحات آگهی

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
شرکت زرینو Zarrino
دسته بندی خرید و بازرگانی
نحوه همکاری تمام وقت
نوع همکاری حضوری
مدرک تحصیلی کارشناسی
سابقه کار کمتر از سه سال
حقوق توافقی
جنسیت مهم نیست
مهارت ها Power BI FMCG Planning
شهر تهران تهران