Forecast COE Modeler

Job ID: R-12069

Position Overview: Why Join Coca-Cola North America?

It’s an exciting time to work in The Coca-Cola Company’s flagship market. We’re accelerating our momentum as the fastest-growing large consumer goods company in North America by putting people at the heart of our business and everything we do – whether we’re innovating to give consumers the drinks and packaging sizes they want, or building our eCommerce capabilities. People are our focus when we’re collaborating with our diverse network of locally-connected bottling partners, and when we’re returning every drop of water we use to communities and nature. And people – with the different backgrounds, skills and perspectives they bring to our workplace – are helping transform our business, one big idea at a time. We empower our employees to challenge the status quo, make bold recommendations, experiment and adapt, so we can grow together and make a great business even better.

Function Specific Activities:
The purpose of this role is to build a critical capability in forecasting, modeling, and analyzing our volume and revenue for US Operational Finance team. We have a new capability in Anaplan, which requires an expert in modeling in the platform, including creating new ones, making enhancements to the current ones, as well as providing user support.

This role sets the US Ops Finance team to get on the right track of digitizing our processes, in accordance with James Quincey’s vision. This is a critical investment that we should be making early in the process of developing and deploying Anaplan models that enable and support the automation of FP&A (Financial Planning and Analysis). It is important that we continue to build on the great foundation in Forecasting CoE to collaborate internally and externally with the Bottlers.

To achieve that goal, the Anaplan Modeler will first engage in ensuring that the current Anaplan models in use are working well, and continue to develop functionalities. The Modeler will also own and lead designing, modeling, and deploying multi-dimensional models in the Anaplan platform by translating business processes into capability requirements. This role will help expand current models already in use by understanding the additional features requested by internal (and external, such as Customers and Bottlers) partners to enable further connectivity among cross-functional processes and teams. Most of our data modeling, scenario planning (“what if” analyses), and forecasting (Case Sales Equivalent, Incidence Pricing Settlement, etc.) are currently done in Excel, saved on individual employees’ laptops.

In addition, the Modeler will liaise with other Finance functions (e.g., Controllers’ Group) and IT to translate the business process requirements to support inbound and outbound data integrations to and out of CCNA financial systems (e.g., BPC) and data sources (e.g., FDW, Teradata) and Anaplan models (current and future).

KEY DUTIES & RESPONSIBILITIES

Primary Point of Contact for Finance Org, Anaplan Users and Business Community for Anaplan Modeling: The Modeler must understand the business processes within FCOE and Finance/Controllers’ Group to effectively evaluate and translate the requirements into the current models in use across the US Ops org and the Bottling System.

Integrity of Anaplan Models and Data Hub: Manage, govern, and protect the Anaplan Models in use; ensure the integrity of Data Hub to feed and connect into the Models; translate the Finance requirements into an effective tool to improve, support, and automate currently manual processes.

Accountability for Data Quality in Anaplan: Work with Master Data teams, IT, and Finance leads to ensure accurate data feeding into Data Hub and Anaplan.

Anaplan Governance Lead: Create, develop, and maintain a governance model within the Anaplan platform to control expansion and rollout of Models.

Primary Liaision for IT: Liaise between Finance and IT to ensure optimal data feeds into Anaplan Models and Data Hub; find best solutions to leverage available and most optimal data sources to meet future state requirements (e.g., FDW to HANA S4).

Team Development, Mentoring: As a Modeler, this role is expected to provide guidance and mentorship to the Forecast Managers on the team to optimize the forecasting processes, stat models, and additional features released by Anaplan platform.

Anaplan Application SME Role: As other Finance and Business functions show interest in potentially leveraging Anaplan, the Modeler will provide POV and guidance on the best approaches to translate requirements into the Models.

Best Practice Ownership: The Modeler will own keeping up with the latest developments through latest releases, user community, and various online training opportunities. S/he will translate the relevant ones into tools, tips and tricks in FCOE and other Finance models.

INTERNAL REPORTING RELATIONSHIP(S)

Reports to: Group Director, FCOE

Direct Reports: None

Indirect Reports: collaborate closely with Commercial, Supply Chain, National Retail Sales, National Product Supply, Franchise Leadership and Brands

QUALIFICATIONS

Understanding of finance, sales, operations and supply chain

Self-motivated, independent, and focused on continuous skill development and expansive learning

High level of interpersonal and communication skills

Successful track record of cross-functional project management

Ability to work under pressure and tight deadlines, and prioritize

Attention to detail, disciplined, and strongly focused on high quality end-product

Experience in Agile Methodology preferred

Strong interest in developing expertise in Anaplan, Tableau, Micro Strategy, HANA S4 and other modeling tools, databases, visualization capabilities

EDUCATION LEVEL REQUIRED

Bachelor’s Degree in Computer or Industrial Engineering, Business, Finance, Supply Chain or related degree

EXPERIENCE REQUIRED

7-10+ years’ experience in area of Forecasting, Data Modeling and Visualization, Automation, and Business Analytics

Minimum 10+ years in finance, planning, forecasting, and/or supply chain roles

5+ years in direct experience with designing, modeling and deploying multi-dimensional systems such as Cognos, Tableau, Hyperion, Business Objects, TM1, etc.

EXPERIENCE PREFERRED

MBA or other supply chain, planning, finance-related masters degrees preferred

TECHNICAL KNOWLEDGE AND SKILLS

Strong data modeling and visualization skills

Extensive analytical skills

Advanced Excel/Access skills

Proficiencies with Tableau, Microstrategy, forecasting systems (APO, SAS, JDA, etc.) preferred

Job Requirements:
Years of Experience: 7-10 Years Experience

Leadership Behaviors:
DRIVE INNOVATION: Generate new or unique solutions and embrace new ideas that help sustain our business(encompassing everything from continuous improvement to new product and package innovation).

COLLABORATE WITH SYSTEM, CUSTOMERS, AND OTHER STAKEHOLDERS: Develop and leverage relationships with stakeholders to approximately stretch and impact the System (Company and Bottler).

ACT LIKE AN OWNER: Deliver results, creating value for our Brands, our System, our customers, and key stakeholders.

INSPIRE OTHERS: Inspire people to deliver our mission and 2020 Vision, demonstrate passion for the business and give people a reason to believe anything is possible.

DEVELOP SELF AND OTHERS: Develop self and support others’ development to achieve full potential.

Growth Behaviors:
GROWTH MINDSET: Demonstrates curiosity. Welcomes failure as a learning opportunity.

SMART RISK: Makes bold decisions/recommendations.

EXTERNALLY FOCUSED: Understands the upstream and downstream implications of his/her work. Tracks and shares external trends, best practices or ideas.

PERFORMANCE DRIVEN AND ACCOUNTABLE: Has high performance standards. Outperforms her/his peers.

FAST/AGILE: Removes barriers to move faster. Experiments and adapts. Thrives under pressure and fast pace.

EMPOWERED: Brings solutions instead of problems. Challenges the status quo. Has the courage to take an unpopular stance.

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.