Position Overview:

This role is responsible for supporting the creation of the $20BN Coca-Cola System Revenue Plan for North America Operating Unit (NAOU). The role requires strong stakeholder collaboration, technical, analytical, and problem-solving skills.

Responsible for ensuring the NAOU bottler and System revenue plan is accurately reflected in Anaplan and other planning systems for each of the key stakeholders – Brand, National Retail Sales (NRS), Finance and Franchise Leadership & Bottler

Assist with design, creation and implementation of analytical tools that support clients in developing the bottler revenue plan (clients include – NRS, Bottler Revenue Growth Management (RGM), Zone Finance, Franchise Leadership, Warehouse, National Foodservice, NAOU Finance, Commercial Leaders)

Provides support for the development and stewardship of the NAOU annual bottler revenue plan

Act as a SME to client groups to support the delivery of quality input into the planning process (process and tools)

Responsible for managing the National List Price file, coordinating, and aligning with NAOU RGM Category team, Bottlers and BSNA on all changes.

Accountable for assisting with the annual package alignment.

Leads automation of monthly COGS updates and assumptions.

Function Related Activities/Key Responsibilities:

Supports the Annual Bottler and Customer Revenue Planning Process Working with Stakeholders

Conduct Plan Cube Data Reviews and Reconciliations

Review/Reconcile cube updates to ensure consistency and alignment with bottler, customer, and category inputs

Ensure cube integrity by bottler, customer, and package, including review and follow up with Mainstream bottlers

Support the development and testing of System Planning tool enhancements before they go live

Run ad-hoc analytics and build reports that enable better, more timely and more effective Planning Decisions

Accountable for Supporting, Automating and Enhancing Planning Tools Aligning with Users

Support Plan Cube Updates in CAPS and CAPS Maintenance

Manages initial plan loads, copy data between scenarios, push data from Apollo to CAPS, load cogs rates and EQ conversions

Make updates in the CAPS Cube assumptions based on input from bottler, customer or category teams, Update Intermediary files that feed Access and Excel Cube analytics

Review, maintain and update CAPS hierarchies, periods, innovation packages and other key parameters

Simplify User Experience and Drive CAPS Optimization / User Friendliness

Optimize CAPS, cleans out obsolete models or code

Seek architectural solutions that enhance speed and stability of the tool

Prevent unintended changes in the cube (leverage learnings from the 2021 and 2022 planning seasons)

Adapt CAPS where needed based on evolving business/stakeholder needs, such as off-cycle price increases, NAOU Org changes, etc.

Leads Enabling Processes that Support Planning and Business Decisions

Manages COGS monthly analytics and system updates

Gather & process inputs from CCBSS, bottlers and finance teams

Periodically check integrity and accuracy

Enable better understanding of incremental Mainstream costs (e.g., freight)

Maintain Hierarchy mappings used for Planning analytics

Strawman Channel and Package Category mappings

Customer/Package combinations and treatment for Centralized Pricing

Customer Mappings by Governance treatment (CCLT, RCLB), Call Point owner, Centralized Pricing Treatment, Zone and Customer Team mappings, Voting Swim Lanes, and degrees of freedom,

Point of contact on Annual Realignment and Hierarchies

Support the annual realignment of hierarchies with bottlers and internal stakeholders (Brand/Category teams, Forecasting COE, Performance Mgmt.) during FIRM routines with IT, Masterdata, NRS, Category, Forecasting COE,

Manages Client Relationships

Interface directly with bottlers, customer teams, brand/category, and finance teams to integrate their assumptions in the cube

Detect gaps or errors in stakeholder inputs and follow-up/communicate/coach individual bottler, customer and category teams on the analytical inputs required for System Cube integrity, transparency, and effective collaboration

Support integration and handling of bottler custom forecasts as base in the bottler cube

Functional Skills:   

Strong conceptual, strategic thinking, problem solving, technical and analytical skills

Minimum of 2 years of Anaplan or other modeling tool/platform experience

Understanding of data architecture and integration across platforms

Advanced Excel and database modeling skills required

Expertise with Anaplan and Microsoft Access skills preferred

High level of tenacity and attention to detail

Curiosity – drive to identify better ways to work, to understand the what behind the numbers

Strong collaboration skills

Strong strategic & systematic thinking (forward-looking vision and anticipating of future needs)

Identify client needs and creates value; proven ability to work with high degree of autonomy once given direction.

Education Requirements: 

Minimum Required:  Bachelor’s degree (engineering, finance/analytics, business)

MBA or advanced degree preferred

Related Work Experience: 

Minimum Required: 

Minimum of 3+ years’ experience in sales, finance or RGM with expertise in customer planning, focused on delivery of world-class results in a complex, distributed environment.

Demonstrated ability to deliver upon results; ability to make decisions in ambiguous situations

Experience working on complex analytical problems

Demonstrated ability to apply strong technical skills to solve complex problems

Skills:

Leadership; Microsoft Office; Business Intelligence and Analytics; Communication; Strategy Development; Scorecards; Problem Solving; General Accepted Accounting Principles (GAAP); Project Management; Agile Methodologies; Financial Forecasting; Data Modeling

Our Purpose and Growth Culture:

We are taking deliberate action to nurture an inclusive culture that is grounded in our company purpose, to refresh the world and make a difference. We act with a growth mindset, take an expansive approach to what’s possible and believe in continuous learning to improve our business and ourselves. We focus on four key behaviors – curious, empowered, inclusive and agile – and value how we work as much as what we achieve. We believe that our culture is one of the reasons our company continues to thrive after 130+ years. Visit Our Purpose and Vision to learn more about these behaviors and how you can bring them to life in your next role at Coca-Cola.

We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity and/or expression, status as a veteran, and basis of disability or any other federal, state or local protected class. When we collect your personal information as part of a job application or offer of employment, we do so in accordance with industry standards and best practices and in compliance with applicable privacy laws.