Replenishment and Sales Analyst

Summary:

The goal of the replenishment analyst is to provide data analysis to drive the sales and growth of the assigned accounts within Lakeview Farms. This role will report to the Vice President of Sales for Walmart and Sam’s Club and will have direct responsibility for analyzing the overall product supply of assigned accounts and supporting the internal sales teams and cross-functional team as well.

They will support the plan by being attentive to the customer needs and being an effective liaison with internal cross-functional teams, such as customer service, logistics and product development, to maintain and improve the entire service-after-the-sale customer experience. They will also forecast the sales of each account to ensure production planning is executed efficiently. Supporting the activities related to the assigned accounts effectively is a key responsibility in maximizing sales and growth.

Key Responsibilities

• Forecast and track weekly and annual order projections for customer accounts
• Track, maintain and communicate key account metrics for sales and inventory, including on time/in-full (OTIF), Supplier Quality Excellence Program (SQEP), in stock concerns, inventory and sales forecast accuracy
• Prepare weekly replenishment reports
• Efficiently monitor forecasts and inventory and collaborate with customer to drive efficiencies and maximize sales
• PO tracking and maintenance
• Attend buyer and replenishment meetings
• Build and promote strong, long-lasting relationships with customers by partnering with them, understanding their needs, and delivering results
• Pricing maintenance
• Maintain an accurate item master that includes monitoring item accuracy, cross-referencing, cost-retail
• Item creation in internal and customer systems
• Liaison with cross-functional internal teams (including Customer Service and Product Development) to improve the entire customer experience
• Help team maintain and monitor in-stock level changes and modular end of life to mitigate excess inventory and shortages
• Calculate and provide mod fill order estimates internally for new and store count increase items
• Study and analyze customer’s sales, industry data and consumer insights to credibly assess customer account needs regularly and on an ad hoc basis
• Support team in preparing presentations that leverage and optimize data to drive customer decision making
• Effectively communicate with the customer and internal teams
• Continually assess current business distribution channels and evaluate their performance
• Maintain professional and technical knowledge by attending trade shows, educational workshops, webinars, comp shopping, reviewing professional publications, etc.
• Continually develop knowledge of the business climate, applications and competition for defined geography and accounts
• Demonstrate ability to coordinate, plan and prioritize multiple tasks with great accuracy, creativity and work well under pressure
• Perform product/modular resets in clubs and stores occasionally
• Contribute to team effort by accomplishing related tasks as needed

Qualifications and Experience

• Bachelor’s degree in business, retailing, management, sales or marketing preferred
• Minimum 2 years as a Replenishment, Supply Chain Analyst, Sales Analyst or similar role.
• Prior experience working within the food category preferred, and working knowledge of Walmart and Sam’s Club
• Experience with Microsoft Office applications such as Outlook, Word, Excel PowerPoint;
• Knowledge, experience or proficiency in the following industry programs and systems: Retail Link, Circana, Nielsen, MADRID, Luminate/ Scintilla and 1WS
• Knowledge of one or more areas of Product Management (brand management, supply chain, manufacturing, pricing, marketing/sales)

Skills and Capabilities

• Highly proficient in data mining, analysis and reporting
• Strong analytical, critical-thinking and problem-solving skills with a high attention to detail
• Ability to collaborate with cross functional stakeholders, influence decisions and recommend a course of action based on data analytics
• Skilled in driving process improvement by implementing checks and balances and identifying process steps that can be automated.
• Ability to multitask, define long and short-term objectives and establish priorities to consistently meet timelines
• Must have advanced proficiency in Excel and PowerPoint with the ability to create complex reporting and dynamic presentations.
• Excels in a fast-paced environment and is willing to take calculated risks; can adapt to changing priorities
• Ability to communicate, present and influence credibly and effectively at all levels of our company and with all customers
• Self-motivated, innovative thinker willing to work in an evolving role that presents opportunities for teamwork and collaboration