Manager Advanced Analytics

Colgate-Palmolive; Ciudad de México; Hybrid; MXN 600,000 - 900,000; Full time

Job summary

Colgate-Palmolive in Mexico City seeks a data analytics professional to participate in advanced analytics projects including Pricing & MMM and BI reporting. You will transform syndicated data into actionable insights to drive profitability and growth.

Collaborate on visualization, dashboards and models to support pricing strategy and regional expansion, working with Global Analytics to ensure data quality and informed business decisions.

Qualifications

• Bachelor Degree is required.
• Intermediate SQL and Python; experience with visualization tools (Power BI, Tableau, DOMO).
• Advanced Excel skills and data visualization experience.
• Analytical mindset with attention to detail and accuracy.
• Team-oriented with planning and prioritization skills.
• English: high-intermediate/advanced.
• 2+ years in insights/marketing/business intelligence roles.
• Demonstrated Data Science experience.

Responsibilities

• Participate in ETL processes and build data lakes and automation/visualization using global IT tools like BigQuery and DOMO.
• Develop models for Consumption, Marketing and Digital Effectiveness.
• Create new visualizations and analytics to support decision making and growth scenarios.
• Advance analytics tools to support pricing strategy, including ROI calculations and promo analysis.
• Expand use of analytics tools across the region in collaboration with local business.
• Support marketing mix modeling with data extractions and validations.
• Ensure quality requirements, segmentation and enhancements.

Skills

SQL

Python

Power BI

Tableau

DOMO

BigQuery

Excel

Data Visualization

Education

Bachelor Degree

Tools

SQL

Python

Power BI

Tableau

DOMO

BigQuery

Job description

No Relocation Assistance Offered

Job Number #177098 - 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.

Job Summary

• Participate in advanced analytics projects like Pricing & MMM, and fundamental Business Intelligence analytics (reporting and simplification)

• Support the analysis and implement new processes to improve our company’s performance and profitability based on Syndicated data and connecting the dots with people centricity knowledge

• Collaborate in the implementation of the right visualization of reports, analysis and dashboards to drive business decisions

Principal Duties and Responsibilities

• Support the Implementation of Analytics Plan, participating in ETL process, building the data Lake and automation / visualization using global IT tools like bigquery and DOMO.

• Deploy / Create models to be used in Consumption Model, Marketing and Media/Digital Effectiveness, PnP, incorporate into the model best practices from Global Analytics and GIT

• Create new visualization and analytics according to Colgate needs to support the decision making process and strategic scenarios to growth

• Participate in the Implementation of Advanced Analytics tools to support price strategy and other pricing analysis which include new functionalities like calculation of return over the investment, analysis of effectiveness for temporary price reduction, promo – packs and any other prize activity implemented.

• Expand the usage of Advanced Analytics tools across the region, working close to local business to solve main business questions

• Participate in the advanced analytics marketing mix modeling for core categories, supporting with all data extractions and validations, to identify opportunities to optimize marketing investment

• Responsible for Quality requirements, new segmentations and enhancements

Requirements

• Bachelor Degree

• Intermediate SQL, Python, experience with visualization tools like power BI, locker, tableau. DOMO, etc

• Excel advanced

• Creative & curious mindset

• Analytical skills, sense for details & accuracy

• Organized & Efficient & Reliable

• Teamwork approach

• Planning/Priority Settings

• English High Intermediate/advanced

• Previous experience in insights/marketing/ business intelligence positions (+2 years)

• Evident Data Science experience

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