This position is responsible for coordinating all chain business reporting and analysis in the assigned Business Unit. Working in conjunction with Key Account Managers, under the direction of the Chain Director in the assigned geographic area, Chain Analyst develops comprehensive presentations based on research, data gathering and analysis. Provides Scorecards and detailed causal reports for monthly division sales, as well as retail post promotion analysis and opportunities.
SPECIFIC DUTIES AND RESPONSIBILITIES
Works directly with Chain Director to develop and implement Annual Business plan for assigned Key Accounts within the Business Unit. Collaborates with Key Account Managers and provides analytics to support Crown’s Chain sales initiatives for internal and external customers. Works in conjunction with Key Account Managers to capture all Crown portfolio authorizations / distribution mandates by retailer as well as identifies all distribution voids via internal data reporting. Leads Business Unit Chain communication process coordinating all critical aspects of BU Chain department such as monthly ad features and new distribution updates and disseminates to Crown field sales and wholesaler organizations. Develops and maintains Business Unit Key Accounts market data analysis, benchmarking and scorecard reporting on results vs. goals using tools such as depletions, class of trade analysis, distribution, Crown Retail Standards, SMART, CPGN, SPECTRA, IRI, Query Studio/Epiphany and Beer Institute data. Compares actual results to objectives on a monthly, trimester and calendar year basis. Develops and circulates a template of reports recapping data analysis and assists in communicating those results/opportunities to Chain Director and field sales personnel.
Assists in the creation and compilation of trimester information to include, sales and distribution results vs. goals. Prepares summaries of information and analysis for the Chain Director and Key Account Managers for use in wholesaler Trimester reviews.
Assists in the gathering and input of information and sales data for the monthly BU Results Call. Captures causal sales data for the Business Results Call on a monthly basis and submits to the BU Chain Director.
Under the direction of the Business Unit Chain Director, assists in the division monthly sales forecast process by utilizing SMART data, wholesaler generated forecasts, trend analysis, price promotion history and any other criteria impacting sales trends for the forecast period.
Trains and coaches the field sales organization in the utilization of IRI / CPGN, SPECTRA, SMART data and reports. Assists in the on-boarding and training of new hires.
Assists in the development of presentation materials for Key Account Buyer calls, wholesaler meetings, BU sales meetings, as well as national accounts and corporate requests.
Builds pre and post promotional templates that include sales results vs. objectives through IRI and depletion data, resulting in specific actionable Key Account presentations for major promotional periods i.e., Cinco de Mayo, Memorial Day, 4 th of July, etc.
Functions as the division liaison and subject matter expert in support of several key initiatives including, but not limited to: Key Account Annual Business Plans, SMART, IRI, Authorization Mandate Monitor, Ad View, and Trimester review information.
Completes all assigned tasks within a reasonable time.
Reports directly to the Business Unit Chain Director
KNOWLEDGE, EXPERIENCE AND ABILITIES REQUIRED
This position requires:
A Bachelor’s degree and a minimum of three years experience working in a sales/market analysis position. Consumer goods experience preferred, alcohol beverage industry experience a plus.
Proficient with software to include Excel, Power Point, and Word and an aptitude to learn internal software applications as required.
Excellent written and oral communication skills with the ability to communicate across all levels of the organization.