Advanced Analytics - Retail

Colgate•Overland Park, KS

8h•Hybrid

About The Position

The Advanced Analytics - Retail role is responsible for the secure access, extraction, and transcription of data analytics from the retail data that supports the business and brand strategies. This data transformation is critical for providing clean, high-fidelity datasets used to craft strategic opportunities to drive Hill’s growth, share, and overall profitability. This position will work closely with the commercial teams to ensure alignment to strategies, data fidelity and efficient execution of data outputs.

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 lead to business growth.

Nice To Haves

Proficiency in cloud-based data storage and processing (e.g., GCP, AWS).
Experience with retail data providers (e.g., IDEXX, or similar data).
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.

Responsibilities

Be the subject matter expert for retail data ingestion and transcription
Work and operate within a clean room environment
Securely access, query, and transcribe raw data analytics from retail to produce 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.