Customer Service & Logistics Data Analyst Year-Round Intern - Colgate-Palmolive
Overland Park, KS
About the Job
No Relocation Assistance Offered
# 162960 - Overland Park, Kansas, United States
Who We Are
Colgate-Palmolive Company is a caring, innovative growth company that is reimagining a healthier future for all people, their pets and our planet. Focused on Oral Care, Personal Care, Home Care and Pet Nutrition, we sell our products in more than 200 countries and territories under brands such as Colgate, Palmolive, elmex, hello, meridol, Sorriso, Tom’s of Maine, EltaMD, Filorga, Irish Spring, PCA SKIN, Protex, Sanex, Softsoap, Speed Stick, Ajax, Axion, Fabuloso, Soupline and Suavitel, as well as Hill’s Pet Nutrition.
We are recognized for our leadership and innovation in promoting sustainability and community wellbeing, including our achievements in decreasing plastic waste and promoting recyclability, saving water, conserving natural resources and improving children’s oral health.
If you want to work for a company that lives by their values, then give your career a reason to smile and join our global team!
Hill’s Pet Nutrition Inc
JOB TITLE: Customer Service & Logistics (CS&L) Data Analyst Year-round Intern
LOCATION: Hybrid in Overland Park, KS
TRAVEL: None
DURATION: Year-round, typically August-May
SALARY RANGE: $22.50-$30.00/hr
Job Summary
The CS&L (Customer Service & Logistics) Data Analyst Intern 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&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.
The CS&L Data Analyst Intern will collaborate frequently with both experienced analysts and the broader CS&L team to support analytics projects and help build our data architecture. The intern can also provide support as needed to other internal teams for specific projects requiring data preparation and/or analysis. The CS&L Data Analyst Intern must leverage both customer data and internal data to meet synchronization initiatives.
Principal Duties and Responsibilities
%
Task
30%
1. Use SQL to pull and aggregate data for CS&L projects, validating using SAP and other analytical tools as required.
20%
1. Conduct data cleaning, data merging, data architecture review, and data quality control, while creating documentation for each data request.
15%
1. Help develop reports, analyses, and visualizations
15%
1. Train and incorporate feedback from end-users on new reports and dashboards
10%
1. Work with different members of the CS&L team on reporting and automating analytical needs
10%
1. Work cross functionally with different teams on data sets, inputs, and outputs
100
Total Percent (not to exceed 100%)
This is not an exhaustive list of duties or functions.
Education/ Experience Requirements
Basic qualifications include:
+ Minimum 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
+ Experience working in databases like snowflake, Big query, etc.
+ Experience in SQL programming: ability to read/write complex SQL queries to analyze data, investigate systemic defects and validate data quality
+ Working knowledge of data modeling, data warehousing, and ability to access relational and multidimensional databases
Expected Areas of Skills
+ Strong desire to serve the customer, identify and revolve needs and follow up when necessary.
+ Ability to leverage knowledge of numerous data sources (including SAP, external data, and existing internal reports)
+ Excellent written and verbal communication skills and interpersonal skills.
+ Ability to learn and work in a changing environment with minimal supervision.
+ Demonstrated analytical, organizational skills, critical thinking, and attention to detail
+ A strong willingness to learn and adapt to new priorities as they come
+ Familiar with how to access, input and analyze data in SAP
+ Proficiency with planning systems and Google and Microsoft Office products, to include Excel, Google Sheets, Google presentations, etc.
Leadership Competencies (Should match the Colgate Global Competencies)
+ Planning/Priority Setting
+ Teamwork and Collaboration
+ Effective Communication
Functional Competencies (Should match the Colgate Global Competencies)
+ Partnerships and Collaboration
+ Leveraging Systems and Information
Working Relationships (Key partnerships and reporting relationships)
+ Does this position supervise: No
+ Hill’s Customers (DTC customers, HtH, warehouse personnel)
+ Hill’s CS&L Managers (warehousing, global, transportation, demand planning, operations, and field)
Compensation and Benefits
Salary Range $22.50 - $30.00 USD
Pay is based on multiple non-discriminatory, individualized factors including but not limited to experience, job-related knowledge and education, skills and office/market location. In addition to base salary, salaried employees are eligible for annual discretionary bonuses, profit-sharing and, for Executive-level (salary grade 16 and above) roles only, long-term incentives in the form of Restricted Stock Units and/or Stock Options.
Subject to the terms and conditions of the applicable benefits plans then in effect, all salaried employees are also eligible for a competitive benefits package which includes:
+ Insurance: Employees (and their eligible dependents) are eligible to participate in Company-sponsored Medical, Dental, Vision, Basic Life Insurance, Accidental Death & Dismemberment and Disability insurance plans.
+ Retirement Plans: Employees are eligible to enroll in Colgate's 401(k) plan, which provides for company matching contributions subject to eligibility requirements
+ Vacation/PTO: Employees receive a minimum of 15 days of vacation/PTO leave annually
+ Paid Holidays: Employees receive a minimum of 13 paid/floating holidays annually
+ Paid Sick Leave: Based on location and consistent with applicable state and local law, employees receive a minimum of 40 hours of paid sick leave on January 1st of each year
+ Paid Parental Leave: Eligible employees may take up to eight weeks of paid parental leave and 12 weeks of unpaid leave (varies for employees with fewer than 12 months of service and is subject to hours worked requirements)
Our Commitment to Sustainability
With the Colgate brand in more homes than any other, we are presented with great opportunities and new challenges as we work to integrate sustainability into all aspects of our business and create positive social impact. We are determined to position ourselves for further growth as we act on our 2025 Sustainability & Social Impact Strategy.
Our Commitment to Diversity, Equity & Inclusion
Achieving our purpose starts with our people — ensuring our workforce represents the people and communities we serve —and creating an environment where our people feel they belong; where we can be our authentic selves, feel treated with respect and have the support of leadership to impact the business in a meaningful way.
Equal Opportunity Employer
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.
Reasonable accommodation during the application process is available for persons with disabilities. Please contact Application_Accommodation@colpal.com with the subject "Accommodation Request" should you require accommodation.
For additional Colgate terms and conditions, please click here (https://www.colgatepalmolive.com/content/dam/cp-sites/corporate/corporate/en_us/corp/locale-assets/pdf/colgate-terms-and-conditions-2023.pdf) .
#LI-Hybrid
# 162960 - Overland Park, Kansas, United States
Who We Are
Colgate-Palmolive Company is a caring, innovative growth company that is reimagining a healthier future for all people, their pets and our planet. Focused on Oral Care, Personal Care, Home Care and Pet Nutrition, we sell our products in more than 200 countries and territories under brands such as Colgate, Palmolive, elmex, hello, meridol, Sorriso, Tom’s of Maine, EltaMD, Filorga, Irish Spring, PCA SKIN, Protex, Sanex, Softsoap, Speed Stick, Ajax, Axion, Fabuloso, Soupline and Suavitel, as well as Hill’s Pet Nutrition.
We are recognized for our leadership and innovation in promoting sustainability and community wellbeing, including our achievements in decreasing plastic waste and promoting recyclability, saving water, conserving natural resources and improving children’s oral health.
If you want to work for a company that lives by their values, then give your career a reason to smile and join our global team!
Hill’s Pet Nutrition Inc
JOB TITLE: Customer Service & Logistics (CS&L) Data Analyst Year-round Intern
LOCATION: Hybrid in Overland Park, KS
TRAVEL: None
DURATION: Year-round, typically August-May
SALARY RANGE: $22.50-$30.00/hr
Job Summary
The CS&L (Customer Service & Logistics) Data Analyst Intern 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&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.
The CS&L Data Analyst Intern will collaborate frequently with both experienced analysts and the broader CS&L team to support analytics projects and help build our data architecture. The intern can also provide support as needed to other internal teams for specific projects requiring data preparation and/or analysis. The CS&L Data Analyst Intern must leverage both customer data and internal data to meet synchronization initiatives.
Principal Duties and Responsibilities
%
Task
30%
1. Use SQL to pull and aggregate data for CS&L projects, validating using SAP and other analytical tools as required.
20%
1. Conduct data cleaning, data merging, data architecture review, and data quality control, while creating documentation for each data request.
15%
1. Help develop reports, analyses, and visualizations
15%
1. Train and incorporate feedback from end-users on new reports and dashboards
10%
1. Work with different members of the CS&L team on reporting and automating analytical needs
10%
1. Work cross functionally with different teams on data sets, inputs, and outputs
100
Total Percent (not to exceed 100%)
This is not an exhaustive list of duties or functions.
Education/ Experience Requirements
Basic qualifications include:
+ Minimum 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
+ Experience working in databases like snowflake, Big query, etc.
+ Experience in SQL programming: ability to read/write complex SQL queries to analyze data, investigate systemic defects and validate data quality
+ Working knowledge of data modeling, data warehousing, and ability to access relational and multidimensional databases
Expected Areas of Skills
+ Strong desire to serve the customer, identify and revolve needs and follow up when necessary.
+ Ability to leverage knowledge of numerous data sources (including SAP, external data, and existing internal reports)
+ Excellent written and verbal communication skills and interpersonal skills.
+ Ability to learn and work in a changing environment with minimal supervision.
+ Demonstrated analytical, organizational skills, critical thinking, and attention to detail
+ A strong willingness to learn and adapt to new priorities as they come
+ Familiar with how to access, input and analyze data in SAP
+ Proficiency with planning systems and Google and Microsoft Office products, to include Excel, Google Sheets, Google presentations, etc.
Leadership Competencies (Should match the Colgate Global Competencies)
+ Planning/Priority Setting
+ Teamwork and Collaboration
+ Effective Communication
Functional Competencies (Should match the Colgate Global Competencies)
+ Partnerships and Collaboration
+ Leveraging Systems and Information
Working Relationships (Key partnerships and reporting relationships)
+ Does this position supervise: No
+ Hill’s Customers (DTC customers, HtH, warehouse personnel)
+ Hill’s CS&L Managers (warehousing, global, transportation, demand planning, operations, and field)
Compensation and Benefits
Salary Range $22.50 - $30.00 USD
Pay is based on multiple non-discriminatory, individualized factors including but not limited to experience, job-related knowledge and education, skills and office/market location. In addition to base salary, salaried employees are eligible for annual discretionary bonuses, profit-sharing and, for Executive-level (salary grade 16 and above) roles only, long-term incentives in the form of Restricted Stock Units and/or Stock Options.
Subject to the terms and conditions of the applicable benefits plans then in effect, all salaried employees are also eligible for a competitive benefits package which includes:
+ Insurance: Employees (and their eligible dependents) are eligible to participate in Company-sponsored Medical, Dental, Vision, Basic Life Insurance, Accidental Death & Dismemberment and Disability insurance plans.
+ Retirement Plans: Employees are eligible to enroll in Colgate's 401(k) plan, which provides for company matching contributions subject to eligibility requirements
+ Vacation/PTO: Employees receive a minimum of 15 days of vacation/PTO leave annually
+ Paid Holidays: Employees receive a minimum of 13 paid/floating holidays annually
+ Paid Sick Leave: Based on location and consistent with applicable state and local law, employees receive a minimum of 40 hours of paid sick leave on January 1st of each year
+ Paid Parental Leave: Eligible employees may take up to eight weeks of paid parental leave and 12 weeks of unpaid leave (varies for employees with fewer than 12 months of service and is subject to hours worked requirements)
Our Commitment to Sustainability
With the Colgate brand in more homes than any other, we are presented with great opportunities and new challenges as we work to integrate sustainability into all aspects of our business and create positive social impact. We are determined to position ourselves for further growth as we act on our 2025 Sustainability & Social Impact Strategy.
Our Commitment to Diversity, Equity & Inclusion
Achieving our purpose starts with our people — ensuring our workforce represents the people and communities we serve —and creating an environment where our people feel they belong; where we can be our authentic selves, feel treated with respect and have the support of leadership to impact the business in a meaningful way.
Equal Opportunity Employer
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.
Reasonable accommodation during the application process is available for persons with disabilities. Please contact Application_Accommodation@colpal.com with the subject "Accommodation Request" should you require accommodation.
For additional Colgate terms and conditions, please click here (https://www.colgatepalmolive.com/content/dam/cp-sites/corporate/corporate/en_us/corp/locale-assets/pdf/colgate-terms-and-conditions-2023.pdf) .
#LI-Hybrid
Source : Colgate-Palmolive
