E2E Data Analyst

Colgate • Overland Park, KS

6d • Hybrid

About The Position

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.

Requirements

• 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

Nice To Haves

• 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.

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

Benefits

• medical
• dental
• vision
• basic life insurance
• paid parental leave
• disability coverage
• participation in the 401(k) retirement plan with company matching contributions subject to eligibility requirements.
• a minimum of 15 vacation/PTO days
• 13 paid holidays
• Paid sick leave is adjusted based on role and location in accordance with local laws.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level