Hill's Pet Nutrition, a part of Colgate-Palmolive, is looking to enhance its data modeling, collection, transformation, documentation, visualization, and automation capabilities for its central analytics depository, Pet Studio, which includes media management of analytics shown on TV. This role supports the supply chain, data engineering, and analytics teams to improve efficiency and provide actionable insights.
Requirements
- Design and implement data models using SQL within Snowflake and BigQuery
- Assist in planning and executing data collection and transformation activities using SQL and Google Apps Script
- Document data processes, models, and transformation workflows
- Create and maintain interactive dashboards and reports using CP tools (e.g., DOMO, Looker Studio)
- Identify opportunities to automate analytics processes and reporting using JavaScript in Snowflake and Google Apps Script
- Develop and implement automation scripts and tools
- Support the development and maintenance of Pet Studio in DOMO
Responsibilities
- Design and implement data models using SQL within Snowflake and BigQuery to facilitate efficient data analysis and reporting.
- Assist in planning and executing data collection and transformation activities using SQL and Google Apps Script, ensuring accuracy and efficiency.
- Support data validation, cleansing, and transformation processes to maintain data integrity and consistency.
- Document data processes, models, and transformation workflows to ensure clarity and reproducibility.
- Create and maintain interactive dashboards and reports using CP tools (e.g., DOMO, Looker Studio).
- Identify opportunities to automate analytics processes and reporting using JavaScript in Snowflake and Google Apps Script.
- Develop and implement automation scripts and tools to streamline workflows and improve efficiency.
Other
- Currently pursuing a degree in Computer Science, Data Science, Information Systems, Supply Chain Management, or a related field
- Must be available to work hybrid at our Overland Park, KS office location through September 2025 - May 2026
- No Travel
- Hybrid
- No Relocation Assistance Offered
