Hill’s is seeking an experienced CRM Data Analyst to join our cross-functional digital marketing and engagement team. You will be supporting high volume CRM marketing campaigns, as well as other data platforms for our US business while coordinating with team members around the globe. Your focus will be to manage consumer data integration lifecycles, define schemas/ingestion layouts, conduct routine audits to maintain flow continuity, and analyze/report the performance of acquisition touchpoints. Work could include PII across B2B, B2B2C and DtC applications. 

Principal Duties and Responsibilities
Data Validation (70%)

• Develop, review and optimize validation procedures and protocols.
• Define schemas for all new sources while adhering to governance guidelines and best practices.  
• Validate data as business owner and ensure accuracy across all sources. 
• Automate and improve timeliness & cleanliness of data flow with vendors and IT.
• Track and monitor data ingestion issues and work with sources/vendors/IT on solutions. 

Insights & Analytics (20%)

• Conduct routine analysis and report on performance of acquisition sources. 
• Identify opportunities to capture more data either explicitly, inferrably, or through assigning new metadata to acquisition sources.
• Work with IT on modeling of data for performance dashboard visualizations. 

Operational Execution (10%)

• Create standard operating procedures for CRM data validation. 
• Clean manual data extracts and apply proper schemas before ingestion. 
• Codify/document data mapping and table relationships within query environments.

This is not an exhaustive list of duties or functions.
 

Basic Requirements

• Bachelor’s Degree in marketing, data, analytics, IT or related field
•  3+ years of experience

Preferred Requirements:

• Master's of Business Administration (MBA)

Expected Areas of Skills/Knowledge/Abilities

• Highly comfortable with raw and unstructured data sources
• Previous experience in creating data schemas
• Previous experience with Salesforce Marketing Cloud, Interaction Studio, Google Cloud, Big Query, LiveRamp and other identity resolution solutions
• Strong technical writing skills and ability to document all work in a meticulous and accurate manner
• Vendor relationship management experience
• Ability to work independently and with little supervision
• Proven ability to retrieve information from a variety of sources using a variety of approaches and tools.
• Strong analytical skills including data analysis, modeling, and mining.
• Strong critical thinking and problem-solving skills; proven ability to develop and initiate creative innovations and solutions.
• Must be a team-oriented individual who can share information, goals, opportunities, successes, and failures with the appropriate parties. Ability to organize, plan, and carry out multiple related activities.
   

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

Are you interested in working for Hill's Pet Nutrition? You can apply online and attach all relevant documents such as a cover letter and resume or CV. Applications received by e-mail are not considered in the selection process. Become part of our team. We look forward to your application.

Work that matters, fueled by passion for pets!  At Hill’s we have a purpose.  Every day around the world, we transform the lives of millions of pet families through pioneering innovation, amazing nutrition, and the best and brightest people. Founded more than 75 years ago with an unwavering commitment to pet nutrition, Hills' mission is to help enrich and lengthen the special relationships between people and their pets. 

HILL'S® Prescription Diet® therapeutic pet foods, HILL'S® Science Diet® and HILL'S® Ideal Balanceâ„¢ wellness pet foods are sold worldwide. Hill’s is a division of Colgate-Palmolive, a leading global consumer products company, tightly focused on Oral Care, Personal Care, Home Care and Pet Nutrition, with sales of products in more than 200 countries.  To learn more about Hill's and Colgate, please visit http://www.hillspet.com and http://www.colgatepalmolive.com, or find us on LinkedIn, Facebook, Twitter and YouTube.

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.