Category Insights Analyst (Specialty Small Format)

Mark Anthony Group; Chicago (IL); On-site; 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

Mark Anthony Group is looking for a Data Analyst to join their dynamic team in Chicago, IL. The role involves analyzing point-of-sale and household panel data, providing key insights for assortment and merchandising decisions while supporting category management.

Ideal candidates will have at least 1 year of relevant experience in the Consumer-Packaged Goods industry, strong technical skills in Excel, and the ability to create impactful data visualizations in PowerPoint. Competitive salary and benefits offered.

Qualifications

• 1+ years of experience in category insights in CPG.
• Proficient in Microsoft Excel (Pivot Tables, V-Lookups).
• Strong technical skills in data visualization.

Responsibilities

• Analyze market trends to identify consumer preferences.
• Interpret sales data to provide performance insights.
• Develop category management strategies.

Skills

Category insights experience

Microsoft Excel

Data visualization in PowerPoint

Analytical mindset

Tools

Circana

Numerator

Qlikview

Job description

Mark Anthony Group is an entrepreneurial drinks company built from the ground up by thinking differently, innovating, and doing the unexpected. Our company is rooted in family values, a bold vision, and relentless determination to continuously raise the bar and make a positive difference in consumers' lives. Founded in 1972, we’ve grown organically from a one‑person import wine business into an international drinks company whose hallmarks include a portfolio of luxury wineries and iconic beverage brands, including White Claw® Hard Seltzer, Mike’s Hard Lemonade, and Cayman Jack.

The role is responsible for analyzing point‑of‑sale scan and household panel data across the total US, 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, while supporting category management and shelf validation tasks on an ad‑hoc basis.

Accountabilities

• Market Trend Analysis: analyze market trends to identify emerging segments, consumer preferences, and shifts in the market.
• Sales Data Analysis: interpret 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 to translate complex data sets into clear, actionable recommendations for the business.
• Competitive/Predictive Analysis: monitor and analyze competitors' strategies, market positioning, trends, and sales performance.
• Category Management Strategies: develop strategies for category management, including product assortment and pricing strategies.

Key Metrics & Financial Targets

• Volume (40%)
• Distribution (30%)
• Budget Management (15%)
• Off‑premise share (15%)

Own

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

Influence

Category insights impact 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 and customers.

Veto

The 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, CS&I
• Third‑Party Data Providers
• Curating Insight stories
• Sales Reporting: Retailer gateway
• 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