Analyst, Category Development & Shopper Insights

Yerba Madre•Oakland, CA

4d•$89,000 - $116,000•Hybrid

About The Position

The Analyst, Category Development & Shopper Insights plays a meaningful role in shaping how Yerba Madre brings data, insight, and strategy to life for retail partners and internal teams. This role supports the development of consumer-, shopper-, and customer-focused strategies by transforming complex data into clear, actionable recommendations. This position serves as a key analytical and storytelling support partner to Sales, Marketing, and Product teams, supporting customer presentations, business planning, and commercial initiatives with thoughtful, well-grounded insights. This role will require a minimum of 3 days working on-site in our Oakland, CA office

Requirements

2–5 years of experience in consumer goods, retail analytics, category management, sales analytics, or shopper insights.
Strong proficiency in Excel, including pivot tables, formulas, and large dataset management.
Experience working with syndicated, POS, loyalty, and panel data to support business decision-making.
Familiarity with data sources such as Nielsen, IRI / SPINS, NPD Group, Numerator, 84.51°, dunnhumby, Stratum, Spectra, and Symphony RetailAI.
Ability to develop customer-ready presentations in PowerPoint or equivalent platforms.
Strong analytical mindset with a commitment to data accuracy and integrity.
Clear, confident communication skills with the ability to present insights to both technical and non-technical audiences.
Bachelor’s degree preferred.

Nice To Haves

Exposure to planogram software and merchandising tools is a plus.

Responsibilities

Develop and manage recurring monthly reporting on sales, distribution, velocity, pricing, and promotional performance.
Maintain and enhance dashboards, scorecards, mapping files, and analytical tools using Excel and BI platforms.
Conduct in-depth analyses on SKU performance, pack sizes, price tiers, and shopper behavior.
Monitor category trends, emerging brands, and competitive activity within the beverage space.
Build compelling, fact-based category stories and selling decks for key account and distributor meetings.
Deliver customized retailer readouts and account-specific insights.
Support joint business planning and annual business plan development with analytical insights.
Translate complex datasets into clear, concise, and practical recommendations.
Partner closely with Sales, Marketing, and Product teams on innovation sizing, white-space identification, and launch tracking.
Support assortment optimization, shelf strategy, and promotional effectiveness initiatives.
Provide ad hoc analysis to support executive requests and strategic priorities.
Contribute to shared learning and continuous improvement across teams.