Analyst, Demand Planning

Job Summary

The Demand Planning Analyst will assist Sr. Demand planner in forecasting, analysis, assortment planning, manage inventory levels, and partner with cross functional teams on key projects all year around. The Demand Planning Analyst will work with Sr. Demand Planner to achieve planned inventory levels by Region/Salon and maintain of merchandise assortments at the item level to maximize profitability and sales.

Key Duties, Responsibilities and Accountabilities

Forecasting:

• Forecast worldwide and regional, sales by units and value across all product lines, all price point categories (Access, Core & High Jewelry) that are within the Model Stock Assortment Plan.
• Review Forecasted sales weekly versus actual sales and overall budget.
• Adjust consensus forecast as needed based on sales trend analysis
• Validate and consolidate regional and local sales forecasts from Allocations Team as well as understand supply chain lead times across all product lines.

Trend Analysis:

• Review worldwide and regional sales trends taking into account global marketing initiatives, global financial climate, and currency and exchange rate fluctuations affecting specific regions, regional tax implications, as well as the impact price increases and decreases.
• Work closely with Merchandise team to assess global impact of local events, advertising, and client appointments on the sales trend.

High-level reporting:

• Create and analyze regional sales reports, salon sales reports, top seller report, color/clarity/finger sizes and any Ad-Hoc reports needed.

Order Placement:

• Review and place weekly replenishment orders. Taking into account latest forecast results, revised forecast, and current trend analysis.

Supply Chain Management:

• Review On Hand versus Model Stock inventory levels and projected Manufacturing scheduled deliveries weekly, monthly, and through the 18 month forecast.
• Work closely with all facets of the supply chain to ensure deliveries of top selling pieces and high value stone production orders are prioritized.

Product Life Cycle Management:

• Work with Category management on implementing product life cycle changes to existing product lines.

New Product Launches:

• Partner with Sr. Demand Planner to work closely with Category Management on implementation of new items into the planning system with all product information
• Work with Merchandise team to validate local Model Stock and roll up into global MDS and sales forecast.

Assortment Planning for salons:

• Partner with Sr. Demand Planner/Director to establish the demographics and needs for new openings
• Set and communicate assortment plan
• Collaborate with Visual Merchandising to ensure floor space is maximized and assortment is displayed to its full potential

Job Qualifications

• Bachelor’s degree.
• Minimum 3 years planning/merchandising experience.
• Luxury retail and or Jewelry experience a plus.
• Must have strong technical skills; specifically, with Microsoft Excel (macros, v-lookups, pivot tables, complex formulas, etc.) and in dealing with large data sets.
• Ability to build and maintain strong working relationships and work cross functionally with all departments/team members.
• Strong analytical skills, attention to detail, ability to manage multiple projects independently and in a timely manner required.
• Demonstrates strong communication skills, both written and verbal, excellent problem solving skills, adaptability/flexibility, and takes initiative to drive the business forward.