Hybrid CS&L Data Analyst Co‑Op – Travel

Colgate; Overland Park (KS); On-site; USD 32,000 - 43,000; Part time

Benefits offered by this job

Medical benefits

Parental leave

401(k) matching

Paid holidays

Job summary

Colgate in Overland Park, KS, seeks a CS&L Data Analyst Co‑Op for Aug 2026–May 2027. The role focuses on developing and managing data sets for analytical projects within a hybrid work model, with limited weekly hours during school terms and full-time during breaks.

You will pull and clean data using SQL, help create reports and dashboards, and collaborate with experienced analysts to advance data architecture and insights.

Qualifications

• Completed at least 3 upper level college classes in data analytics (data analysis, forecasting, data mining, visualization)
• Experience with databases like Snowflake or BigQuery
• Ability to read/write complex SQL queries to analyze data and validate quality
• Knowledge of data modeling, warehousing, relational/multi-dimensional databases

Responsibilities

• Use SQL to pull and aggregate data for CS&L projects and validate with SAP
• Perform data cleaning, merging, architecture review, and documentation of data requests
• Help develop reports, analyses, and visualizations
• Train end-users on new reports and dashboards and incorporate feedback
• Collaborate with CS&L team on reporting and automation of analytics
• Coordinate with cross-functional teams on data sets and outputs

Skills

SQL

Data analysis

Data visualization

Relational databases

Education

3+ upper level data analytics courses

Enrolled student pursuing degree Aug 2026–May 2027

Tools

Snowflake

BigQuery

SAP

Excel

Job description

Colgate in Overland Park, KS, seeks a CS&L Data Analyst Co‑Op for Aug 2026–May 2027. The role focuses on developing and managing data sets for analytical projects within a hybrid work model, with limited weekly hours during school terms and full-time during breaks.

You will pull and clean data using SQL, help create reports and dashboards, and collaborate with experienced analysts to advance data architecture and insights.