Advanced Analytics - Retail

No relocation assistance offered. Work visa sponsorship is not available for this position; applicants must be currently authorized to work in the U.S. on a full-time basis without requiring sponsorship.

About the role

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. At Hill’s, we transform the lives of millions of pet families through pioneering innovation and science-led nutrition. As the US #1 Veterinarian-recommended pet food brand, our mission is to enrich and lengthen the special relationships between people and their pets. This role focuses on secure data access, extraction, and transcription to support business and brand strategies through high-fidelity datasets.

Responsibilities

• Serve as the subject matter expert for retail data ingestion and transcription.
• Work and operate within a clean room environment to securely access, query, and transcribe raw data analytics from retail, producing clean, governed datasets for strategic analysis.
• Develop and implement automated processes for data extraction, cleaning, and transcription from the clean room to reduce manual effort.
• Maintain strict data governance and security protocols specific to clean room operations and compliance requirements.
• Partner with commercial teams to ensure transcribed data meets modeling and analytical requirements.
• Support automation and scalability of clean room and retail data workflows for self-service analytics.
• Provide accurate and timely Ad Hoc data sets and analysis focused on the retail channel.

Requirements

• Bachelor's degree.
• 3+ years of related experience focused on secure data handling, data engineering, or transcription within a regulated environment.
• Proven experience working within a "clean room" or secure data enclave environment.
• Expertise in SQL and programming languages (R/Python) for advanced querying and data pipeline development.
• Experience in breaking down sophisticated data transformation problems to find data solutions that drive business growth.

Preferred Qualifications

• Proficiency in cloud-based data storage and processing (e.g., GCP, AWS).
• Experience with retail data providers (e.g., IDEXX, or similar).
• 4+ years in Business Analytics.
• Experience in the CPG (Consumer Packaged Goods) or Animal Health industry.
• Familiarity with data governance policies and PII compliance best practices.

Pay

Salary Range: $109,600.00 - $155,000.00 USD. Pay is determined based on experience, qualifications, and location. Salaried employees may also be eligible for discretionary bonuses, profit-sharing, and long-term incentives for Executive-level roles.

Benefits

• Comprehensive benefits package including medical, dental, vision, and basic life insurance.
• Paid parental leave and disability coverage.
• 401(k) retirement plan with company matching contributions (subject to eligibility requirements).
• Minimum of 15 vacation/PTO days and 13 paid holidays (prorated based on hire date).
• Paid sick leave adjusted based on role and location in accordance with local laws.