Overview
Salary: $25.52-28.36 Hourly
Duration: 6 months + extension Step into a high-visibility, transformative role where you will directly shape the inventory strategy and launch readiness for a celebrated luxury design and manufacturing brand. Partnering with Aquent, you will serve as the standalone subject-matter expert, building critical forecasting models from the ground up, designing executive-level dashboards, and directly influencing key business decisions during an exciting period of e-commerce expansion. About the Opportunity Aquent has partnered with a premier luxury design and manufacturing brand known globally for its exceptional craftsmanship and innovation. This high-impact position offers the unique opportunity to establish a permanent capability within their Sales & Operations Planning (S&OP) team. Starting as a 3-month contract, this role is designed for a talented professional looking to make a lasting impression, as the hiring manager intends to extend and convert the right candidate into a permanent, full-time team member. Key Responsibilities
- Develop and own end-to-end demand forecasts across stocked product categories and sales channels, netting approved demand against on-hand and in-transit inventory to deliver clear buy plans.
- Incorporate global supplier constraints into inventory planning, accounting for extended ocean lead times, minimum order quantities (MOQs), and full container load (FCL) consolidation.
- Build dynamic demand scenarios (conservative, expected, higher-growth) for a newly launching e-commerce channel, adjusting replenishment assumptions based on early selling behavior.
- Establish safety-stock targets, weeks of supply (WOS) benchmarks, and proactive reorder strategies to mitigate stockout risks, backorders, and excess inventory.
- Transform raw data extracts into clear visual inventory-health dashboards using Advanced Excel and Power BI to present risks and financial trade-offs directly to senior leadership.
- Measure forecast accuracy and bias (MAPE), conduct root-cause analyses on deviations, and facilitate collaborative reviews across Purchasing, Operations, Logistics, Merchandising, and Marketing.
Required Qualifications
- 3 to 5+ years of autonomous experience in demand planning, inventory planning, or supply-chain analytics, with a proven track record of building forecasting and replenishment models from scratch.
- Advanced Microsoft Excel skills, including proficiency with complex formulas, XLOOKUP, Power Query, and scenario modeling.
- Strong experience building visual reports and inventory-health dashboards in Power BI.
- Solid grasp of supply chain fundamentals, including safety stock calculations, weeks of supply (WOS), forecast error/bias tracking, and global vendor lead-time/container dynamics.
- Excellent communication skills, with the ability to distill complex supply-and-demand data into clear, actionable business recommendations for non-technical stakeholders and senior leadership.
Preferred Qualifications
- Familiarity with raw ERP data extracts, particularly SAP.
- Experience utilizing Microsoft Copilot or Databricks for data analysis and visualization.
|