Hybrid Data Migration & Analytics Intern (20 hrs/wk)

Colgate

Overland Park (KS)

Hybrid

USD 25,000 - 39,000

Part time

3 days ago

Be an early applicant

Application generator

A complete application in a minute — tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Hybrid work arrangement

Paid internship

Job summary

Colgate-Palmolive (Hill’s Pet Nutrition) offers a Data Migration and Analytics Intern role in Overland Park, KS. You will support data modeling, collection, transformation, and documentation for Pet Studio analytics, with emphasis on front-end visualization and automation.

The internship develops SQL, data governance, and dashboard skills using DOMO/Looker Studio in a hybrid setting, with travel up to 10%.

Qualifications

Currently pursuing a degree in CS, Data Science, IS, or SCM.
Available to work hybrid at Overland Park, KS for the full Co-Op.
Able to commit 20 hours/week during the academic semester.
Strong analytical, communication, and teamwork skills.
Basic understanding of data migration concepts and ETL processes.

Responsibilities

Assist in data modeling and design for analytics projects.
Design and implement data models using SQL in Snowflake and BigQuery.
Assist in data collection and transformation using SQL and Google Apps Script.
Document data processes and maintain data sources and workflows.
Create and maintain interactive dashboards with DOMO and Looker Studio.
Support automation initiatives and Pet Studio media management; help prepare presentations.