Data Analytics Specialist

Job Description

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 recognized 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 programs 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.

Information at a Glance

Job Title: Data Analytics Specialist

Travel Required?: Travel - up to 10% of time

Posting Start Date: 10/7/25

Hybrid

No Relocation Assistance Offered
Job Number #169618 - Sao Paulo, Sao Paulo, Brazil

Who We Are

Colgate-Palmolive Company is a global consumer products company operating in over 200 countries specializing 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.

Position Summary

The Data Analytics Specialist will be the main technical and analytical point of contact for the Retail Category Development (RCD) team. This professional will be responsible for managing the entire sellout and market data infrastructure, ensuring the quality, optimization, and accessibility of data. Their job will be to transform large volumes of raw data into strategic insights, actionable dashboards, and automation tools that drive team productivity and category growth.

Key Responsibilities

Data Management and Engineering
- Database Management: Responsible for the management and integrity of the client’s sellout database.
- ETL and Optimization: Create, oversee, and maintain ETL (Extract, Transform, Load) processes using tools like DOMO and Snowflake, aiming for data optimization and preparation for complex analyses.
- Data Mapping: Map and manage several internal and external data sources, ensuring that all required information is integrated and ready to use.
- Market Data: Responsible for managing the market database in the CP Genius system.
Analysis, Insights, and Reporting
- Dashboard Creation: Develop and maintain dashboards in Domo (or equivalent BI tool), ensuring key metrics are clearly and intuitively visualized for the RCD team.
- Analytical Support: Act as a strategic partner to the RCD team, providing in-depth insights and analytical solutions that support assortment, pricing, and exposure decisions.
- Critical KPI Reporting: Responsible for reporting and regularly monitoring essential company KPIs, including ND (Numeric Distribution), WD (Weighted Distribution), SOA (Share of Assortment), and Productivity.
- Product Segmentation: Report and analyze product segmentation from Scanntech (or equivalent retail panel tool).
Automation and Innovation
- Automation and Tools: Create automations and develop tools (scripts, models, etc.) to significantly increase the RCD team’s productivity and enable new types of analyses.
- AI Projects: Actively participate in and lead the implementation of Artificial Intelligence (AI) projects within the RCD team, aiming to optimize processes and generate predictive insights.

Qualifications

Mandatory Requirements:

Solid experience in Data Analytics, Business Intelligence, or Data Engineering.
Advanced expertise in SQL for querying and handling large data volumes.
Practical experience with data warehousing tools, such as Snowflake.
Proficiency in creating dashboards and managing data on BI platforms (preferably Domo).
Strong knowledge and/or previous experience with retail and sellout data, especially KPIs such as ND, WD, and Share.

Preferred Qualifications:

Knowledge of Python or R for automation and advanced statistical analyses.
Experience with retail panel data (e.g., Scanntech, Nielsen, Kantar).
Experience with Machine Learning/Artificial Intelligence projects applied to sales, retail, or category optimization.
Knowledge of the CP Genius system.

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, color, 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