Job Description
About the Role
We are a jewelry and accessories brand operating across DTC and Amazon channels, looking for a Planning & Forecast Analyst to own our OTB Planner and turn SKU-level forecasts into confident monthly replenishment buys.
Our OTB Planner was built in Claude and went live recently — it produces the numbers, and this role makes sure they're right, explains what they mean, and improves the logic as we learn where it's strong and where it misses. This is half analyst, half model builder: you'll review every cycle's output and challenge outliers, then build and ship the logic changes yourself directly in Claude.
Our business runs on thousands of SKUs, many of which launch strong and fade quickly — making demand hard to predict. This role exists to model those launch-and-fade patterns and keep the buy right across the whole assortment.
Work Structure & Requirements
- Location: Remote / Virtual (Philippines)
- Schedule: Full-time
- Time Zone: EST — available 8:00 AM–2:00 PM Eastern for live collaboration with the team
- Compensation: $12–$15 USD per hour
Key Responsibilities
- Monthly Replenishment Cycle
- Run the OTB Planner each month and prepare the recommended replenishment buy for DTC and Amazon
- Review SKU-level forecasts line by line before they become POs; flag and resolve outliers
- Reconcile the SKU-level buy back to the OTB dollar plan by channel, category, and month
- Data Analysis
- Separate DTC and Amazon demand drivers — promotions, traffic, FBA constraints, seasonality, gifting peaks
- Identify at-risk SKUs early: projected stockouts, overstock, and slow movers
- Build simple, repeatable views that show the buy, the risks, and what changed since last month
- Model Logic & Development
- Model launch and fade curves: how fast new SKUs ramp, when they peak, and when to stop rebuying
- Design and build logic updates (seasonality weights, safety stock, lead times, new-item and end-of-life rules, channel splits) backed by evidence
- Back-test every change against recent history, get sign-off, roll it out, and roll it back if it underperforms
- Version and document every logic change so the team always knows what the model is doing and why
- Communication & Reporting
- Present the monthly buy recommendation with a short read on risks and changes
- Answer why is the model saying this? for merchandising, eCommerce, and Amazon partners
- Lead weekly model reviews covering what sold vs. forecast, which SKUs are being missed, and what logic changes to test next
Required Skills & Experience
- AI Fluency: Works in Claude day-to-day to run, question, and update the planner — this is core to the role, not a nice-to-have
- Quantitative Skills: Strong math and modeling background — forecasting, statistics, and building and stress-testing model logic
- Data: Comfortable working with large SKU-level datasets in Excel or Google Sheets
- Attention to Detail: Catches the outlier SKU before it becomes a bad PO
- Communication: Explains numbers clearly to merchants, eCommerce, and Amazon partners
- Adaptability: Comfortable as the model, priorities, and data evolve month to month
- Business Curiosity: Checks whether a number makes sense for the business, not just whether the math is right
- Background: Analytics, finance/FP&A, data science, economics, or a similar quantitative field — retail planning experience helpful but not required
Nice to Have
- Retail planning experience (OTB, replenishment, weeks of supply)
- Amazon Seller/Vendor Central experience (FBA inventory, in-stock, replenishment)
- DTC / Shopify eCommerce experience
- Experience forecasting short-lifecycle or high-SKU-count products
- Jewelry, accessories, or fashion retail background