Synchronization Planning Co-Op: Data Analytics & Automation

Colgate; Overland Park (KS); Hybrid; USD 25,000 - 33,000; Full time

Benefits offered by this job

401(k) with company matching

Medical/dental/vision benefits

Paid time off

Paid holidays

Job summary

Colgate-Palmolive invites a university student to join as Synchronization Planning Co-Op in Overland Park, KS, supporting end-to-end planning with analytics, data engineering, and automation. You will partner with planning teams to optimize processes, build automated presentations, govern master data, and run predictive analytics projects on a year‑round schedule.

The role emphasizes cross-functional collaboration across Global Supply Chain, Finance, and regional teams, with exposure to

Qualifications

• Currently enrolled in a Bachelor’s or Master’s degree program in Supply Chain Management, Data Analytics, Industrial Engineering, Computer Science, Information Systems, or a related field.
• Ability to commit to a year-round Co-Op schedule.
• Intermediate to advanced proficiency in writing SQL queries.
• Foundational experience or strong proficiency in Python and Google Apps Script.
• Strong communication skills and ability to collaborate effectively in teams.

Responsibilities

• Automation & Optimization: Build, automate, and maintain planning workflows using Google Apps Script, SQL in Snowflake, and Python.
• Analytics & Visualization: Design and maintain dashboards in Sigma and DOMO to track E2E planning metrics.
• AI Solutions & Workflows: Explore AI assistants and automation using Google Workspace tools to streamline tasks.
• E2E Planning Projects: Lead process improvement projects, including fill rate analysis and projections.
• Meeting & Presentation Automation: Prepare content and automate slide generation for synchronization meetings.
• Master Data Governance: Conduct monthly/quarterly data audits in SAP and Kinaxis and suggest data quality fixes.
• Documentation & Standards: Update End-to-End SOPs and process docs.
• Cross-Functional Collaboration: Partner with Global Supply Chain, CS&L, Logistics, Finance, and regional teams.

Skills

SQL

Python

Google Apps Script

Data analytics

Education

Bachelor’s or Master’s in Supply Chain Management, Data Analytics, Industrial Engineering, CS, Information Systems

Tools

Sigma

DOMO

Google Workspace

SAP / Kinaxis

Job description

Colgate-Palmolive invites a university student to join as Synchronization Planning Co-Op in Overland Park, KS, supporting end-to-end planning with analytics, data engineering, and automation. You will partner with planning teams to optimize processes, build automated presentations, govern master data, and run predictive analytics projects on a year‑round schedule.

The role emphasizes cross-functional collaboration across Global Supply Chain, Finance, and regional teams, with exposure to