CBS C2C Data Analyst

Colgate; Ciudad de México; Híbrido; MXN 300.000 - 540.000; Jornada completa

Descripción de la vacante

Colgate-Palmolive in Mexico City is seeking a Temp C2C Data Analyst to join the Credit-to-Cash team for a 6-month assignment. You will audit invoices, analyze remittance scenarios, and ensure compliance with payment terms while partnering with cross-functional teams.

The role requires a Bachelor’s degree, 1+ year of data analytics experience, fluent English, strong SQL skills, and advanced Excel with Power Query.

Formación

• Bachelor’s degree or equivalent in a related field.
• 1+ years of experience in commercial or financial data analysis or related roles.
• Professional English fluency to interface with regional systems.
• Proficient in SQL to extract, join and filter data from multiple sources.
• Advanced Excel skills including Power Query, data modeling, complex functions, pivot tables, and VBA.

Responsabilidades

• Audit detailed invoice-level remittance scenarios to prevent revenue leakage.
• Map and resolve non-standard customer payment methods and remittance structures.
• Track compliance curves and trends to identify payment risks and ensure policy alignment.
• Partner with Continuous Improvement to feed insights into system enhancements and dashboards.

Conocimientos

SQL

Advanced Excel

Data analysis

English fluency

Educación

Bachelor's degree

Herramientas

SAP

Power BI

Domo

Looker Studio

VBA

Descripción del empleo

Established in 1806 as a small soap and candle business in New York City, Colgate-Palmolive is now a truly global company with products sold in over 200 countries and territories under such internationally recognised brand names as Colgate, Palmolive, Softsoap, Irish Spring, Protex, Sorriso, Kolynos, elmex, Tom's of Maine, Sanex, Ajax, Axion, Soupline, Haci Sakir, Suavitel, PCA SKIN, EltaMD, Filorga and Hello as well as Hill's Science Diet and Hill's Prescription Diet.

Colgate-Palmolive is a leading consumer products company that serves hundreds of millions of consumers worldwide with brands and products across four core businesses – Oral Care, Personal Care, Home Care and Pet Nutrition. We are committed to offering products that make lives healthier and more enjoyable, and programmes that enrich communities around the world.

Every day millions of people trust our products to care for themselves and the ones they love. Our goal is to use our technology to create products that will continue to improve the quality of life for our consumers wherever they live.

A career at Colgate-Palmolive is an excellent opportunity if you seek a global experience, constant challenge, and development opportunities in an environment that respects work/life effectiveness.

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)

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 should you require accommodation.

#LI-Hybrid