E2E Data Analyst

Colgate-Palmolive

Overland Park, KS

JOB DETAILS
SALARY
$76,800–$107,500 Per Year
SKILLS
Analysis Skills, Animal Care, Animal Nutrition, Cloud Computing, Commissioning, Communication Skills, Computer Science, Corporate Policies, Cross-Functional, Customer Relations, Customer Support/Service, Customer/Client Research, DOMO, Data Analysis, Data Entry, Data Management, Data Mining, Data Modeling, Data Quality, Data Recovery, Data Sets, Data Storage, Data Structures, Data Warehousing, Diversity, ERP (Enterprise Resource Planning), Food Science, Home Care, Identify Issues, Interpersonal Skills, Leadership, Microsoft Excel, Nutrition, Personal Care, Project/Program Management, Quality Assurance, Query Analysis, Relational Databases (RDBMS), Reporting Dashboards, Reporting Skills, SAP, SQL (Structured Query Language), Scientific Research, Skin Care, Snowflake Schema, Supply Chain, Talent Management, User Documentation, Veterinary Medicine
LOCATION
Overland Park, KS
POSTED
Today
No Relocation Assistance Offered

Job Number #173331 - Overland Park, Kansas, United States


Who We Are


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!


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.


At Hill’s we have a purpose to transform the lives of millions of pet families through pioneering innovation, science-led nutrition, and the best and brightest people. If you’re interested in work that matters, fueled by passion for pets, we invite you to apply.


Founded more than 75 years ago with an unwavering commitment to pet nutrition, Hill’s mission is to help enrich and lengthen the special relationships between people and their pets. Our decades of science and research guide us in creating nutrition that’s a step ahead so pets and pet parents can enjoy every day together. As the US #1 Veterinarian recommended pet food brand, knowledge is our first ingredient with 220+ veterinarians, PhD nutritionists and food scientists working to develop breakthrough innovations in pet health.


Are you passionate about turning complex data into actionable insights that drive global supply chain efficiency? As a Customer Service & Logistcs E2E Data Analyst you will be responsible for managing data sets, developing reports, and troubleshooting data issues. This includes a fine eye to detail and a deep understanding of the most up to date data analysis tools and databases. You will build and maintain dashboards and analytical tools, you will streamline through collaboration and analytics where needed and also work off an automated analytic priority list as assigned by leadership. You must leverage both customer data and internal data to drive growth and efficiencies and support demand and supply synchronization initiatives.


Responsibilities:


+ Managing master data, including creation, updates, and deletion

+ Provide quality assurance of imported data, working with quality assurance analysts if necessary.

+ Commissioning and decommissioning of data sets.

+ Helping develop reports and analysis

+ Supporting initiatives for data integrity and normalization

+ Troubleshooting the reporting database environment and reports.

+ Training end-users on new reports and dashboards

+ Providing technical expertise in data storage structures, data mining, and data cleansing

+ Work with different members of the CS&L team on reporting and automating analytical needs

+ Work cross functionally with different teams on data sets, inputs and outputs


Required Qualifications:


+ Bachelor’s degree in Data Analytics, Engineering, Computer Science, or a related field.

+ Proficient in SAP or any other similar ERP, Microsoft Excel, Google Sheets, email

+ 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


Preferred Qualifications


+ Ability to lead data retrieval, transformation, aggregation, and organization in cloud-based systems (Snowflake preferred) and visualization in Sigma, Domo, or other similar tools

+ Growth mindset with a demonstrated ability to learn and adapt to changing environments with minimal supervision.

+ Strong interpersonal and communication skills, with a focus on serving the customer and facilitating progress.

+ Data-driven decision-making skills and the ability to manage complex projects from inception to completion.


Compensation and Benefits

Salary Range $76,800.00 - $107,500.00 USD


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.


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.


Our Commitment to Inclusion

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.


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 complete this request form (https://docs.google.com/forms/d/e/1FAIpQLSdaxk_eF4utznQoVHlxmL9jVFJbOkM4Oe5CAdKOg-h9EPdLfg/viewform) 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

About the Company

C

Colgate-Palmolive

The small soap and candle business that William Colgate began in New York City early in the 19th century is now, more than 200 years later, a truly global company serving hundreds of millions of consumers worldwide. Throughout this history, Colgate people and Colgate values have been at the heart of our success. Today, Colgate focuses on four core businesses Oral Care, Personal Care, Home Care and Pet Nutrition. Colgate now sells its products in over 200 countries and territories worldwide.
COMPANY SIZE
10,000 employees or more
INDUSTRY
Consumer Packaged Goods Manufacturing
WEBSITE
https://www.colgatepalmolive.com/en-us