Collection and Coding Analyst

Location: Mexico City, Mexico

Company: Colgate-Palmolive

Reports To: Junior Team Lead

About the Role

Colgate-Palmolive is seeking a Collection and Coding Analyst to join our Hub in Mexico City as a critical financial bridge within our global Order-to-Cash (O2C) cycle.

Reporting to the Junior Team Lead, you will ensure the end-to-end financial integrity and accuracy of the United States Accounts Receivable ledger by securing customer payment remittances and precisely codifying commercial and operational deductions. Joining our dynamic Finance team, you will have a direct impact on North American working capital optimization and cash flow efficiency while partnering with global stakeholders to advance our purpose to Make More Smiles.

Key Responsibilities

• Remittance Management & Strategic Coding: Secure, monitor, and meticulously categorize customer payment documentation, analyzing short payments to ensure accurate classification into Gross-to-Net (GTN) or Supply Chain/Logistics categories.

• Proactive Collections & Dispute Resolution: Engage directly with US customers to retrieve missing remittance details, maintaining rigorous audit trails to achieve first-contact resolution of payment variances.

• Cross-Functional Collaboration: Serve as the operational bridge between local and regional functions, collaborating with US Sales, Logistics, and Local Finance teams to validate or dispute deductions, escalating complex issues to Senior Analysts.

• Financial Reporting & Analytics: Generate and analyze periodic reports on unapplied cash, aging balances, and deduction trends to identify portfolio risks and eliminate cash leakage.

• Portfolio Account Maintenance: Execute complex portfolio actions—including customer refunds, debit/credit offsets, and non-sufficient funds (NSF) reversals—for both high-tier and standard US accounts.

Required Qualifications

• Education: Bachelor’s Degree in Accounting, Finance, Economics, Business Administration, or a related field (Completed or actively in progress).

• Language Skills: Advanced professional fluency in written and spoken Business English.

• Experience: 2+ years of experience within an Order-to-Cash (O2C), Accounts Receivable, or General Accounting function.

• Technical Skills: Operational proficiency in SAP, specifically within FI-AR modules for data extraction, transaction clearing, and sub-ledger analysis.

Preferred Qualifications

• Tools: Advanced command of Microsoft Excel (including VLOOKUPs and Pivot Tables) and Google Workspace enterprise suites.

• Soft Skills: Proven negotiation skills with the ability to manage complex customer interactions and influence positive payment behaviors.

• Mindset: Strong analytical mindset with a data-driven approach to root-cause problem solving.

• Adaptability: Ability to work effectively under tight financial close deadlines in a fast-paced environment.

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