Job Overview

The Bottler Sales Business Analyst III is responsible for supporting the planning and order management workflow, production, and distribution of CCCI’s full goods for our bottler sales purchaser regions; where the priority is making sure we have the products available to sell. This position supports innovation execution processes (new SKU launches, product conversions, in and outs and exit) strategies, for their assigned functional area; works cross-functionally with Product Supply Planning on project initiatives to support best business decisions; and provides support on emerging new purchasers or locations, and system change management. The Bottler Sales purchasers have licensed bottlers or distributors of Coca-Cola products and other leading beverage brands and the Bottler Sales Business Analyst III will serve as a point of contact for the internal and external stakeholders including but not limited to our bottling purchasers, finance, warehousing, product supply planning, manufacturing, raw material procurement, and Red Classic Transportation.

Duties & Responsibilities

• Leads customer management activities for assigned bottler sales purchasers and CCCI plant centers (PC)s by managing weekly order receipts per service level agreements (SLA)
• Reviews and monitors orders for any duplicate order receipts, identifying allocation misalignments and, or improper weights
• Works directly with bottler sales customers to adjust or correct any identified discrepancies
• Develops purchaser relationships and supports purchaser service initiatives through the timely and effective management of high-volume daily email correspondences and processes sample order requests from bottler sales purchasers
• Supports team with strategic initiatives and reporting needs, including but not limited to holiday planning, plant consolidation initiatives; any purchased item reporting needs; researching and resolving any critical exceptions, any authorized material list (AML)s changes or data load errors
• Monitors deliveries and manage any outside bottler sales account-specific deliveries not in alignment with the Purchaser Pick-up Authorization or Red Classic Transportation agreements
• Monitors deliveries that are tendered to Red Classic Transportation and Product Supply Planning Logistics teams
• Assists bottler sales purchasers with transportation requests and any load problems to ensure bottler sales purchaser needs are met
• Facilitates Production Capacity and product availability by collaborating with the Product Supply Production Scheduling team on production capacity, moving or canceling purchaser orders, communicating any requested revisions, and handling the emergency load or add-in requests
• Analyzes and forecasts future purchases of new SKU launches and partners with scheduling to meet future demand, while communicating any discontinued SKUs planned for deletion
• Monitors the return of dunnage loads by comparing purchased vs. returned dunnage
• Provides approval with the Purchasers for the returns of dunnage
• Supports billing resolutions by reconciling sales invoices against submitted purchaser Bottler Return Form (BRFs) for discrepancies on orders, researching discrepancies with warehouse, and tracking and monitoring the purchased vs returned dunnage
• Performs other duties as assigned

Knowledge, Skills, & Abilities

• Sales and Operations Planning, Inventory Management, or other Bottler or Transportation Industry
• Experience with ERP, Planning Systems, Supply Chain, Procurement
• Strong written and presentation skills
• 2-5 years of Business and Analytical, Planning Experience in a demanding environment
• Knowledge of Planning Systems and use of Microsoft Office Products
• Strong written and oral communication skills - including cross-functionally
• Strong analytical, problem-solving, and troubleshooting skills
• Strong organizational skills
• Must be detail-oriented, ability to work unsupervised, ability to prioritize time in a dynamic environment, and possess a customer-friendly attitude at all times
• Performs the robust evaluation of order management and provides stellar customer service
• Coordinates multi-facets of bottler sales planning to support new item SKU launches, strategic collaboration to support sales initiatives, and drives optimal forward deployment planning to support our internal and external partner's execution strategies
• Active member with Product Supply Planning cross-functional projects and task force initiatives. Ability to identify and adapt to company SKU strategy changes, coordinate, and drive efforts within the direct team to support these objectives
• Required to have a broad understanding of all CCCI supply chains with the ability to represent the key disciplines to internal and external customers and key CCCI partners
• Lead resource for their functional area for complex research, support, and troubleshooting
• Strong analytical and fact-based problem solver. Ability to establish and maintain effective relationships by gaining customer collaboration, trust, and respect
• Must be able to effectively interface across multiple levels of the organization to be successful

Minimum Qualifications

• Bachelor’s degree (4 years)
• Knowledge acquired through 3 to up to 5 years of work experience
• Supply Chain, Logistics, Finance, Communication, or Business Administration

Work Environment

Office Environment