Merchandise Planner at ProspectBlue

ProspectBlue is partnered with an activewear brand client looking for a proactive and analytical Merchandise Planner to join its Planning team in Charlottesville, Virginia

The Merchandise Planner will focus on managing the company’s sales and inventory forecasting at the SKU level to inform POs and strategic planning. This person should have excellent quantitative and analytical skills and be an expert in Microsoft Excel. The best candidate has strong experience in planning, sales forecasting, and/or inventory management, ideally in retail or consumer goods, as well as experience with reporting tools. This candidate should have exceptional organizational skills and attention to detail to effectively own the company’s sales forecast at the SKU level. This candidate should be comfortable pulling raw data, organizing it into a digestible format, and communicating it to inform tactical and strategic decisions. Finally, the candidate should be comfortable creating and managing reporting around sell-through rates, velocity, and other sales KPIs.

This position will be located in-person at the company’s Charlottesville, VA headquarters.

This individual will be working cross-functionally with the Merchandising Team, Finance Team, Production Team, and company founders.

Responsibilities:

• Update, maintain, and continually improve the company’s E-Commerce bottoms up, item level monthly demand forecasts across all product categories
• Balance monthly item level demand plans against supply plans to accurately monitor stock levels and flag potential imbalances between demand and supply when identified
• Partner with Planning Manager to gain alignment on the open-to-buy plan and identify differences between the tops down and bottoms up forecasts on a product category level
• Collaborate with Merchandising Team to align on trend analyses including item/product rankings, comp items, marketing campaigns, and more to assist with forecasting
• Aggregate demand forecasts for each sales channel to calculate total company buy quantities for PO review meetings
• Complete PO upload template after each PO review meeting in a timely manner and pass to Production Team to forward to vendors
• Analyze historical sales data at a size level on an item/product category basis to calculate ideal sizing ratios for POs to help optimize sell-through targets
• Develop and maintain weekly/monthly reports to assess inventory levels against financial targets and create exception/ad hoc reporting to communicate business trends when needed
• Manage seasonal style master files to maintain data integrity and ensure merchandise is valued appropriately
• Attend strategic planning sessions with Finance and Marketing Teams to provide sales and inventory position insight on a product/colorway/SKU level
• Analyze return data to inform sales estimates and understand the impact on net sales and revenue
• Create seasonal mark-down and off-price proposals based on internal and external customer cadences, followed with reports to track sell-through
• Other tasks as needed

Qualifications:

• Bachelor’s degree required
• Minimum 3 years of merchandise planning or related experience, ideally in the retail industry
• Highly analytical and quantitative with acute attention to detail
• Expert at Microsoft Excel and building forecast models
• Comfortable owning and improving existing forecast models and Excel files
• Ability to work independently and switch rapidly between projects
• Excellent written and verbal communication
• Self-starter work ethic with a desire to make a positive impact
• Strong internal and external communication skills
• Ability to think strategically, advise, and impact the company’s direction with data-driven analysis
• Propensity to go above and beyond and think outside the box
• Openness to change and new ways of solving problems
• Trustworthy and full of integrity
• Must be a team player with a no-task-too-small attitude