Business Analyst Sql R Python Jobs in Shawnee, KS

No Relocation Assistance Offered
Job Number #173142 - 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.
 

Work visa sponsorship is not available for this position.  Accordingly, all applicants must be currently authorized to work in the U.S. on a full-time basis and must not require the Company's sponsorship to continue to work legally in the United States.

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.

We are seeking a highly analytical and detail-oriented Business Analytics Manager – Vet to support strategic decision-making by translating and analysing data into actionable business insights. This role is responsible for driving meaningful outputs that drive category growth, pricing optimization, and overall business performance.

This individual will partner closely with Marketing and Customer Development teams to “connect the dots” across multiple datasets and uncover opportunities to accelerate Hill’s growth, share, and profitability across online channels.

Responsibilities:

• Translate complex vet datasets into clear business insights, with a focus on:

  • Driving category growth and performance

  • Grow market share and penetration

  • Leverage RGM

  • 7P implementation and tracking, including pricing, distribution, promotional effectiveness

  • Traffic, conversion, and basket-level behavior

• Analyze and synthesize data from multiple sources (clean rooms, syndicated data, retailer platforms, internal systems) to identify trends that drive vet growth and profitability

• Develop and maintain standardized dashboards and reporting to track KPIs such as conversion rate, average order value, share of search, and digital shelf performance

• Partner with cross-functional teams to translate insights into vet strategies that improve sales, share, and ROI

• Lead analysis, visualization, and storytelling

• Provide ad hoc analysis to support key business questions related to online performance

Required Qualifications:

• Bachelor’s degree in Analytics, Business, Data Science, Marketing, or related field

• 5+ years of experience in data analytics, with a strong focus on vet, digital analytics, or clean room environments

• Experience working with clean room environments or retail media data platforms

• Experience with data providers (e.g., Nielsen, Numerator, Profitero, Rakuten, Similarweb, etc.)

• Proficiency in data visualization and storytelling (e.g., Domo, Tableau, Power BI)

Preferred qualifications: 

• Proficiency in SQL, Python, or R for data extraction and manipulation

• Experience in CPG (Consumer Packaged Goods) industry

• Strong understanding of vet KPIs (conversion, traffic, AOV, ROAS, etc.)

• Proven ability to analyze vet category data, growth trends, and pricing dynamics

• Strong analytical thinking with the ability to translate complex data into business-driving insights

• Demonstrated ability to manage multiple projects and influence cross-functional stakeholders

• Experience building automated dashboards and scalable reporting solutions

• Strong understanding of digital commerce performance drivers, including assortment, content, pricing, and media

• Hands-on experience with vet clean room platforms

Compensation and Benefits
Salary Range $109,600.00 - $155,000.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 should you require accommodation.
For additional Colgate terms and conditions, please click here.
#LI-Hybrid