About the role#
As a Data Migration and Analytics Co-Op, you will work with supply chain, data engineering, and analytics teams. You will help maintain Pet Studio, which is a central analytics repository, and assist with media management. You will also focus on front-end visualization and analytics automation.
What you'll do#
- Define and structure data models to support business needs.
- Design and implement data models using SQL in Snowflake and BigQuery.
- Execute data collection and transformation using SQL and Google Apps Script.
- Support data validation, cleansing, and transformation to maintain accuracy.
- Document data processes, models, and transformation workflows.
- Create and maintain interactive dashboards using tools like DOMO and Looker Studio.
- Provide training and support to end-users for dashboards and reports.
- Identify and develop opportunities to automate analytics processes using JavaScript in Snowflake and Google Apps Script.
- Maintain Pet Studio in DOMO, including media management.
- Standardize and schedule presentations and workshops regarding Advanced Analytics and AI.
What you'll need#
- Current enrollment in a degree program for Computer Science, Data Science, Information Systems, Supply Chain Management, or a related field.
- Availability to work 20 hours per week during the academic semester.
- Strong analytical and problem-solving skills.
- Ability to work independently and manage multiple tasks.
- Basic understanding of data migration concepts and ETL processes.
- Excellent communication and teamwork abilities.
- Proficiency in programming languages such as Python or SQL is preferred.
- Experience with BI tools like SAP Analytics Cloud, Tableau, or Power BI is preferred.
Location & details#
- This role is based in Overland Park, KS.
- You must be available to work in a hybrid capacity at the office location.
- This is a paid position.
About Colgate-Palmolive
Colgate-Palmolive is a manufacturer of health, hygiene, and pet nutrition products. Founded in 1806, the company produces items under brands including Colgate, Palmolive, and Hill's Science Diet. It operates globally with headquarters in New York City and a workforce of over 31,000 employees. The company focuses on oral care, personal care, and home care markets.
How to get in at Colgate-Palmolive
Applying to Colgate-Palmolive early is a significant advantage because recruiters often review candidates as they arrive. Intern Insider sends an instant alert the moment a role matching your target is published anywhere, so you apply among the first and get seen before the pile grows. This helps you avoid the frustration of submitting applications that never get opened. You can also improve your response rates by reaching out to the recruiters behind the company's roles directly. Intern Insider surfaces these contacts so you can ask about the role or a referral, which is a much more effective strategy than waiting for a response from a general portal.
