Sales Analyst, Walmart

MGA Entertainment; Bentonville (AR); On-site; USD 65,000 - 90,000; Full time

Job summary

MGA Entertainment is seeking a detail-oriented Sales Analyst to join the Walmart and Sam’s Club team in Bentonville. The role focuses on generating reports, analyzing data, and identifying trends to grow sales using Excel and Power BI.

The analyst will collaborate with sales teams, forecast and support budgeting, and develop recurring KPI reports to drive strategic decisions in a fast-paced retail environment.

Qualifications

• Bachelor's degree in Business or related field.
• Proven Sales Analyst experience or similar role with CPG company, Sales Broker, or Walmart.
• Experience with Retail Link and Scintilla Charter (Channel Performance, Shopper Behavior, Customer Perception modules).
• Sam’s Club Madrid experience a plus.
• Proficiency in Microsoft Excel, including advanced formulas, pivot tables, and preferably VBA.
• Experience with Power BI or similar data visualization tools.

Responsibilities

• Analyze sales data to identify trends, patterns, and anomalies.
• Translate data into actionable insights and recommendations to drive sales growth.
• Track and analyze key retail metrics such as POS sales, inventory, in-stock, modular performance, and promotional lift.
• Develop and maintain recurring reporting to track KPIs and business performance.
• Generate reports and presentations to communicate key findings to stakeholders.
• Utilize Power BI to create interactive dashboards and visualizations.
• Collaborate with sales teams to provide insights and support decision-making processes.
• Identify areas for process optimization and efficiency improvements.
• Assist in forecasting and budgeting processes based on historical sales data.
• Support sales team: line reviews, customer meetings, sample coordination, Walmart YBM/Holiday meetings.
• Support ad-hoc data analysis requests from various departments.

Skills

Analytical thinking

Communication skills

Team collaboration

Independent work

Education

Bachelor's degree in Business

Tools

Excel

Power BI

VBA

Retail Link

Scintilla Charter

Job description

CA EMPLOYEE PRIVACY RIGHTS: https://www.mgae.com/ca-employee-privacy-rights

MGA Entertainment is one of the largest and fastest growing privately held toy and entertainment companies in the world. Headquartered in Los Angeles, and with offices globally, the company creates innovative, proprietary, and licensed consumer products and entertainment properties, including toys, games, dolls, arts & crafts, beauty, and home storage products. The MGA family includes award-winning brands such as L.O.L. Surprise!™, Little Tikes®, Rainbow High™, Shadow High™, Bratz®, MGA’s Miniverse™ Baby Born, Story Dream Machine, Cartuned, Slime Life, Armorsaurs, and Wonder Factory.

Job Description

We are seeking a talented and detail-oriented Sales Analyst to join our dynamic and growing Walmart and Sam’s Club team in Bentonville. The ideal candidate will be responsible for generating reports and analyzing data to identify trends, opportunities, and areas for improvement within the Scintilla Charter platform. This role requires proficiency in Excel for data manipulation/analysis and prefer experience with Power BI.

Responsibilities

• Analyze sales data to identify trends, patterns, and anomalies.
• Translate data into actionable insights and recommendations to drive sales growth
• Track and analyze key retail metrics such as POS sales, inventory, in-stock, modular performance, and promotional lift
• Develop and maintain recurring reporting to track KPIs and business performance
• Generate reports and presentations to communicate key findings to stakeholders.
• Utilize Power BI to create interactive dashboards and visualizations.
• Collaborate with sales teams to provide insights and support decision-making processes.
• Identify areas for process optimization and efficiency improvements.
• Assist in forecasting and budgeting processes based on historical sales data.
• Support sales team: line reviews, customer meetings, sample coordination, Walmart YBM/Holiday meetings.
• Support ad-hoc data analysis requests from various departments.

Requirements

• Bachelor’s degree in a relevant field such as Business is preferred.
• Proven Sales Analyst experience or similar role with CPG company, Sales Broker, or Walmart.
• Experience with Retail Link and Scintilla Charter (Channel Performance, Shopper Behavior, Customer Perception modules).
• Sam’s Club Madrid experience a plus.
• Proficiency in Microsoft Excel, including advanced formulas, pivot tables, and preferably VBA.
• Experience with Power BI or similar data visualization tools.
• Strong analytical skills with the ability to interpret complex data sets.
• Excellent communication and presentation skills.
• Detail-oriented with a focus on accuracy and quality.
• Ability to work independently and collaboratively in a fast-paced environment.
• Knowledge of CPG sales processes and working with Walmart Merchant Teams.