DMI ROI Analyst

Job description

DESCRIPTION & REQUIREMENTS:

Position Overview:

JOB OBJECTIVE:

Overall responsibility for marketing investment funds (DME and marketing deductions) for LCBU (5 Franchise Units: Venezuela, Colombia, Ecuador, CAMCAR and Division)

Strong support on budgetary control to ensure LCBU FO management can readily understand status of all spend (actual, commitment, available) across all FUs and Bottlers.

Support financial management through risk and opportunity tracking and understanding via continuous relationship building with budget executors and Finance contacts

Co-ordinate the approval / system process of DME campaigns, follow-up and communication with Commercial Finance, Marketing and Operations teams regarding DME spending.

Driving value understanding and DME efficiencies in collaboration with Finance Planning Manager

ESSENTIAL JOB FUNCTIONS (Key Accountabilities)

·  Works closely with relevant operations and finance teams (GFO, MEM CENTER, AP, P2P) including bottlers to maintain robust budgetary control of DME and Marketing Deductions across the FU
·  Secures DME and marketing deductions actuals in line with Company Policies and procedures
·  Coordinate the collaboration with IPM on actual, RE and BP preparation and submissions.
·  Accurate delivery of data for monthly Rolling Estimate process in close collaboration with FU operation contacts and MEM CENTER
·  Analyze spending YTD/YTG, trends v PY and BP.
·  Analyze spending by category (Media, Shopper etc..)
·  Analysis of budget marketing expenses and evolution tracking
·  Lead the DMI review during FU Marketing budget meetings and Monthly Business Reviews with Finance Planning Manager.
·  Track related DMI risks & opportunities at FU level.
·  Provide financial facts & analysis to with relevant benchmarks for routine management reporting and to support decision making & business planning
·  Develop close working relationships with key FU associates to ensure they receive appropriate DMI support and analysis
·  Captures data in a way which supports Procurement Managers driving savings in our strategic spend and more informed understanding of Marketing spend
·  Manage ad-hoc request related to DMI analysis. This include support to Finance Planning manager for – BU/FO analysis
·  Business Plan process map, data collection and analysis for and in line with agreed Business Plan target and process
·  Train FU marketing teams on DMI management and reporting
·  Local FU Business Plan process map, data collection and analysis for and in line with agreed Business Plan deadlines and process
·  Support Audit preparation and follow up with C&C and assist CAD/external audit

PERFORMANCE CRITERIA

·  Obtain necessary understanding and meet all internal and external deadlines both in terms of integrity, accuracy and completeness – act as a team player
·  Achieve transparency in reporting and budget management via process management and constant dialogue with internal customers through pro-active management of budgeting and planning solutions and support of budget coordinators in the different departments in a way that secures accurate and complete reporting of our marketing expenditure
·  Successful audits by internal and external auditors both in terms of management, planning, documentation and follow-up
·  Driving and advocating financial thinking and value orientation in all Marketing projects
·  Interpretation of financial data to help budget holders understand, plan & manage their funds
·  Continuous improvement: be proactive in providing continuous feed backs to our key finance support functions to keep improving quality  of the work delivered

 

KEY CONTACTS FOR ROLE:

·  FU team: leadership and operations teams
·  Finance : LCBU MEM, Finance Planning Manager, Budget Managers, GBS teams (GFO, AP, MEM CENTER, P2P, Control and Compliance teams; MEM process manager)
·  Others : creative agencies, Bottlers

EDUCATION:

• Graduate i specialized business studies with major in financial management accounting and controlling or similar relevant study.

EXPERIENCE:

• 3-4 yearsof relevant working experience

• Knowledge of marketing controlling
• In depth understanding and knowledge of TCCC systems, business processes and governance skills.

QUALIFICATIONS / REQUIREMENTS:

a. Functional Competencies
• Strong Attention to detail
• Strong persuasion and influencing skills
• Communication & presentation skills
• Self-motivation / act autonomously
• Ability to operate in an environment of uncertainty
• Ability to operate in a virtual environment with multi-country stakeholders

b. Core Competencies
• Drives Innovative Business Improvements: Develops new insights into solutions that result in organizational improvements; promotes a work environment that fosters creative thinking, innovation and rational risk-taking.
• Balances Immediate and Long-Term Priorities: Seeks to meet critical objectives while considering the impact of those decisions and activities on the ability to achieve long-term goals.
• Delivers Results: Focuses on the critical few objectives that add the most value and channels own and others' energy to consistently deliver results that meet or exceed expectations.

• Develops and Inspires Others: Builds and maintains relationships that motivate, guide, and/or reinforce the performance of others toward goal accomplishments. Develops self and others to improve performance in current role and to prepare for future roles; seeks and provides feedback and coaching to enhance performance.
• Imports and Exports Good Ideas: Relentlessly seeks, shares and adopts ideas and best practices in and outside the Company and embraces change introduced by others.
• Lives the Values: Demonstrates the values of The Coca-Cola Company through words, actions, and by example; fosters an environment that reflects the values of the company.

Technical skills:

• Financial knowledge including budgeting, reporting, accounting.

• Excellent skills in SAP, MEM, MS-Excel; ability to use MS-Word & MS-Power Point.

TRAVEL: 20% primarily within BU/FU

At The Coca-Cola Company you can cultivate your career in a challenging and dynamic environment. We are the largest manufacturer and distributor of nonalcoholic drinks in the world-selling more than 1 billion drinks a day. Unlock your full potential with a future-focused company that is known and respected throughout the world.