Bottler Sales Business Analyst Ii

Job Overview

The Bottler Sales Business Analyst II is responsible for supporting our Bottler Sales purchaser's weekly order management receipts, processing order modifications, and providing weekly order confirmations and deliveries to support loads and any other special cases. This position also manages emergency load requests, forecasting requests of new SKU launches, package or promotional conversions, and coordinates any invoice corrections. The Bottler Sales purchasers have licensed bottlers or distributors of Coca-Cola products and other leading beverage brands and the Bottler Sales Business Analyst II will serve as a point of contact for 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

• Monitors deliveries that are tendered to Red Classic Transportation and Product Supply Planning Logistics teams
• 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 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
• 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 an emergency load or add-in requests
• Reviews and monitors orders for any duplicate orders receipts, identifying allocation misalignments and, or improper weights; completing audits to ensure frequent parcels are not ordered and checks against multiple line items across multiple orders are adjusted to the same load
• 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
• Provides approval with the Purchasers for the returns of dunnage
• 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
• Leads customer management activities for assigned bottler sales purchasers and CCCI plant centers (PC)s by managing weekly order receipts following service level agreements (SLA)
• Works directly with bottler sales customers to adjust or correct any identified discrepancies
• 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
• Assists bottler sales purchasers with transportation requests and any load problems to ensure bottler sales purchaser needs are met
• Monitors the return of dunnage loads by comparing purchased vs. returned dunnage

Knowledge, Skills, & Abilities

• Strong organizational skills
• Strong analytical, problem-solving, and troubleshooting skills
• Exhibit a customer-friendly attitude at all times
• An active member with Product Supply Planning cross-functional projects and task force initiatives
• 2-5 years of Business and Analytical, Planning Experience in a demanding environment
• Customer Focused
• Knowledge of Planning Systems and use of Microsoft Office Products
• Builds upon relationships and keeps others informed of progress towards shared goals
• Detail-oriented
• Keeps customers engaged and informed of status and progress
• Must be detail-oriented & possess the ability to work unsupervised
• Dedicated to providing high-quality service to internal and external customers
• Strong written and oral communication skills - including cross-functionally
• The Bottler Sales Business Analyst II must be able to perform a robust evaluation of order management and provide stellar customer service. This role 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
• Seeks out collaborative solutions to address customer issues
• Tailors communication to meet the needs of key partners and situations
• Takes the necessary action to support customer needs and concerns
• Sales and Operations Planning, Inventory Management, or other Bottler or Transportation Industry
• Ability to prioritize time in a dynamic environment

Minimum Qualifications

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

Preferred Qualifications

• N/A

Work Environment

Office Environment