E2E Data Analyst

No Relocation Assistance Offered
# 156816 - Kansas City, 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!
 

E2E Data Analyst

The Customer Service & Logistics E2E Data Analyst is 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. This position is responsible for building and maintaining dashboards and analytical tools as requested within the CS&L organization.  

This key player will streamline through collaboration and analytics where needed and also work off an automated analytic priority list as assigned by leadership. The  E2E Data Analyst must leverage both customer data and internal data to drive growth and efficiencies and support demand and supply synchronization initiatives.
 

Responsibilities:

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

Qualifications:

• Minimum of a Bachelors degree in data analytics, engineering, computer science or related.
• Proficient in SAP, 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.

Expected 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, etc)
• Excellent written and verbal communication skills and interpersonal skills. 
• Ability to learn and work in a changing environment with minimal supervision.
• Strong decision making skills and sound judgment.
• Ability to effectively manage processes and projects.
• Demonstrated analytical, organizational skills and attention to detail.
• Innovation and willingness to drive process improvement and reporting.
• Proficiency with planning systems, Google and Microsoft Office products, to include Excel, Google Sheets, Google presentations, etc.
• Ability to lead data retrieval, transformation, aggregation, and organization in cloud-based systems (Snowflake preferred) and visualization in Sigma, Domo, or other similar tools.
• Ability to write queries in spreadsheet processing programs and SQL.

Compensation and Benefits
Salary Range $70,400.00 - $103,950.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 eli