Data Migration & Analytics Intern - ETL, Dashboards & SQL

Hill's Pet Nutrition; Overland Park (KS); Hybrid; USD 25,000 - 39,000; Full time

Job summary

Colgate-Palmolive Company is seeking a Data and Analytics Intern in Overland Park, KS to support data modeling, data collection and transformation, and analytics documentation for Pet Studio. You will collaborate with supply chain, data engineering, and analytics teams to maintain dashboards and automate analytics workflows.

The role emphasizes SQL, Google Apps Script, Python, and front-end visualization using DOMO and Looker Studio, with hybrid work and a 20-hour weekly commitment during the

Qualifications

• Strong analytical and problem-solving skills
• Excellent communication and teamwork abilities
• Ability to work independently and manage multiple tasks
• Basic understanding of data migration concepts and ETL processes

Responsibilities

• Data Modeling & Design: Define and structure data models using SQL in Snowflake and BigQuery.
• Data Collection & Transformation: Execute data collection and transformation with SQL and Google Apps Script; ensure data quality.
• Data Documentation: Document data processes, models, and transformation workflows.
• Front-End Visualization: Create dashboards/reports with DOMO and Looker Studio; train end-users.
• Automation: Identify opportunities to automate analytics with JavaScript in Snowflake and Google Apps Script.
• Pet Studio Media Management: Support Pet Studio in DOMO and media analytics for TV HQ.

Job description

Colgate-Palmolive Company is seeking a Data and Analytics Intern in Overland Park, KS to support data modeling, data collection and transformation, and analytics documentation for Pet Studio. You will collaborate with supply chain, data engineering, and analytics teams to maintain dashboards and automate analytics workflows.

The role emphasizes SQL, Google Apps Script, Python, and front-end visualization using DOMO and Looker Studio, with hybrid work and a 20-hour weekly commitment during the