CBS C2C Data Analyst

Colgate-Palmolive; Ciudad de México; Presencial; MXN 420.000 - 540.000; Jornada completa

Descripción de la vacante

Colgate-Palmolive is seeking a Temporary C2C Data Analyst in Mexico City to support the Credit-to-Cash team. You will audit invoices, analyze remittance scenarios, and help safeguard cash flow during a 6-month assignment.

You will partner with cross-functional teams, maintain dashboards, and translate complex data into actionable insights. Strong SQL, Excel, and English fluency are essential to succeed in this role.

Formación

• Bachelor’s degree in a relevant field.
• 1+ years of experience in commercial or financial data analysis, deductions management, accounts receivable (C2C/AR), or financial analytics.
• Professional English fluency to interface with regional systems and cross-functional partners.
• Proven proficiency writing SQL queries to extract, join, and filter structured datasets across multiple sources.
• Advanced Excel skills, including Power Query, data modeling, complex functions, pivot tables, and VBA macros.

Responsabilidades

• Execute detailed invoice-level audits across complex multi-scenario combinations—including discount rates, price bases, payment timeliness, and low-value deductions to prevent unearned leakage
• Map and resolve non-standard customer payment methods, complex remittance structures, and edge cases bypassing automated system logic
• Track compliance curves and behavioral trends across active clients to identify payment risks and ensure policy alignment
• Partner directly with the Continuous Improvement team to feed operational insights into system enhancements, maintain dashboards, and deliver data-driven recommendations to cross-functional stakeholders

Conocimientos

SQL

Excel

Power Query

Data modeling

Pivot tables

VBA macros

English fluency

Educación

Bachelor’s degree in Business Administration, Finance, Accounting, Data Analytics, Software/Data Engineering, or related field

Herramientas

SAP

Domo

Looker Studio

Power BI

Descripción del empleo

No Relocation Assistance Offered

Job Number #175877 - Del.Miguel Hidalgo, Mexico City, Mexico

Who We Are

Colgate-Palmolive Company is a global consumer products company operating in over 200 countries specialising in Oral Care, Personal Care, Home Care, Skin Care, and Pet Nutrition. Our products are trusted in more households than any other brand in the world, making us a household name!

Join Colgate-Palmolive, a caring, innovative growth company reimagining a healthier future for people, their pets, and our planet. Guided by our core values—Caring, Inclusive, and Courageous—we foster a culture that inspires our people to achieve common goals. Together, let's build a brighter, healthier future for all.

C2C Data Analyst (Temporary 6 months opportunity)

Location - Mexico City

Role Summary

As a Temporary C2C Data Analyst sitting within the Credit-to-Cash team and reporting directly to the Jr Credit to Cash Team Lead, you will serve as the critical analytical bridge between data insights, commercial operations, and financial governance (SG 10). In this 12-month assignment, you will play a key role in auditing complex remittance scenarios, driving commercial compliance, and protecting cash flow following prompt payment term updates. By converting raw data and edge-case exceptions into actionable stories, you will directly safeguard revenues while partnering with Continuous Improvement teams to optimize automated workflows.

Responsibilities

• Execute detailed invoice-level audits across complex multi-scenario combinations—including discount rates, price bases, payment timeliness, and low-value deductions to prevent unearned leakage
• Map and resolve non-standard customer payment methods, complex remittance structures, and operational edge cases that bypass automated system logic
• Track compliance curves and behavioral trends across active clients to identify payment risks and ensure organizational policy alignment
• Partner directly with the Continuous Improvement team to feed operational insights into system enhancements, maintain interactive dashboards, and deliver data-driven recommendations to cross-functional stakeholders

Required Qualifications

• Bachelor’s degree in Business Administration, Finance, Accounting, Data Analytics, Software/Data Engineering, or a related field
• 1+ years of experience in commercial or financial data analysis, deductions management, accounts receivable (C2C/AR), or financial analytics
• Professional English fluency to effectively interface with regional systems and cross-functional partners
• Proven proficiency writing SQL queries to extract, join, and filter structured datasets across multiple sources
• Advanced Excel skills, including Power Query, data modeling, complex functions, pivot tables, and reading/editing VBA macros

Preferred Qualifications

• Working knowledge of SAP (AR, Deductions, or Cash Application modules) and visualization platforms like Domo, Looker Studio, or Power BI
• Experience transforming messy remittance data and raw ERP extracts into clean, actionable databases
• Strong business curiosity and critical thinking to identify root causes behind variances and validate data against business logic
• Commercial and financial acumen to evaluate customer payment behaviors and proactively prevent revenue leakages
• Proactive problem-solving abilities comfortable navigating process transitions and ambiguity

Please note that this role is a temporary opportunity with a duration of 6 months .

Our Commitment to Inclusion

Our journey begins with our people—developing strong talent with diverse backgrounds and perspectives to best serve our consumers around the world and fostering an inclusive environment where everyone feels a true sense of belonging. We are dedicated to ensuring that each individual can be their authentic self, is treated with respect, and is empowered by leadership to contribute meaningfully to our business.

Equal Opportunity Employer

Colgate is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, colour, religion, gender, gender identity, sexual orientation, national origin, ethnicity, age, disability, marital status, veteran status (United States positions), or any other characteristic protected by law.

Reasonable accommodation during the application process is available for persons with disabilities. Please complete this request form (https://docs.google.com/forms/d/e/1FAIpQLSdaxk_eF4utznQoVHlxmL9jVFJbOkM4Oe5CAdKOg-h9EPdLfg/viewform) should you require accommodation.

#LI-Hybrid