About the role#
The CS&L Data Analyst Co-Op supports the Customer Service and Logistics team by developing and managing data sets for analytical projects. This year-round role runs from August 2026 through May 2027. You will work in a hybrid environment, with a maximum of 29 hours per week while school is in session and up to 40 hours per week during school breaks.
What you'll do#
- Develop and curate data sets from raw data to answer business questions.
- Use SQL to pull and aggregate data, validating results through SAP and other tools.
- Perform data cleaning, merging, and quality control, while maintaining documentation for requests.
- Collaborate with analysts to build data architecture and support cross-functional projects.
- Create reports, analyses, and visualizations for internal teams.
- Train end-users on new dashboards and incorporate their feedback to improve reporting.
- Automate analytical needs and support internal teams with data preparation.
What you'll need#
- Enrollment in a degree program for the duration of the position (August 2026-May 2027).
- Completion of at least 3 upper-level college classes in data analytics, such as data mining, predictive analytics, or data visualization.
- Experience with databases like Snowflake or BigQuery.
- Proficiency in SQL, including the ability to write complex queries for data analysis and quality validation.
- Knowledge of data modeling, data warehousing, and relational or multidimensional databases.
- Proficiency with Google Workspace, Microsoft Office, and planning systems.
- Full US work authorization without the need for visa sponsorship.
Location & details#
- Location: Overland Park, KS.
- Work Modality: Hybrid.
- Duration: August 2026 - May 2027.
- Compensation: $23.00 - $31.00 per hour.
- Travel: Approximately 10% travel required.
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.
