Sql Python Excel Power Bi Tableau Jobs in Lake Forest, IL

Sales Data Analyst - CPG Retail Analytics (Walmart / National Accounts) Location: Remote A growing food manufacturing company is seeking a Sales Data Analyst to support its North American retail sales organization and help transform sales, customer, and syndicated data into actionable commercial insights. This role will partner closely with National Account teams managing major retail customers including Walmart, Target, Costco, Kroger, and other strategic accounts . The successful candidate will analyze retail performance, promotional activity, trade investment, and customer data to identify growth opportunities and improve commercial decision-making. The ideal candidate will have CPG retail analytics experience , strong technical skills across SQL, Excel, Power BI/Tableau , and experience working with retailer portals, syndicated data, and sales performance metrics. Key Responsibilities Sales Analytics & Business Intelligence Build and maintain Power BI / Tableau dashboards supporting Sales, Marketing, and Commercial teams Develop reporting tools tracking key retail metrics including: Sales performance POS velocity Distribution and ACV Promotional performance Category growth Customer trends Automate recurring reporting and improve visibility into business performance Use SQL to extract, clean, and analyze customer sales data from multiple sources Retail & Syndicated Data Analysis Analyze data from retailer platforms including: Walmart Retail Link Target Partners Online Costco reporting platforms Kroger reporting platforms Work with syndicated data sources including: Circana / IRI NielsenIQ SPINS 84.51° Perform: Period-over-period analysis Plan vs. actual reporting Promotional lift analysis Category and market performance analysis Identify trends, opportunities, and risks to support National Account strategies Trade Spend & Commercial Analytics Analyze promotional effectiveness, trade investment, and ROI Evaluate incremental sales lift from promotions, displays, and features Support trade spend tracking and post-event analysis Provide insights to improve customer investment decisions Cross-Functional Analytics Projects Support Sales, Marketing, Finance, and Strategy teams with analytical insights Leadanalytics projects including: New item launch tracking Assortment optimization Customer reviews Joint Business Planning (JBP) Develop processes and tools that improve self-service reporting capabilities Qualifications Bachelor's degree in Analytics, Business, Economics, Statistics, Mathematics, or related field 2-4 years of experience in CPG sales analytics, retail analytics, revenue growth management, category management, or similar commercial analytics roles Experience supporting retail customers such as Walmart, Target, Costco, Kroger, Albertsons, or similar retailers strongly preferred Hands-on experience analyzing retail sales, POS, syndicated, and customer performance data Strong experience building dashboards using Power BI, Tableau, or similar visualization tools Intermediate SQL skills with experience querying and analyzing large datasets Advanced Excel skills including: Pivot tables VLOOKUP/XLOOKUP INDEX/MATCH Data modelling Experience working with retailer portals and syndicated data sources Ability to translate complex analysis into clear commercial recommendations Preferred Experience Experience with: Circana / IRI NielsenIQ SPINS Walmart Retail Link Kroger 84.51° Trade Promotion Management (TPM) or Revenue Growth Management experience Experience withautomationorETL tools such as: Alteryx Power Automate Python Zapier Experience managing analytics projects with multiple stakeholders Strong data storytelling and presentation skills Why Join? This is an opportunity to join a growing food manufacturing company and have a direct impact on how retail sales decisions are made. You will work closely with National Account teams, gain exposure to some of the largest retailers in North America, and use data to influence sales growth, customer strategy, and commercial performance. Keywords: Sales Data Analyst | Retail Data Analyst | CPG Analyst | Commercial Analyst | Sales Analyst | Business Analyst | Sales Operations Analyst | Revenue Growth Analyst | Category Analyst | Category Management Analyst | Customer Analytics Analyst | Business Intelligence Analyst | BI Analyst | Power BI | Tableau | SQL | Excel | Salesforce | Retail Analytics | Walmart Retail Link | Walmart Analytics | Target Analytics | Costco Analytics | Kroger Analytics | Circana | IRI | NielsenIQ | SPINS | 84.51 | POS Analytics | Trade Promotion Management | Revenue Growth Management | CPG | Food Manufacturing | Consumer Packaged Goods