CS&L Data Analyst Co-Op (August 2026-May 2027) (Overland Park, KS, US)

<style type="text/css"> </style> <style type="text/css"> </style> <p><span style="font-family:Arial, Helvetica, sans-serif">No Relocation Assistance Offered<br>Job Number #173442 - Overland Park, Kansas, United States<br><br><strong>Who We Are</strong><br><br>Colgate-Palmolive Company is a global consumer products company operating in over 200 countries specializing in Oral Care, Personal Care, Home Care, Skin Care, and Pet Nutrition. Our products are trusted in more households than any other brand in the world, making us a household name!<br><br>Join Colgate-Palmolive, a caring, innovative growth company reimagining a healthier future for people, their pets, and our planet. Guided by our core values—Caring, Inclusive, and Courageous—we foster a culture that inspires our people to achieve common goals. Together, let's build a brighter, healthier future for all.</span><br> </p><p style="line-height:1.2;background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c">Hill’s Pet Nutrition Inc</span><span style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c"><br></span><span style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c">JOB TITLE: CS&amp;L Data Analyst Co-Op</span><span style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c"><br></span><span style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c">LOCATION: Hybrid in Overland Park, KS </span></p> <p style="line-height:1.2;background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c">RELOCATION STIPEND: One time $2,500 if &gt;50 miles away from office</span></p> <p style="line-height:1.2;background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c">TRAVEL: Some travel (10%)</span></p> <p style="line-height:1.2;background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c">DURATION: August 2026 - May 2027</span></p> <p style="line-height:1.2;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c">SALARY RANGE: $23.00-$31.00/hr</span></p> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"> </p> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><strong><span style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c">Job Summary</span></strong></p> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"> </p> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c">The CS&amp;L (Customer Service &amp; Logistics) Data Analyst Co-Op is responsible for developing and managing data sets for analytical projects. This type of work requires attention to detail, an understanding of the most up to date data analysis tools, problem-solving skills, and an analytical mindset. This position will support the CS&amp;L team and current analysts with data requests, creation of curated data sets from existing raw data, and use of analytical tools to answer business questions and provide visibility to data.</span></p> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c"> </span></p> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c">This position is a year-round Co-Op role which will require availability to work from August 2026 with no more than 29 hours per week in our hybrid work environment while school is in session and no more than 40 hours per week while on school breaks, if desired, through May 2027.</span></p> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c"><br></span><span style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c">The CS&amp;L Data Analyst co-op will collaborate frequently with both experienced analysts and the broader CS&amp;L team to support analytics projects and help build our data architecture. The co-op can also provide support as needed to other internal teams for specific projects requiring data preparation and/or analysis. The CS&amp;L Data Analyst co-op must leverage both customer data and internal data to meet synchronization initiatives.</span></p> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c"> </span></p> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><strong><span style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c">Tasks:</span></strong></p> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"> </p> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c">1. Use SQL to pull and aggregate data for CS&amp;L projects, validating using SAP and other analytical tools as required.</span></p> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c">2. Conduct data cleaning, data merging, data architecture review, and data quality control, while creating documentation for each data request.</span></p> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c">3. Help develop reports, analyses, and visualizations</span></p> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c">4. Train and incorporate feedback from end-users on new reports and dashboards</span></p> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c">5. Work with different members of the CS&amp;L team on reporting and automating analytical needs</span></p> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c">6. Work cross functionally with different teams on data sets, inputs, and outputs</span></p> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"> </p> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c">This is not an exhaustive list of duties or functions.</span></p> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c"> </span></p> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><strong><span style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c">Education/ Experience Requirements:</span></strong></p> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"> </p> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c">Basic qualifications include:</span></p> <ul style="margin-top:0.0px;margin-bottom:0.0px"> <li style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c"> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-size:10.5pt">Have completed a minimum of 3 upper level college classes in data analytics including - data analysis and forecasting, data mining and predictive analytics, system analysis and design and data visualization in business, or similarly related classes</span></p> </li> <li style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c"> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-size:10.5pt">Experience working in databases like snowflake, Big query, etc</span></p> </li> <li style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c"> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-size:10.5pt">Experience in SQL programming: ability to read/write complex SQL queries to analyze data, investigate systemic defects and validate data quality</span></p> </li> <li style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c"> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-size:10.5pt">Working knowledge of data modeling, data warehousing, and ability to access relational and</span><span style="font-size:10.5pt"><br></span><span style="font-size:10.5pt">multidimensional databases</span></p> </li> <li style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c"> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-size:10.5pt">Be an enrolled student pursuing a degree for the duration of this position from August 2026-May 2027</span></p> </li> <li style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c"> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-size:10.5pt">Have full US work authorization without need for visa sponsorship now or in the future, including H1-B/F-1/OPT/CPT, etc</span></p> </li> </ul> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c"> </span></p> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><strong><span style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c">Expected Areas of Skills</span></strong></p> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"> </p> <ul style="margin-top:0.0px;margin-bottom:0.0px"> <li style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c"> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-size:10.5pt">Strong desire to serve the customer, identify and revolve needs and follow up when necessary. </span></p> </li> <li style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c"> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-size:10.5pt">Ability to leverage knowledge of numerous data sources (including SAP, external data, and existing internal reports)</span></p> </li> <li style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c"> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-size:10.5pt">Excellent written and verbal communication skills and interpersonal skills.</span></p> </li> <li style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c"> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-size:10.5pt">Ability to learn and work in a changing environment with minimal supervision.</span></p> </li> <li style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c"> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-size:10.5pt">Demonstrated analytical, organizational skills, critical thinking, and attention to detail</span></p> </li> <li style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c"> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-size:10.5pt">A strong willingness to learn and adapt to new priorities as they come</span></p> </li> <li style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c"> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-size:10.5pt">Familiar with how to access, input and analyze data in SAP</span></p> </li> <li style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c"> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-size:10.5pt">Proficiency with planning systems and Google and Microsoft Office products, to include Excel, Google Sheets, Google presentations, etc.</span></p> </li> </ul> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"><span style="font-size:10.5pt;font-family:Arial, sans-serif;color:#0d0c0c"> </span></p> <p style="background-color:#ffffff;margin-top:0.0pt;margin-bottom:0.0pt"> </p><style type="text/css"> </style> <style type="text/css"> </style> <p><br><span style="font-family:Arial, Helvetica, sans-serif"><strong>Compensation and Benefits</strong><br>Salary Range $23.00 - $31.00 USD<br><br>Pay is determined based on experience, qualifications, and location. Salaried employees may also be eligible for discretionary bonuses, profit-sharing, and long-term incentives for Executive-level roles.<br><br>Benefits: Salaried employees enjoy a comprehensive benefits package, including medical, dental, vision, basic life insurance, paid parental leave, disability coverage, and participation in the 401(k) retirement plan with company matching contributions subject to eligibility requirements. Additional benefits include a minimum of 15 vacation/PTO days (hourly employees receive a minimum of 120 hours) and 13 paid holidays (vacation days are prorated based on the employee's hire date within the calendar year). Paid sick leave is adjusted based on role and location in accordance with local laws. Detailed information regarding paid sick leave entitlements will be provided to employees upon hiring and may be subject to adjustments based on changes in legislation or company policies.<br><br><strong>Our Commitment to Inclusion</strong><br>Our journey begins with our people—developing strong talent with diverse backgrounds and perspectives  to best serve our consumers around the world and fostering an inclusive environment where everyone feels a true sense of belonging. We are dedicated to ensuring that each individual can be their authentic self, is treated with respect, and is empowered by leadership to contribute meaningfully to our business.<br><br><strong>Equal Opportunity Employer</strong><br>Colgate is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity, sexual orientation, national origin, ethnicity, age, disability, marital status, veteran status (United States positions), or any other characteristic protected by law.<br><br>Reasonable accommodation during the application process is available for persons with disabilities. Please complete this <a href="https://docs.google.com/forms/d/e/1FAIpQLSdaxk_eF4utznQoVHlxmL9jVFJbOkM4Oe5CAdKOg-h9EPdLfg/viewform" target="_blank" rel="noopener">request form</a> should you require accommodation.<br><br>For additional Colgate terms and conditions, please click <a href="https://www.colgatepalmolive.com/content/dam/cp-sites/corporate/corporate/en_us/corp/locale-assets/pdf/colgate-terms-and-conditions-2023.pdf" target="_blank" rel="noopener">here</a>.<br><br>#LI-Hybrid</span></p>