Data Migration & Analytics Intern (Hybrid)

Colgate; Overland Park (KS); Hybrid; USD 25,000 - 33,000; Part time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

Life insurance

Parental leave

401(k) with company match

Paid time off

Paid holidays

Paid sick leave

Job summary

Colgate-Palmolive Company is offering a Data Migration and Analytics Intern role in Overland Park, KS. You will help design data models, collect and transform data with SQL across Snowflake and BigQuery, and build interactive dashboards with Looker Studio and DOMO in a collaborative, hybrid environment.

You will gain hands-on experience in data governance, automation, and analytics delivery, working closely with supply chain and data teams, while developing skills in Python/SQL and BI tools.

Qualifications

• Currently pursuing a degree in CS, Data Science, Information Systems, Supply Chain Management, or related field.
• Available to work hybrid at our Overland Park, KS office location throughout the entire Co-Op.
• Must be available to work 20 hours/week during the academic semester.
• Strong analytical and problem-solving skills.
• Excellent communication and teamwork abilities.
• Ability to work independently and manage multiple tasks simultaneously.
• Basic understanding of data migration concepts and ETL processes.

Responsibilities

• Data Modeling & Design: Define and structure data models with cross-functional teams.
• Design and implement data models using SQL within Snowflake and BigQuery for analysis and reporting.
• Data Collection & Transformation: Plan and execute data collection and transformation using SQL and Google Apps Script.
• Document data processes, models, and transformation workflows for clarity and reproducibility.
• Front-End Visualization: Build dashboards/reports using CP tools (e.g., DOMO, Looker Studio).
• Collaborate with stakeholders to understand visualization needs and deliver insights.
• Provide training and support to end-users for dashboards and reports.
• Analytics Automation: Develop automation scripts to streamline workflows and improve efficiency.
• Pet Studio: Support development and maintenance of Pet Studio in DOMO, media management for TV analytics.
• Presentations/Workshops: Contribute to Advanced Analytics and AI sessions and note improvements.

Skills

Analytical skills

Communication

Teamwork

Independent work

ETL concepts

Education

Pursuing BS/MS in CS/DS/IS

Tools

SQL

Power BI

Tableau

SAP Analytics Cloud

Job description

Colgate-Palmolive Company is offering a Data Migration and Analytics Intern role in Overland Park, KS. You will help design data models, collect and transform data with SQL across Snowflake and BigQuery, and build interactive dashboards with Looker Studio and DOMO in a collaborative, hybrid environment.

You will gain hands-on experience in data governance, automation, and analytics delivery, working closely with supply chain and data teams, while developing skills in Python/SQL and BI tools.