Hybrid Data Migration & Analytics Co‑Op (20h/wk)

BSBF; Overland Park (KS); Híbrido; USD 36 000 - 44 000; Tempo integral

Resumo da oferta

Colgate invites a Data Migration and Analytics Co-Op in Overland Park, KS, hybrid internship. You will work across data modeling/design, data collection/transformation, and analytics automation to support Pet Studio and visualization efforts.

You’ll collaborate with data engineering and analytics teams, gain hands-on experience in BI tools, SQL, and front-end visualization, and contribute to cross-functional projects within a global company.

Qualificações

• Currently pursuing a degree in CS, DS, IS, or related field.
• Must be 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.

Responsabilidades

• Data Modeling & Design: Define and structure data models to support business requirements; design and implement models using SQL in Snowflake and BigQuery.
• Data Collection & Transformation: Plan and execute data collection/transformation using SQL and Google Apps Script; ensure accuracy.
• Data Documentation: Document data processes, models, and workflows for clarity and reproducibility.
• Front-End Visualization: Create and maintain dashboards/reports using CP tools (DOMO, Looker Studio); collaborate with stakeholders.
• Support for Analytics Automation Initiatives: Develop automation scripts to streamline workflows; monitor processes.
• Media Management of Pet Studio: Support development/maintenance of Pet Studio in DOMO and media analytics for TV.
• Presentation and Workshop Contribution: Standardize and schedule trainings on Advanced Analytics and AI; capture improvement notes.

Conhecimentos

Analytical skills

Problem solving

Communication skills

Teamwork

Independent work

Time management

ETL concepts

SQL basics

Formação académica

Undergraduate degree in CS/DS/IS/Supply Chain

Ferramentas

SAP Analytics Cloud

Tableau

Power BI

Python

SQL

Descrição da oferta de emprego

Colgate invites a Data Migration and Analytics Co-Op in Overland Park, KS, hybrid internship. You will work across data modeling/design, data collection/transformation, and analytics automation to support Pet Studio and visualization efforts.

You’ll collaborate with data engineering and analytics teams, gain hands-on experience in BI tools, SQL, and front-end visualization, and contribute to cross-functional projects within a global company.