Job Summary:

The Planner is responsible for analyzing business trends and identifying opportunities to drive retail & net sales to achieve plan and reduce the liability of unproductive inventory. The Planner works in partnership with the Sell-In Team, Sales Operations team and respective Retail Account Buying Teams to maximize inventory, resulting in achievement of gross and net sales budget.

FORECASTING

• Support and partner with Director and ED, Key Accounts in building bottoms up budgets and on-going forecasting and achievement of retail and net sales plans
• Forecast returns and DIFs, managing discontinuations to reduce RTV liabilities, retrieving necessary approvals, and partnering with finance on timing and estimates
• Analyze retailer OTB monthly, ensuring no changes or potential issues after each month’s lock
• In partnership with Director, Key Accounts, develop CEP & mid-month retail and shipment projections with keen communication to ED, Key Accounts on changes
• Build and revise monthly retail HPLN in accordance with monthly CEP projections, collaborating with cross-functional partners to ensure alignment
• Ensure orders are received from retail partners in a timely manner and troubleshoot errors
• Collaborate with internal partners on creating sales goals by door, week, quarter, and channel during budgeting and re-trending moments
• Build retail sales plans for new launches, tracking achievement and sell-thru of established sales objectives, including analysis for Limited Edition and Holiday product lines

REPORTING

• Using COGNOS and retailer reporting, pull weekly sales data and analyze sell-thru results to inform weekly commentary
• Provide weekly sales recap to key internal stakeholders and leadership, summarizing achievements, promotions, marketing activities
• Deliver weekly by door sales recaps to SEEs

MISCELLANEOUS

• Support monthly consensus process by providing updated retailer sku projections, insights, and relevant reporting
• Track ROI and sales lift on retailer secondary exposures and marketing activities to inform co-op spend
• Maintain agendas for weekly recurring touch bases with internal stakeholders and retail partners
• Execute ad hoc reporting and analysis requests

Qualifications & Competencies: 

• Bachelor’s degree in related field
• 7+ years of retail planning experience (Buying Office or extensive Head Quarter experience)
• Highly skilled in inventory planning, forecasting gross/net shipments, and bottoms up build required
• Advanced expertise in Microsoft Excel, PowerPoint (pivot tables, vlookups, sumif, etc.)
• Ability to fully read, analyze and understand retailer OTB’s
• Demonstrated ability to build gross to net and retail sales plans from the bottom up
• Strong knowledge and experience with the prestige cosmetic industry & retail planning systems, with open-sell retailers preferred
• Ability to work under pressure and fluctuating deadlines with a high number of tasks
• Should possess strong analytical, organizational and communication skills
• Strong attention to detail, high sense of responsibility, dependable and self-starter
• Must be flexible and adaptive to changing priorities

#LI-REMOTE

Shiseido is an Equal Opportunity Employer and does not discriminate on the basis of race, color, gender identity, religion, sex, age, national origin, disability, veteran status, sexual orientation, genetic information or any other classification protected by Federal, State or Local law