Advanced Analytics & Revenue Strategy Reporting Analyst

About the role

The Advanced Analytics & Revenue Strategy Reporting Analyst will develop and maintain reports that answer business questions and deliver insights to drive sales and profit for Ocean Spray. This role works cross‑functionally with multiple business partners, translating complex data sets into clear dashboards and supporting data‑driven decision making.

Key responsibilities

• Update sales, media, innovation, and buyer behavior reporting.
• Assist with sales and trade‑spend reporting, data queries, pulls and analyses.
• Optimize existing reports, improve front‑end and back‑end, and support transition to centralized reporting workspaces.
• Provide insights and trends to facilitate data‑driven decisions.
• Develop report tracking, KPIs, and dashboards aligned with key business questions.
• Analyze large, complex internal data sources and deliver analytic solutions.
• Perform ad‑hoc analyses to answer business questions and support decision‑making.

Required profile

• Bachelor’s degree (required).
• At least 1 + year of relevant experience.
• Understanding of syndicated (e.g., Nielsen, IRI, SPINS) and POS data.
• Familiarity with key financial metrics and their drivers.
• Strong written and oral communication skills.

Required skills

• PowerBI (or other reporting platform) for data modeling and dashboard creation.
• SQL for data extraction and manipulation.
• Advanced Excel for analysis and reporting.
• Visualization software to create actionable insights.

What we offer

• Comprehensive insurance package starting Day 1, including health, dental, vision, and wellness programs.
• 401(k) with up to 6 % company matching and potential discretionary match.
• Flexible scheduling, vacation pay up to three weeks, and holiday pay for 12 holidays.
• Short‑term incentive/performance bonuses and long‑term incentive opportunities.
• Career development programs, tuition assistance, and LinkedIn Learning access.
• Parental leave, adoption assistance, and childcare support through Bright Horizons.