About the role#
As a Data Migration and Analytics Intern, you will work with supply chain, data engineering, and analytics teams. You will help develop and maintain Pet Studio, a central analytics repository. This role involves data modeling, collection, and documentation, as well as front-end visualization and automation projects.
What you'll do#
- Collaborate with teams to define and structure data models.
- Design and implement models using SQL within Snowflake and BigQuery.
- Assist in data collection and transformation using SQL and Google Apps Script.
- Perform data validation, cleansing, and transformation to ensure accuracy.
- Document data processes, models, and transformation workflows.
- Create and maintain interactive dashboards and reports.
- Work with stakeholders to understand their visualization needs and provide end-user support.
- Identify and implement automation opportunities using JavaScript, Snowflake, and Google Apps Script.
- Support the development and maintenance of Pet Studio in DOMO.
- Standardize presentations and workshops regarding Advanced Analytics and AI.
- Take notes during training sessions to help improve future processes.
What you'll need#
- Current enrollment in a degree program for Computer Science, Data Science, Information Systems, Supply Chain Management, or a related field.
- Ability to work 20 hours per week during the academic semester.
- Strong analytical and problem-solving skills.
- Good communication and teamwork abilities.
- Capacity to work independently and manage multiple tasks.
- Basic understanding of data migration concepts and ETL processes.
- Experience with BI tools like SAP Analytics Cloud, Tableau, or Power BI is a plus.
- Proficiency in programming languages such as Python or SQL is preferred.
Location & details#
- This is a paid, part-time internship.
- The role is based in Overland Park, Kansas.
- You must be available to work in a hybrid capacity at the Overland Park office throughout the co-op.
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.
