Space Management Data Analyst
About the company
WinCo Foods operates over 140 supermarkets across 10 states with more than 22,000 employee owners. As the second largest employee-owned company in the United States, WinCo has over 500 millionaire employee-owners through its Employee Stock Ownership Plan (ESOP). The company's purpose is to make the lives of customers and employee owners better by offering the lowest possible prices to feed their families.
About the role
Maintains the Space Management Database, analyzes data for assigned categories, and presents it in a format used to make effective business decisions. This role supports and guides both the assortment decision-making process and space change decisions for major category releases and ad hoc optimization projects. The analyst provides data, insights, tools, planograms, guidance, and training for recommendations to support optimization strategies, partnering closely with teams to make sound optimization decisions.
Responsibilities
- Work closely with various cross-functional and project teams as subject matter expert for Space & Assortment Optimization
- Source data from syndicated, customer-specific, and/or market resources
- Meet specific needs by determining appropriate data selection and custom assortment as directed by supervisor
- Quantify, analyze, and interpret data
- Evaluate the reliability of source information by weighing raw data and organizing results for analysis
- Create Excel templates utilizing raw data
- Consolidate optimization data components and perform advanced quantitative analysis
- Interpret data trends and create recommendations based on findings; communicate optimization findings
- Organize information into presentation format by studying, analyzing, interpreting, and classifying data
- Implement and measure recommendations as appropriate
- Provide scorecards to ensure WinCo is realizing value from the assortment work
- Maintain project schedule by monitoring project progress, coordinating activities, resolving problems, and making adjustments as needed to meet deadlines
- Assist teams as needed by participating in presentations to answer questions regarding data and data analysis information
- Query and analyze data to support ad hoc requests
- Perform other duties as assigned or needed
Requirements
Education
Bachelor's degree in Merchandising or related field OR equivalent combination of education, training, and/or experience.
Experience
- At least 2 years of work experience in an applicable field with primary responsibility in a role demonstrating proficiency in MS Office programs as well as working knowledge of Space Planning software
- Demonstrated working knowledge of syndicated data and applications
- Demonstrated analytical skills and techniques
- Basic understanding of assortment optimization
- Effective oral and written communication skills necessary to communicate with all levels of internal and external team members and customers
- Ability to prioritize in a fast-paced, multi-tasked environment
- Experience interacting with retail executive management in corporate-level Merchandising and Operations
- Strong understanding of financial calculations
- Understanding of relational databases and knowledge of CKB/Prism functionality
- Advanced level knowledge in MS Excel and strong working knowledge of Microsoft Office (Word, PowerPoint, etc.)
Skills
- Understand and interpret data and draw conclusions to solve business issues and make recommendations
- Understand legal regulations within buying and work within compliance guidelines
- Analytical ability to deep dive data, extract insights, and provide guidance on actions
- Strong problem-solving skills and experience in process design, and test & learn approaches
- Strong organization skills and attention to detail
- Work cooperatively with others toward common group objectives, demonstrate respect for the ideas and contributions of other team members, cultivate positive relationships with other associates, and provide assistance and support to others
- Write and speak clearly and succinctly in a variety of communication settings
- Respectfully challenge standard practices to identify improved practices and processes
Preferred qualifications
- JDA certification
- Demonstrated ability with business modeling capabilities using tools such as SQL, Excel, and Access