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