Business Analysis Manager (Planning)

Job Description

Company Summary

Constellation Brands is a leading international producer and marketer of beer, wine, and spirits with operations in the U.S., Mexico, New Zealand and Italy. We offer a wide range of exciting career opportunities in sales, marketing, operations, production, finance, and administration. As a part of the Constellation team, employees are encouraged to improve their skills and performance throughout their careers through various professional and educational development programs. Constellation provides a robust onboarding program in addition to ongoing training initiatives to help employees integrate into the organization quickly and maximize their potential growth.

Position Summary

This position is responsible for supporting critical forecasting & planning processes for the Beer National Accounts Off Premise sales organization. Working closely with the larger National Accounts Operations team and cross-functional partners, this individual will play a pivotal role in facilitating the development of chain forecasts for Innovation items and other priorities throughout the year. Responsibilities include the set-up of related tools & processes, collection & analysis of sales data, validation of outputs, and ongoing sales support and training. They will also enable execution and achievement of business objectives by enhancing cross-functional collaboration, ensuring effective communication & integration of chain plans across the business, monitoring the team’s performance to forecast, identifying potential opportunities or risks, and elevating actionable insights to key stakeholders.

This individual will report directly to the Director, Business Unit Operations.

Responsibilities:

• Lead Spring/Fall innovation forecasting for National Accounts, including both Top-Down and Bottoms-up processes
  • Co-own overall forecasting process, timeline & deliverables with Director
  • Lead set-up & maintenance of templates and forecasting tools (i.e. Anaplan) on behalf of National Accounts
  • Draft related communications & provide training/support to National Account sales team as needed to build effective forecasts
  • Collaborate with SET and cross-functional teams to ensure alignment to commercial processes and key timelines
  • Create forecast roll-ups & provide change analyses
  • Assist in forecast review & validation, identifying potential risks or opportunities
  • Support validation of localized forecasts in partnership with SET
  • Drive continuous improvement of forecasting tools & processes with the goal of maximizing accuracy while also simplifying the experience for Sales stakeholders
• With Director, customize & communicate Chain forecasts to various stakeholders (geographic BUs, SET, Operations) to ensure visibility & timely integration into company forecasts
• Support execution and achievement of distribution & volume goals by validating allocations & orders versus forecasts, proactively identifying any risks & gaps
• Own National Accounts Performance-to-Forecast reporting on an ongoing basis; identify & elevate any risks to National Accounts leadership; relay reporting to Business Analysis Manager (Reporting & Analytics) for use in team KPI tracking
• Facilitate integration of innovation forecasts into National Accounts’ annual business plans; provide support to team on overall Annual Business Planning process
• Lead ad-hoc National Accounts forecasting projects throughout the year (e.g. forecasts for off-cycle launches, items with potential supply constraints, etc.). Develop & own a standardized template and process
• Support Director in consolidating insights from National Account sales team on distribution and velocity drivers & drags (e.g. material distribution changes or incremental retailer programming) and disseminating to Ops and Geo-BU Operations teams for use in S&OP
• Support National Accounts Operations team, leadership, & sales on ad-hoc requests and projects as needed to ensure success against strategic priorities & plan

Minimum Qualifications

• A bachelor’s degree and a minimum of eight years’ experience working in a sales/market analysis or operations/forecasting position. Bev Alc industry or CPG experience strongly preferred.
• Excellent quantitative and analytical skills with the ability to provide reporting & multi-level analyses. Demonstrated ability to translate data into actionable insights & recommendations.
• Must have knowledge & experience with business information reporting and planning tools. Demonstrated ability to learn internal software applications and specializ