Sales Planning & Analytics Analyst

Summary

Keurig Dr Pepper is a leading beverage company seeking a Sales Planning & Analytics Analyst to support its Grocery West/Midwest organization. The role focuses on analyzing sales and syndicated data, optimizing trade investments, managing dashboards and reporting, supporting customer planning, and providing insights for revenue, volume, and profitability growth.

Responsibilities

• Analyze syndicated (IRI/Circana) and internal data to identify trends, risks, and growth opportunities
• Provide actionable insights to improve promotional effectiveness and overall sales performance
• Evaluate total portfolio performance to identify high-impact growth opportunities aligned to KPIs
• Support customer planning through business reviews and pre/post promotional analysis
• Build and maintain daily, weekly, and monthly reporting dashboards
• Standardize scorecards and reporting across West / Midwest customers to improve consistency
• Ensure data accuracy and integrity across reporting systems
• Track, analyze, and optimize trade spend and promotional investments
• Maintain trade systems (e.g., Demantra) and manage pricing and promotional inputs
• Partner with Finance and RGM to evaluate ROI and improve investment effectiveness
• Research and resolve promotional allowances, billbacks, and pricing discrepancies
• Partner with National Account Executives (NAEs) to support planning and execution
• Manage customer portals, new item setup, and promotional submissions
• Support resolution of order, inventory, and pricing issues using data insights
• Maintain customer and internal databases including pricing, volume, and trade data
• Identify opportunities to streamline processes and improve reporting efficiency
• Collaborate with Sales, Marketing, Category, Finance, and Supply Chain partners
• Support development of strategic business plans and customer presentations
• Build clear, compelling presentations and visuals for internal and customer use

Skills

• * Bachelor's degree in Business, Finance, Analytics, or related field
• * 3+ years of experience in analytics, sales support, or CPG environment
• * Strong proficiency in:
• * Excel (advanced formulas, pivot tables, etc.)
• * PowerPoint
• * Power BI or similar tools
• * IRI/Circana data
• * Experience in grocery or beverage industry preferred
• * Experience with trade systems (e.g., Demantra) a plus

Qualifications

Must Haves

• * Bachelor's degree in Business, Finance, Analytics, or related field
• * 3+ years of experience in analytics, sales support, or CPG environment
• * Strong proficiency in:
• * Excel (advanced formulas, pivot tables, etc.)
• * PowerPoint
• * Power BI or similar tools
• * IRI/Circana data

Nice to Haves

• * Experience in grocery or beverage industry preferred
• * Experience with trade systems (e.g., Demantra) a plus

Benefits

• Medical coverage, subject to election and eligibility
• Dental coverage, subject to election and eligibility
• Vision coverage, subject to election and eligibility
• Disability coverage, subject to election and eligibility
• Paid Time Off, including paid parental leave, vacation, and sick time, subject to election and eligibility
• 401k with company match, subject to election and eligibility
• Tuition Reimbursement, subject to election and eligibility
• Mileage Reimbursement, subject to election and eligibility
• Annual bonus based on performance and eligibility
• Remote work (Eastern or Central Time preferred | Grand Rapids, MI proximity a plus)
• Employee programs designed to enhance professional growth and development