Strategic Planning Analyst - Williams Sonoma

We hope you're interested in building a home with us. Even if you don't feel that you meet every requirement listed in this job description, we still encourage you to apply.

About the Strategic Planning Team

The Strategic Planning team is under the WS brand finance team. We are the liaison across each of our cross-functional teams and ensures that the daily sales plans and promotional cadence are aligned to achieve the financial plan.

Overview of the Strategic Planning Analyst role

You will be responsible for supporting the Inventory Planning and Merchant teams to drive topline sales and maximize profitability. You will have the opportunity to build tools and drive processes that bridge bottoms up sales plans to top line financial goals.

Responsibilities

• Create and develop tools and process for analyzing the Williams-Sonoma business.
• Manage and maintain large sets of data and ensure accuracy.
• Develop reports to inform and influence business decisions resulting in profitable results.
• Lead weekly promotional meetings, provide insights and recommendations on promotional activities, recap next steps from meetings to ensure alignment and timely execution.
• Support planning team on forecasting and managing Open-To-Buy roll ups.
• Operate a computer and communicate via telephone
• Transport materials and equipment and lift, move, and carry objects up to 50 pounds on a limited basis

Criteria

• 1-2 years of Business Analyst experience in Inventory Management.
• A result oriented individual with strong problem-solving skills.
• Ability to manage large data sets from multiple systems.
• Strength in communicating cross-functionally and presenting in small to medium groups.
• Familiarity in retail math, metrics, and inventory planning (i.e. OTB, Forecasting)
• Ability to work onsite in the San Francisco office Monday - Thursday and work remotely on Fridays.

Technical Competencies required

• Strong logical and analytical skills.
• Ability to read and write SQL queries.
• Experience in advanced Excel and Access techniques.
• Proficient in Power Query, Python, Power Pivot, and VBA Macros.
• Strong understanding of data logic and data structure.
• Experience in building databases is a plus.
• 5+ years of Business Analyst experience in the retail industry is a plus.

WSI will not now or in the future commence an immigration case or "sponsor" an individual for this position (for example, H-1B or other employment-based immigration

This role is not eligible for relocation assistance.

Williams-Sonoma, Inc. is an Equal Opportunity Employer. Williams-Sonoma, Inc. will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of the San Francisco Fair Chance Ordinance, or other applicable state or local laws and ordinances.

The expected starting pay rate for this position is $95,000. Applicable pay ranges may differ across markets. Actual pay will be determined based on experience and other job-related factors permitted by law. In addition to competitive pay, compensation may include a variety of other components like benefits, paid time off, merit, and bonus opportunities.

#LI-CA1 #LI-Onsite