Cold Drink Equipment Data Analyst

At Coca-Cola Europacific Aboitiz Philippines, we are driven by our purpose to Refresh the Philippines and Make a Difference – continuously leading the beverage industry with our Great People, Great Beverages, Great Execution, and Great Partners – Done Sustainably. As we continue to grow and shape the future, we are seeking passionate and innovative talents to join our team and make a difference with us.

Our commitment to excellence has been recognized through numerous industry awards by the Top Employers Institute, HR Asia Awards, Asia-Pacific Stevie Awards, HR Excellence Awards, and the Quill awards – and we are committed to continuously innovate, push boundaries, and create positive lasting impact to our people, customers, and the communities we proudly serve.

Role Overview

Cold Drink Equipment (CDE) Data Analyst is responsible for the timely management reporting and thorough data analytics, ensure data integrity of system generated reports by aligning across data input stakeholders, act as the official source and interpreter/qualifier of CDE reports and KPIs and manage CDE Database, platform and portal management

Key Roles and Responsibilities

Oversight and management of database Integrity

• Consolidation and maintenance of CDE database (Coolers, Fountains, dispensers, vending) records
• Periodic validation that data entered into the system, by end users, is compliant with guidelines set by CDE team
• Ensure data integrity of cross functional company reports specific to cold drink equipment (i.e. RED)
• Coordinate immediate mitigation/fixes of identified data integrity issues with HO and CU stakeholders

Alignment of database and system platforms

• Ensure that all dependent data end users and database platforms are updated if there is an update
• Collaborate with Internal Controls and Finance to ensure alignment of databases (EM, AM, IM)
• Coordinate with Sales processes to ensure EM and SAP customer master details and sales routes (SCLs) are always aligned/updated:
• RTM sites (DOG, Non DOG, Indirect)
• Non RTM (MEP/MLP Customer outlets with CDEs)
• Key Accounts (NKA and SA) customer database

Consolidation and analysis of Inventory

• Analyse productivity of in-trade CDEs (coolers and fountains)
• Analyse availability of on hand CDEs to ensure updated data
• Provide list of CDEs for condemnation and initiate process with CDEOEs
• Monitor CDEs on hand which are for repair
• Facilitate database updates for “found” CDEs which were formerly labelled as “missing”

Generate and interpret all indicators related to the daily operation of CDE operations

• Movements (placement, pull outs, replacement, refurbishment, disposal, right sizing)
• Productivity scores of CDEs in-trade…leading to recommendations for right sizing
• Operative KPIs (Service calls, repairs and maintenance, preventive maintenance, work orders)

Consolidate, analyse and investigate deviations on CAPEX and OPEX

• Perform monthly billing audits on purchased equipment, work orders – movements
• Monitor performance vs. BP vs. internal targets related to cost management
• Interpret and investigate financial risks (unplanned accruals, unpaid invoices, hanging work orders)

Data source and analytics for special projects related to CDE strategies

• Execute data gathering activities and cross functional coordination for CDE initiated special projects
• Participate in cross-functional meetings for special projects wherein CDE management is impacted
• Consolidate and analyse potential impact on CDE database as a result of special projects (CDE or non CDE led)

Position Requirements

• Bachelor's degree in Engineering / Management Engineering
• Knowledge in Database analytics and Compute Systems and platforms
• Knowledge on business processes and finance processes
• Background experience in Reporting
• Process oriented and systematic thought process
• Microsoft Office skills
• SAP background is a plus

Company Socials

Reach us through our social media pages!

LinkedIn: https://www.linkedin.com/company/coca_cola_europacific_aboitiz_philippines/

Facebook: https://www.facebook.com/cocacolaphcareers

Instagram: https://www.instagram.com/cocacolaphcareers/

Thrive with us at Coca-Cola Europacific Aboitiz Philippines and be part of a company that is dedicated to delivering refreshing moments with its diverse and inclusive workforce. Because at CCEAP, your individuality is celebrated, your voice is heard, and your contributions are valued.

CCEAP is proud to be an equal opportunity employer. We are committed to fostering an inclusive workplace where all individuals, regardless of race, color, religion, gender, sexual orientation, gender identity, age, disability, are treated with respect and have equal opportunities to grow and succeed. We believe that diverse teams lead to stronger ideas and better outcomes, and we are dedicated to ensuring a fair and equitable environment for all our employees.