Sales Analytics Specialist: Power BI & Excel Insights

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

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.