Category Insights Analyst (Specialty Small Format)

Mike’s Hard Lemonade Co.; Chicago (IL); Hybrid; USD 70,000 - 80,000; Full time

Benefits offered by this job

Bonus plan

Comprehensive health benefits

401(k) matching

Paid time off

Job summary

Mike’s Hard Lemonade Co. in Chicago is seeking a Category Insights Analyst to analyze market trends and provide data-driven insights. The position requires strong technical and analytical skills, especially in Excel and data visualization.

The salary ranges from $70,000 to $80,000, and the role includes comprehensive benefits and opportunities for career growth. Candidates should have at least 1 year of experience in the Consumer-Packaged Goods industry, focusing on category insights.

Qualifications

• 1+ years of category insights experience in Consumer-Packaged Goods (CPG).
• Strong technical skills in Microsoft Excel, including Pivot Tables and V-Lookups.
• Experience with data visualization tools like PowerPoint.

Responsibilities

• Analyze market trends to identify shifts in consumer preferences.
• Provide insights on sales performance metrics.
• Manage and interpret data from various sources.

Skills

Category insights experience in CPG

Microsoft Excel

Data visualization in PowerPoint

Analytical mindset

Tools

Qlikview

Household panel data platforms

Job description

Category Insights Analyst (Specialty Small Format)

Job Category: Sales

Requisition Number: CATEG006417

• Full-Time
• Hybrid

Location

Illinois
167 N Green Street
Suite 600A
Chicago, IL 60607, USA

The role is responsible for analyzing point-of-sale scan and household panel data across total U.S., markets, and retailers. This role will work with the manager to develop fact-based data presentations and reports that lead to better assortment and merchandising decisions for national accounts and key regional retailers. Supporting category management and shelf validation tasks on an ad-hoc basis.

Accountabilities

• Market Trend Analysis: Analyzing market trends to identify emerging segments, consumer preferences, and shifts in the market.
• Sales Data Analysis: Interpreting sales data to provide insights on performance metrics.
• Data Management & Analytics: Use various data sources, including retail sales data, household panel data, syndicated and custom research, and market analysis. Work with manager to interpret and translate complex data sets into clear and actionable recommendations for the business.
• Competitive/Predictive Analysis: Monitoring and analyzing competitors' strategies, market positioning, trends, and sales performance.
• Category Management Strategies: Developing strategies for category management, including product assortment and pricing strategies.

Volume (40%)

Distribution (30%)

Budget Management (15%)

Off‑premise share (15%)

Ownership

• Data analysis and insights
• Reporting and dashboards
• Tracking and monitoring performance

Influence: Category Insights impacts retailer decisions, such as product assortment, shelf placement, and merchandising strategies. Collaborate with Sales on strategies tailored to region or territory, considering local market conditions/customers.

Veto: Role is more about influencing decisions through insights and recommendations rather than having direct authority to veto initiatives or decisions.

Critical Relationships: Sales, National & Key Account Team, Regional Account Teams, etc CS&I

Third Party Data Providers

Curating Insight stories

Up to date Shopper metrics in category and studies on Flavor

Skills Needed To Be Successful

• Preferably 1+ years of proven category insights experience in the Consumer‑Packaged Goods (CPG) industry, leveraging syndicated scan & household panel data platforms (Circana, Numerator).
• Strong technical skills in Microsoft Excel (Pivot Tables, V‑Lookups, formulas) and other third‑party software applications (Qlikview).
• Strong data visualization skills in PowerPoint.
• Eagerness to learn new concepts, analytics, and technical applications.

Compensation

Compensation offered to prospective team members has taken internal equity into consideration and can vary depending on a position’s location. The final agreed upon wage may vary based on the job‑related knowledge, skills, and experience of the individual.

• Competitive annual salary from $70,000 to $80,000 based in Chicago, IL.
• Bonus plan designed to recognize company performance and individual contributions.
• Comprehensive health and welfare benefits.
• Company matching 401(k) contributions.
• Paid time off including annual leave, paid sick time and holidays.
• Extensive opportunities for training, development, and career growth.

Equal Opportunity Employer. This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.