Customer & Commercial Analyst at The Coca-Cola Company

The Coca-Cola Company (NYSE: KO) is the world's largest beverage company, refreshing consumers with more than 500 sparkling and still brands. Together with our bottling partners, we rank among the world's top 10 private employers with more than 700,000 system associates. Led by Coca-Cola, one of the world's most valuable and recognizable brands, our Company's portfolio features 20 billion-dollar brands, including Diet Coke, Fanta, Sprite, Coca-Cola Zero, vitaminwater, Powerade, Minute Maid, Simply, Georgia, Dasani, FUZE TEA and Del Valle. Globally, we are the No. 1 provider of sparkling beverages, ready-to-drink coffees, and juices and juice drinks. Through the world's largest beverage distribution system, consumers in more than 200 countries enjoy our beverages at a rate of more than 1.9 billion servings a day. With an enduring commitment to building sustainable communities, our Company is focused on initiatives that reduce our environmental footprint; support active, healthy living; create a safe, inclusive work environment for our associates; and enhance the economic development of the communities where we operate. Job Title: Customer & Commercial Analyst Position OverviewInterprets Volume/Value, Knowledge & Insights, Marketing Commercial and customer performance metrics and reaches informed conclusions on underlying trends and root causes.Is able to identify and summarize key issues and Identify inconsistencies and irregularities in market data and narratives Ensures consistency of Customer & Commercial reporting across the multiple franchise, BU and corporate stakeholders.Key Duties/ ResponsibilitiesCommercial Data AnalyticsPerformance Tracking (20%)Capture business plan commitments by market across volume, revenue, K&I and commercial.Capture consumer marketing calendar and programs for the yearTrack and consolidate actual volume, revenue, K&I and commercial metricsPrepare weekly/monthly/quarterly narrative & performance presentation after resolving irregularities and inconsistencies.Prepare & update C&CL commercial metrics and narratives for key group and corporate stakeholders.Prepare & update BU, Group and Corporate C&CL operations dashboardsPrepare Market and Commercial Insights as well as Macro Economics summaries for all markets and categoriesManage function budgets and financial obligations in partnership with finance.Commercial Project Coordination & Collaboration (20%)Consolidate charters and plans for all key commercial projects and initiatives and ensure alignment with BU strategy.Consolidate updates from various commercial subject matter experts as well as franchise commercial managers against the committed plans.Liaise with IT function to setup online communication and collaboration workspaces, upload content and manage updates for the CCL team.Customer Data Analytics (40%)Data collection and Analytics and Mining with narratives & performance presentationEnsure on time collection and reporting of data from all WABU MarketsWABU Organized Trade franchise Volume/Revenue/Outlets Report – MonthlyWABU top 30 Reports - QuarterlyEAG top 15 Customers - QuarterlyEAG top 30 Customers – QuarterlyBULT Customer Performance Report - MonthlyDevelop platform to Capture total organized trade volumes/ Revenues in WABUDevelop the scanning data module in the dashboard; collect organize scanning data from selected customers and develop reports to be used in the monthly and quarterly reviewsProvides all the necessary support to the Global Account teams (e.g. data analytics, market insights etc.)Business Plan Development inputs and Adhoc (20%)Prepare Business Plan Schedules Metrics – Volume, Outlet creation, Cooler Investment, Outlet Segmentation, sales force etc capturing current reality vs. annual and strategic (3 year) business plans.Prepare Ad hoc BP schedules as required.Ad hoc function requestsPrepare ad hoc analysis and presentations in support of CCL director as requestedLiaise with suppliers and bottlers.Communication ComplexitiesWithin The CompanyC&CL Subject Matter Experts, Franchise C&CL Managers (strategy insights, status updates, guidance, coaching)Franchise Manager, Operational Marketing Manager (market feedback, status updates)Marketing Associates (track deployment and execution of marketing programs)Sales Analyst (Track and report on volume performance)Outside The CompanyBottler Middle Management (track execution of BBP commitments)Bottler Customers, wholesalers and retailers (track execution of BBP in the trade)Judgment And Decision Making- Is able to provide relevant and appropriate insights and recommendations based on a firm grasp of commercial principles, franchise current reality and operating context.Innovation- Read market data, provide analysis to leadership team for decision making.

Apply at