Planning & Forecast Analyst
Budget / Salary$12–15
TypeFull-time job
LocationPhilippines
Posted1 hour ago
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
1. 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
2. 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
3. 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
4. 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
Originally posted on Himalayas
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
1. 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
2. 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
3. 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
4. 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
Originally posted on Himalayas
Apply on Himalayas →
Job sourced from Himalayas. Applications happen directly on the original platform — we never collect your data.