Business Analyst

Exciting opportunity to join this Outdoor company! The Exxel Outdoors Business Analyst for Walmart / Sam’s Club in Bentonville, Arkansas, provides accurate and meaningful forecast and sales data analysis for the Exxel Outdoors mass business with Walmart and Sam’s.   This position analyzes sales history, WM ladder plan forecasts, POS, inventory levels, production lead times and product demand to determine the required fulfillment levels.  S/he works closely with the Walmart Replenishment Manager’s to tactically plan and drive the Exxel Outdoors business with Wal-Mart/Sam’s. Accuracy, attention to detail and ability to analyze data effectively to provide fact-based conclusions and solution-based recommendations are key requirements in this position. This role is in the offsite Bentonville Arkansas office that is a satellite office supporting Walmart.

ESSENTIAL DUTIES AND RESPONSIBILITIES 

• Assigned Accounts:  Walmart and Sam’s.
• Assists the Director of National Accounts – Walmart / Sam’s to achieve monthly, quarterly, and yearly sales goals through proper order, forecasting and inventory management.  The Business Analyst’s primary responsibility is to ensure the best possible communication and processes through effective training, communication and involvement with the order tracking, inventory analysis and delivery activities.   
• Assists the Director of National Accounts Walmart / Sam’s in detailed preparation of all forecasting and internal sales plan documents.
• In depth knowledge of Retail Link / Luminate / Item 360 / QMS / Aspen.  
• Develops relevant Retail Link reports that identify various analytical perspectives of product movement, i.e. Top 10 Stores By Category, Weekly In stock and Sales Report, 52 Week Sales By Category, etc.
• Utilizes all elements of Retail Link’s CPFR reporting and internal IOF forecasting model.
• Daily use of Sam’s Allocation tool to manage the flow of our inventory to the clubs.
• Total maintenance of Supplier Quote application in Retail Link. Prepare and submit product quotes in Retail Link Quote Management System by required deadlines, maintaining all necessary updates after initial submission. 
• Detailed quote sheet preparation (CBM calculations, tariff verification, freight rate verification, etc.)
• Implement all Item Set Ups for Walmart and Sam's Club and manage ongoing item maintenance.
• Oversee the product sample process for the Layout Center, and other sample requests, including but not limited to ordering, receiving, and labeling quotes by the identified deadlines. 
• Manage Audits and tracking on Walmart.com, providing updates to Walmart Sales Team including pricing (key driver items), features and promotional item performance and status, searchability optimization, and reviews tracking.
• Develops club lists for Sam’s items through detailed Retail Link analysis to ensure proper inventory is maintained at all clubs.
• Establish strong customer rapport and reliability within the account to become a trusted advisor. 
• Participate in customer touch base appointments, category line reviews, Joint Business Planning, and Quarterly Business Reviews 
• Attends regular meetings with account replenishment manager to review order status and activity.  Work closely with Walmart and Sam’s Replenishment managers to monitor inventory levels using Wal-Mart’s replenishment ladder plan analysis tool.  Continual communication with Replenishment department to ensure up-to-date accuracy. 
• Own a relationship directly with Walmart staff on a weekly basis. Strong understanding of Walmart’s Go to Market strategy and strong communication and customer focused mindset are critical to servicing the customer in this role.
• Reporting of key metrics, new planogram updates, display promotions, lost sales, inventory reviews, with specialized focus where needed 
•  Drive new approaches to analyzing business results and trends and create ad hoc reporting for situational analysis, as needed 
• Assist in developing presentations to collaboratively gain accounts' support of innovation, displays and promotional/pricing strategy 
• Monitor and communicate regularly to Product Managers and Sales Managers all availability and/or inventory issues.
• Work with the Sales staff to help disseminate product information, production and shipment status, and retail movement to the relevant buyer(s).
• Manage elevated or sensitive accounts calls.  Take control and be proactive with calls from accounts.
• Exercise sound business judgment.
• Work independently and collaboratively and manage time effectively in order to meet changing deadlines and priorities.
• Acts as office manager of the Exxel Outdoors Bentonville office.  Maintain all files, reports and related activities in a professional, timely and organized manner.
• Delivers samples and reports to buyers, replenishment buyers, and other pertinent account personnel as needed. 

QUALIFICATIONS AND SKILLS

• Bachelor’s degree in business or finance.
• 3-5 years Walmart experience in Account Management, as a Business Analyst or related field.
• In depth knowledge of Retail Link and be eligible to gain Retail Link access for Exxel upon hire.
• Co-managed training certification.
• Must have excellent computer skills with an advanced understanding of excel.
• Must have excellent communication and interpersonal skills with the ability to articulate business data to all levels within the organization.
• Must be proactive, detail/numbers oriented and able to meet deadlines.
• Exude confidence and professionalism in working with accounts and Wenzel Team.
• Must be able to function effectively and independently in a small office environment.
• Merchandising experience a plus.
• Beneficial to have worked with outdoor and leisure products.

WORK ENVIRONMENT

 This position is based out of our Bentonville, Arkansas office. The Bentonville office is about 5,000 square feet located in a strip mall area of Bentonville. This position has a designated office.

PHYSICAL DEMANDS

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is regularly required to stand, walk; sit; use hands to finger, handle, or feel; reach with hands and arms; and talk or hear.  The employee frequently is required to stoop, kneel, crouch, or crawl.  The employee must occasionally lift and/or move up to 25 pounds.  Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception, and ability to adjust focus.

OTHER DUTIES AS ASSIGNED

This job description is an overview of the scope of responsibilities for this job and is not intended to be an inclusive list of job tasks and expectations. With the evolution of Exxel Outdoors, LLC, the responsibilities of this position may change. The job must be prepared to accept new responsibilities and transfer others. 

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
If interested, please apply using this link.