Inventory & Supply Planning Specialist (Shopify + Amazon)

Who we are ARES is a fast-scaling DTC menswear brand (premium underwear). We sell through our own Shopify store and Amazon (FBA), we stock across multiple warehouses (China + USA), and we're scaling aggressively month over month. Right now our inventory is managed with zero real system. That's the problem you're here to fix. We don't want someone to just "update numbers" — we want an owner who builds the forecasting engine, tells us what to reorder and when, and makes sure we never stock out during a scaling push or a big sales event. What you'll actually do Own one master inventory spreadsheet (Excel / Google Sheets) tracking stock across every channel: Shopify, Amazon FBA, China warehouse, USA warehouse. Forecast demand per SKU and flag reorders before we run out — factoring in supplier lead times (China production + freight). Model scaling scenarios — when we increase ad spend and sales grow +X%, you project the stock impact and adjust reorder quantities accordingly. Plan for events — Q4, Black Friday / Cyber Monday, promo pushes, product launches. You forecast the spike and make sure we're covered weeks ahead. Track FBA stock levels in the master sheet and flag when Amazon needs replenishment (you won't manage Seller Central directly — you monitor and alert). Verify supplier invoices — check quantities, unit costs and totals against POs, and flag any discrepancy before payment. Weekly reporting — a clean, simple dashboard: current stock, weeks of cover remaining, reorder alerts, upcoming risks. Our stack Shopify (main store) Amazon Seller Central / FBA (you monitor the numbers, not the account) Excel / Google Sheets (this is your primary tool — we prefer a clean, well-built spreadsheet over expensive software) Warehouses: China (production + fulfillment) + USA (soon) You're a fit if you have Real DTC experience (Shopify brands) AND experience tracking Amazon FBA inventory — this is non-negotiable. Please don't apply if you've only done generic warehouse admin. Strong forecasting / demand planning skills — you can build a reorder model from lead times and sales velocity, not just log numbers. Advanced Excel / Google Sheets — formulas, pivot tables, clean dashboards. Show us you can build a system, not just fill a template. Invoice / PO reconciliation experience. Proactive communication. You flag risks before they become stockouts. You don't wait to be asked. Fluent written English. Nice to have Experience with inventory-planning tools (Inventory Planner, Cin7, SoStocks, etc.) — but we're deliberately starting with a spreadsheet. Experience with brands scaling fast on paid ads. Short, clear reasoning is what we're looking for — not a perfect number. The deal Start ~5-15 hrs/week, part-time. This grows into a bigger, long-term role as we scale. Fully remote, flexible hours. How to apply Start your proposal with the word "SILK" so we know you read this fully. One example of an inventory/forecasting system you built (a spreadsheet screenshot or short description). Which DTC brands + Amazon accounts you've managed inventory for. Applications without the code word will be ignored.