Data Analyst, Martech and Digital Strategy

at  ColgatePalmolive

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!
We are excited to invite applications to join the Hill’s Digital Applications group within our Global Information Technology Organization (GIT) as a Data Strategist, Digital Data supporting our Vet & Pet digital experiences. You will join an agile team, helping to drive the build of a variety of high-profile applications using modern tools and infrastructure including Snowflake, Customer Data Platforms, Customer Identity & Access Management, and Marketing Cloud solutions. We are looking for a highly motivated individual to help realize our vision. A successful candidate will be driven to understand business goals and implement high-quality solutions that deliver performance, maintainability and scalability, using leading cloud-based marketing technology to digitally connect. This role will involve planning, business and data analysis, functional and technical design, as well as close partnership and interaction with the Digital Marketing and IT teams to support the deployment of new technology to optimize and expand digital engagement programs leading to better targeting and engagement with our professionals, customers and consumers.
Please note that this role can be based in Piscataway, NJ or Kansas City, Kansas.

REQUIRED QUALIFICATIONS

• Bachelor’s Degree
• At least 3 years of professional experience working in IT/Data Analytics within Digital/Marketing Domain
• Proficient in Python and SQL
• Understanding of Customer Data Platform and experience in enabling activation ready use cases
• Hands-on experience with data integration, data transformation frameworks, tools, and methodologies
• Familiarity with governmental privacy regulations on the collection and use of customer data (such a GDPR and CCPA) and how this impacts customer data management.
• Strong communication, organizational, and multi-tasking skills
• Comfortable navigating ambiguity - in business requirements, technology options and project direction

PREFERRED QUALIFICATIONS

• Bachelor’s Degree Computer Science, Information Technology, Engineering
• 5 years of minimum work experience
• Experience working in a DTC, B2B & B2C business environment
• Knowledge of data management concepts like data modeling and warehousing
• Familiarity with Airflow, DBT and pipeline automation
• Familiarity with Web & Marketing Technologies & APIs
• Experience with Snowflake and/or GCP
• Familiarity with Agile Methodology and SCRUM

• Partner with the Digital and Brand Marketing teams to define use cases for digital marketing data activation, advance first party data collection, integration and accessibility efforts with a strong focus on data driven marketing strategy and technologies
• Develop a comprehensive view and knowledge of our consumer and professional ecosystem and data model including, marketing, commerce and transactional data
• Analyze, produce and develop analytics solutions in order to build new or improve existing Data models and analytics products
• Translate business campaign requirements into technical requirements and build use case specific data products/marts
• Support the build and enhancement of Hill’s Data Model by working closely with cross-functional teams
• Grow the use of CDP and other MarTech in data driven use cases, campaign activation and general adoption through strategy to integrate a broader spectrum of first-party datasets
• Participate in data architecture designs ensuring they align with standard processes and overall management including: data ingestion, processing & validation, transformation and modeling
• Identify, investigate, and resolve data discrepancies by finding the root cause of issues; work with partners across various cross-functional teams to prevent future occurrences