Sales Data Analyst - CPG Retail Analytics

Overview

A rapidly expanding food manufacturing company is looking for a Sales Data Analyst to enhance its North American retail sales efforts by converting sales, customer, and syndicated data into strategic commercial insights. This role collaborates closely with National Account teams that oversee key retail customers such as Walmart, Target, Costco, Kroger, among others. The successful candidate will focus on analyzing retail sales performance, promotional campaigns, trade investments, and customer data to discover growth opportunities and refine commercial decision-making.

Key Responsibilities

• Design, build, and maintain interactive dashboards using Power BI or Tableau to support Sales, Marketing, and Commercial teams.
• Create and track critical retail metrics such as sales performance, point-of-sale velocity, distribution and All Commodity Volume (ACV), promotions effectiveness, category growth, and customer behavioral trends.
• Automate regularly recurring reports to enhance transparency and accessibility of business performance data.
• Utilize SQL to extract, cleanse, and analyze customer sales data aggregated from diverse sources.
• Analyze retailer platform data including Walmart Retail Link, Target Partners Online, Costco and Kroger portals.
• Interpret syndicated datasets from sources such as Circana/IRI, NielsenIQ, SPINS, and 84.51°.
• Conduct period-over-period comparisons, plan versus actual sales reporting, promotional uplift analysis, and evaluation of category and market performance.
• Identify market trends, potential growth opportunities, and risks to aid National Account strategy development.
• Evaluate promotional trade spend effectiveness, calculating ROI and incremental sales lift from promotions or in-store features.
• Support tracking and post-event analyses for trade investments and provide recommendations for optimizing customer investment allocations.
• Collaborate with cross-functional teams (Sales, Marketing, Finance, Strategy) by delivering analytical insights and leading projects such as new item launch tracking, assortment optimization, customer reviews analysis, and Joint Business Planning (JBP).
• Develop improved self-service reporting processes and tools to empower teams with timely insights.

Qualifications

• Bachelor’s degree in Analytics, Business, Economics, Statistics, Mathematics, or a related field.
• Between 2 to 4 years of hands-on experience with CPG sales analytics, retail analytics, revenue growth management, category management, or similar commercial analytics functions.
• Prior experience supporting major retail customers including Walmart, Target, Costco, Kroger, or Albertsons is highly desirable.
• Proficient in analyzing retail sales, point-of-sale, syndicated, and customer performance data.
• Strong skills in building dashboards using Power BI, Tableau, or related visualization software.
• Intermediate proficiency in SQL for querying and processing large datasets.
• Advanced Excel capabilities, including use of pivot tables, lookup functions (VLOOKUP, XLOOKUP), INDEX/MATCH, and data modeling techniques.
• Experience navigating retailer-specific portals and syndicated data platforms.
• Ability to distill complex analytical results into actionable business insights and recommendations.

Preferred Experience

• Familiarity with syndicated data tools such as Circana/IRI, NielsenIQ, SPINS; and retailer platforms like Walmart Retail Link and Kroger's 84.51°.
• Background in Trade Promotion Management (TPM) or Revenue Growth Management.
• Experience with automation and ETL tools including Alteryx, Power Automate, Python, or Zapier.
• Proven track record managing analytics projects involving multiple stakeholders.
• Strong aptitude for data storytelling and effective presentation of analytical findings.

Why Join Us?

This position offers the chance to contribute significantly to a growing food manufacturing firm by influencing how retail sales decisions are formulated. You will engage directly with National Account teams, gain exposure to top North American retailers, and leverage data to steer sales growth, customer strategies, and overall commercial success.