Junior Retail Planner

brobstongroup.com - Jobboard; New York (NY); On-site; USD 60,000 - 80,000; Full time

Job summary

Brobston Group is seeking an analyst to support the Retail Planning and Inventory team in New York. The role includes managing daily planning tasks, preparing sales forecasts, and performing inventory optimization tasks.

The ideal candidate will have 2-3 years in retail planning, a Bachelor’s degree, and skills in Microsoft Excel, with advanced competencies in retail math. Previous experience with Power BI is a plus.

Qualifications

• 2-3 years of merchandise or retail planning experience with direct open-to-buy experience preferred.
• Strong analytical and problem-solving skills are essential.
• Ability to adapt in a fast-paced retail environment.

Responsibilities

• Forecast short- and long-term sales by product and monitor execution of buys.
• Manage auto-replenishment SKUs and model stock for inventory optimization.
• Partner with cross-functional teams on forecasts and data accuracy.

Skills

Microsoft Excel

Retail math

Analytical skills

Problem-solving

Communication skills

Presentation skills

Education

Bachelor’s degree

Tools

Power BI

IBM Planning Analytics Workspace

Job description

Summary

Support the Retail Planning and Inventory team by managing day-to-day planning tasks, preparing sales forecasts and open-to-buy reviews, and maintaining reporting to drive inventory optimization and business performance. The role focuses on sales and inventory forecasting, auto-replenishment management, KPI analysis, and cross-functional collaboration to align planning with merchandising, finance, and IT.

Responsibilities

• Support open-to-buy (OTB) and budget planning and prepare OTB reviews with guidance from the Retail Planning Manager
• Forecast short- and long-term sales by product and reference level and monitor execution of buys with post-market recaps
• Manage auto-replenishment SKUs and model stock to drive inventory optimization and sales productivity
• Analyze business performance and KPIs to identify opportunities and risks and recommend corrective actions
• Maintain weekly and monthly reporting and build ad-hoc templates to support department strategies
• Partner with Merchandise, Inventory Planning, IT, and Finance on forecasts, reorder proposals, min/max levels, and data accuracy
• Provide ad-hoc support and execute additional tasks as directed by management

Requirements

• Bachelor’s degree required
• 2-3 years of merchandise or retail planning experience with direct open-to-buy experience preferred
• Advanced competency in retail math and Microsoft Excel; experience with Power BI and IBM Planning Analytics Workspace a plus
• Strong analytical, problem-solving, communication, and presentation skills
• Highly organized, detail-oriented, and able to prioritize and adapt in a fast-paced retail environment