Advanced Analytics & Revenue Strategy Reporting Analyst

Ocean Spray; Lakeville (MA); On-site; USD 65,700 - 82,100; Full time

Benefits offered by this job

Full benefits from Day 1

401(k) with company match

Career development opportunities

Job summary

Ocean Spray is hiring an Advanced Analytics & Revenue Strategy Reporting Analyst to develop and maintain reports that address business questions and deliver insights driving sales and profit. The role collaborates with multiple partners to translate complex data into clear dashboards and KPIs.

The ideal candidate has a Bachelor's degree and 1+ years of experience with syndicated and POS data, PowerBI, SQL, and Excel, and can communicate insights effectively to stakeholders.

Qualifications

• Bachelor's degree required.
• 1+ years of relevant experience.
• Understanding of syndicated data (e.g. Nielsen, IRI, SPINS) and POS data.
• Experience with PowerBI and data modeling, reporting, and dashboards.
• Proficiency in SQL, Excel, and visualization tools to create reports and insights.

Responsibilities

• Update sales, media, innovation, and buyer behavior reporting.
• Assist with Sales & Trade spend reporting, data queries, pulls and analyses.
• Support optimization of existing reports and transition to centralized reporting workspaces.
• Help facilitate data-driven decision making by providing insights and trends.

Skills

PowerBI

SQL

Excel

Data analysis

Stakeholder communication

Education

Bachelor's Degree

Job description

## Advanced Analytics & Revenue Strategy Reporting AnalystApplylocations: Lakeville, MA: Boston, MAtime type: Full timeposted on: Posted 3 Days Agojob requisition id: R5269Ocean Spray is hiring for a(n) Advanced Analytics & Revenue Strategy Reporting Analyst! We’re a team of farmers, thinkers, creators, and doers. Whatever your title, whatever your role — it always comes back to this: we’re a farmer-owned co-op where everyone rolls up their sleeves to get the job done. Three maverick farmers started it all — and we’ve been making our own way ever since.The Advanced Analytics & Revenue Strategy Reporting Analyst impacts the future success of Ocean Spray by developing and maintaining reports that address business questions and deliver insights that lead to greater sales and profit. The role requires the ability to work cross functionally with multiple business partners and stakeholders. The ideal candidate will have strong organizational skills and the ability to prioritize and manage multiple simultaneous projects and deadlines. The ability to translate multiple complex data sets into clear and concise reporting and dashboards is essential to the role. They will also assist with the development, integration, and commercialization of learnings across Ocean Spray and functional partners to analyze data, standardize KPIs, develop internal score cards, all while driving best practices.**A Day in the Life...*** Update sales, media, innovation, and buyer behavior reporting.* Assist with Sales & Trade spend reporting, data queries, pulls and analyses.* Support the optimization of existing reports inclusive of both front end and back-end improvements as well as support the transition to centralized reporting workspaces.* Help facilitate data driven decision making by providing insights and trends pertinent to the business.* Work to understand key business questions and assist in developing report tracking, KPIs and dashboards to help best manage the business.* The ability to analyze large, complex internal data sources, providing analytic solutions, cross-group guidance, and support training where necessary for interpretation and implementation of results.* Ability to perform ad hoc analyses to answer business questions and support decision-making**What We Are Looking For:****Required*** Bachelor’s Degree* 1+ years of relevant experience* Understanding of syndicated (e.g. Nielsen, IRI, SPINS) and POS data* Understanding of PowerBI (or other reporting platform) including establishment of data models, applications, reporting, and executive dashboards* Use tools like SQL, Excel, and visualization software to create reports, conduct ad hoc analyses, and communicate actionable insights to stakeholders* Understanding of key financial metrics and their drivers* Strong written and oral communication**Education:**Bachelor's or University Degree (Required)**Work Experience:**At least 1 Year of Experience**Annual Salary:**$65,700 - $82,100*The base salary range information above serves as a guideline of the position’s typical hiring range. We value and appreciate what makes you unique and will consider a variety of factors when determining an offer. These factors include, but are not limited to, your skills and experience, external and internal benchmarks, as well as overall company considerations. Certain positions may be eligible for short-term and long-term incentive rewards. We also offer a competitive and comprehensive benefits program that supports all aspects of your health and well-being.***Benefits:*** Complete insurance package on Day-1 that includes a plethora of health and wellness programs* + Health, Dental, and Vision insurance + Health savings account + Flexible spending account + Life and accident insurance + Employee assistance program + Telehealth services + 1:1 health coaching + Supportive benefits for all the stages of your life* 401(k) with up to 6% Company matching; additional potential discretionary match at year-end* Short-Term Incentive/Performance bonuses* Flexible scheduling options* Vacation pay, up to three weeks of time (pro-rated for your first year of employment)* Holiday pay for 12 holidays* Career development and growth opportunities* Tuition/Education assistance programs* Access to LinkedIn Learning* Scholarship programs for children of employees* Parental leave* Bright Horizons Family Solutions – Back-up care, tutoring, etc.* Adoption assistance* Bereavement leave* Up to $300 fitness reimbursement* Up to $300 massage reimbursement* Employee appreciation events* Employee discounts* Charitable giving**Who We Are:**You might have our iconic cranberry juice in your fridge or have gotten into heated holiday debate about what’s better - canned or fresh cranberry sauce. But did you know that the hardworking people growing the superfruit in our products are 700 family farmers that own our cooperative? They entrust us with what is most precious to them to create new and innovative products that will delight consumers and grow this beloved brand today and into the future. Team members, farmers, consumers and communities alike--we value what makes us unique and strive to connect our farms to families for a better life by living our values:* **G**rower Mindset – We embrace our grower-owners innovative spirit and heritage through confidence, learning and focus on the future.* Sustainable **R**esults – Guided by purpose, we are focused on delivering results for our grower-owners.* **I**ntegrity Above All – We are ethical, doing the right thing for our grower-owners, customers, consumers and each other* Inclusive **T**eamwork – We build diverse and inclusive teams that strengthen our cooperative.*All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status.*