Synchronization Planning Co-Op: Data Analytics & Automation

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

Benefits offered by this job

Hybrid schedule

Travel - up to 10%

Job summary

Colgate-Palmolive’s Hill's Pet Nutrition division seeks a Synchronization Planning Co-Op to support end-to-end supply and demand synchronization. Youll leverage analytics, data engineering, and automation to optimize planning and drive visibility. This role targets university students for year-round work, including summers.

Youll build automation, dashboards in Sigma/DOMO, and AI-powered workflows while collaborating with planning teams to deliver improvements and governance across master data.

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 for data manipulation/optimization and Google Apps Script for task automation.

Responsibilities

• Automation & Optimization: Build, automate, and maintain planning workflows and optimization solutions using Google Apps Script, SQL queries in Snowflake, and Python.
• Analytics & Visualization: Design, build, and maintain interactive BI dashboards in Sigma and DOMO to track E2E planning metrics and trends.
• AI Solutions & Workflows: Explore and implement AI assistants and automation solutions using Google Workspace tools.
• 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 and recommend data quality corrections in SAP and Kinaxis.
• Documentation & Standards: Organize and standardize End-to-End process docs and SOPs.
• Cross-Functional Collaboration: Partner with Global Supply Chain, CS&L, Logistics, Finance and regional teams.

Skills

SQL

Python

Google Apps Script

Team collaboration

Education

Bachelor’s or Master’s degree in a relevant field

Tools

Sigma

DOMO

Google Workspace

Snowflake

SAP S/4HANA

Job description

Colgate-Palmolive’s Hill's Pet Nutrition division seeks a Synchronization Planning Co-Op to support end-to-end supply and demand synchronization. Youll leverage analytics, data engineering, and automation to optimize planning and drive visibility. This role targets university students for year-round work, including summers.

Youll build automation, dashboards in Sigma/DOMO, and AI-powered workflows while collaborating with planning teams to deliver improvements and governance across master data.