Planning & Forecast Analyst

New
P
Plus FortyJewelry retail
Remote / Virtual (Philippines), EST — available 8:00 AM–2:00 PM Eastern for live collaboration with the teamFull-TimeMiddle
Salary12 - 15 USD per hour
Apply NowOpens the employer's application page

Job Details

Required Skills
Microsoft ExcelGoogle Sheets

Requirements

  • Use Claude day-to-day to run, question, and update the planner.
  • Bring a strong math and modeling background, including forecasting, statistics, and building and stress-testing model logic.
  • Be comfortable working with large SKU-level datasets in Excel or Google Sheets.
  • Have a background in analytics, finance/FP&A, data science, economics, or a similar quantitative field.
  • Explain numbers clearly to merchants, eCommerce, and Amazon partners.
  • Pay close attention to SKU-level outliers and assess whether figures make sense for the business.
  • Adapt as the model, priorities, and data evolve month to month.
  • Be available 8:00 AM–2:00 PM Eastern for live collaboration.

Responsibilities

  • Run the OTB Planner each month and prepare recommended replenishment buys for DTC and Amazon.
  • Review SKU-level forecasts before they become purchase orders, and flag and resolve outliers.
  • Reconcile SKU-level buys to the OTB dollar plan by channel, category, and month.
  • Analyze demand drivers, including promotions, traffic, FBA constraints, seasonality, and gifting peaks.
  • Identify projected stockouts, overstock, and slow-moving SKUs.
  • Model launch and fade curves for new SKUs, including ramp, peak, and rebuy timing.
  • Design, build, back-test, and roll out evidence-backed planner logic updates.
  • Version and document logic changes, and roll back changes that underperform.
  • Present monthly buy recommendations and explain model outputs to merchandising, eCommerce, and Amazon partners.
  • Lead weekly model reviews of sales versus forecast, missed SKUs, and potential logic changes.
View Full Description & ApplyYou'll be redirected to the employer's site
12 - 15 USD per hour
Apply Now