Data Analytics Specialist
Colgate-PalmoliveBrazil1 day ago
Full-timeResearch, Analyst +1
Track This Job
Add this job to your tracking list to:
- Monitor application status and updates
- Change status (Applied, Interview, Offer, etc.)
- Add personal notes and comments
- Set reminders for follow-ups
- Track your entire application journey
Save This Job
Add this job to your saved collection to:
- Access easily from your saved jobs dashboard
- Review job details later without searching again
- Compare with other saved opportunities
- Keep a collection of interesting positions
- Receive notifications about saved jobs before they expire
AI-Powered Job Summary
Get a concise overview of key job requirements, responsibilities, and qualifications in seconds.
Pro Tip: Use this feature to quickly decide if a job matches your skills before reading the full description.
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
Mandatory Requirements:
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.
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.
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.
- 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 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.
Key Skills
Ranked by relevanceReady to apply?
Join Colgate-Palmolive and take your career to the next level!
Application takes less than 5 minutes