Mike’s Hard Lemonade is expanding due to the company’s continued sales growth and the growing importance of Flavored Beer insights. Based in our Chicago office (hybrid), this role, working closely with Marketing, Sales, and IT is responsible for analyzing point-of-sale scan, consumer panel, and retailer gateway data, focusing on the Dollar and E-Premise channels. This role will work with large datasets to develop fact-based presentations and reports that lead to better assortment and merchandising decisions at retail. This role also supports category management and shelf validation tasks on an ad-hoc basis, as well as long-term cross functional strategic projects for the commercial organization.

Core Duties and Responsibilities:

Sales Reporting (40%)

• Prep, cleanse, and integrate multiple large data sources for a complete analysis
• Produce routine reports and trackers to assist sales team program execution, leveraging retailer gateways for deeper insights.
• Customize retailer gateway data to match internal category definitions
• Educate sales on data report details on an ad-hoc basis
• Develop reports and tools that improve the use of data across the organization
• Work closely with third-party vendors to uncover insights
• Seek continuous improvement and new ideas for delivering insights to the organization

Data Presentations (30%)

• Develop Beer Category and Flavored Beer Business Reviews
• Curate compelling visual presentations that tell stores with data
• Deliver consistent insights to sales group members in support of key retailers
• Attend retailer meetings and make assortment recommendations
• Utilize advanced PowerPoint and Excel to create captivating visualizations

Consumer Insights (20%)

• Utilize shopper panel data to provide flavor consumer insights to internal and external stakeholders
• Integrate flavor shopper trends, demographic insights, and leakage tree analysis into presentations
• Create custom product groups for ad-hoc analyses

Cross Functional Support (10%)

• Consult with CatMan team on data-driven flavored beer planograms for key retailer resets as needed
• Accurately validate shelf sets with short turnaround deadlines
• Support cross functional initiatives working with IT and the commercial organization

Minimum Requirements:

Qualifications, Education, & Experience

• Bachelor’s Degree required
• Category insights experience in the Consumer-Packaged Goods (CPG) industry is preferred
• Strong analytical skills in Microsoft Excel (Pivot Tables, V-Lookups, Advanced Formulas), PowerPoint (Creating Charts/Tables, Building Stories, Animations), Tableau, and other Third-Party software applications (Qlikview)
• Syndicated Scan & Panel Data Analysis (Circana, Numerator, 1010 retailer gateway data)
• Retailer Gateway experience is a plus

Skills & Abilities

• Strong communication and interpersonal skills
• Sound problem-solving abilities and critical thinking
• Ability to prioritize and manage multiple projects at one time