Share this Job

Site upgrade in progress. You will not be able to apply at this time. Please be patient and check back with us later.

A part of Colgate-Palmolive since 1976, Hill's Pet Nutrition offers the highest-quality pet nutrition available through product lines Prescription Diet® and Science Diet®. Veterinarians worldwide recommend and feed their own pets Hill's products more than any other brand of pet food.

Available in approximately 80 countries around the world, our extensive line of products includes more than 60 Prescription Diet brand pet foods and more than 50 Science Diet brand pet foods.

We believe all animals should be loved and cared for during their lifetimes. That is why we are proud our pet foods can make a difference in your pet's life.

A career at Hill’s Pet Nutrition or Colgate-Palmolive is an excellent opportunity if you seek a global experience, constant challenge, and development opportunities in an environment that respects work/life effectiveness.

Job Title:  Commercial Data Analyst

Travel Required?:  Travel - up to 10% of time
Date:  Jan 26, 2023
Hybrid

Relocation Assistance Offered Within Country
# 147700 - Sydney, New South Wales, Australia

 

About Hill’s

We are Hill’s - an innovative growth company reimagining a healthier future for all people, their pets, and our planet. We are part of Colgate-Palmolive a leading global consumer products company with a portfolio in Oral Care, Personal Care, Home Care and Pet Nutrition.

At Hill's we have a purpose! Every day around the world, we transform the lives of millions of pets through groundbreaking innovation, outstanding nutrition, and committed people.

Our strong culture of diversity, sustainability and inclusion is rooted in our core values of Caring, Global Collaboration and Continuous Improvement. Employees are rewarded by rich career development and experiences.

We pride ourselves on our work life balance, our focus on delivering high ethical standards and our dedication to developing our employees. With many local benefits such as Summer Hours, Live Better activities, Product Parcels and Health Checks.

 

We're looking for an experienced data and analytics professional to join our AU Analytics team.

The ideal candidate will support Hill’s Pet Nutrition AU by developing and  automating data transformation pipelines integrating data sources from various parts of the  business to drive customer understanding and operational efficiency.

As a Commercial Data Analyst, you will collaborate with departments across the  company, including, global data and analytics teams, local Finance, Marketing & Sales teams.  In addition to building data transformation pipelines, your responsibilities will include developing and updating existing dashboards for business use using tableau and transforming data using tableau prep builder. You will also be responsible for identifying  and solving process automation opportunities.

 

The ideal candidate:

  • You are an expert in wrangling and managing raw data and combining data from different sources using tableau and tableau prep builder 
  • You have an eye for detail, you are a champion for data quality, transparency, and documentation 
  • You are able to clearly and dynamically translate information into impactful insights to  technical and non-technical audiences 
  • You have curiosity to take ambiguous problems and tackle them to achieve hypothesis driven results 
  • You have the ability to balance multiple projects at once and deliver projects  independently 
  • Experienced in process automation to simplify business processes
  • You are a collaborator by nature

 

Key Responsibilities:

1.Cleaning, Collating and running Tableau workflows /Dashboards (Monthly cadence)

  • Translate business requirements and logic into well-documented data models (dashboards)  to drive  clarity and efficiency for end users  

Specifically: 

  • Compile data from wholesalers, update and maintain ex-wholesalers data mapping files, run tableau flows and update / publish relevant tableau dashboards
  • Compile data from retailers, run the tableau flows and update / publish dashboards
  • Collate data release forms and request missing data from Wholesalers and Customers

2.Pro active  data reporting and Insight generation

  • Collaborate cross functionally to understand and identify data needs and opportunities to  use data to drive business solutions 
  • Provide Analytical support for the commercial team  develop ad hoc tableau/Domo reports using sales data
  • Support commercial team identifying business questions and generating insights from our sales data 

3.Project based analytics support

  • Support Global Data and Analytics with snowflake data ingestion and translation for the AU region
  • Transition all monthly reporting across to Domo and lead local upskilling
  • Partner with Global data and analytics teams on regional analytics initiatives eg providing inputs for MMM, Pricing analysis, customer lifetime value etc.
  •  Partner with Global data and analytics teams  to align on data architecture, analytics tools, and other technologies for our region
  • Stay connected with Global  data and analytics teams  to share best practices

 

Required Qualifications:

  • Bachelor’s degree in business or a quantitative field
  • Expert in using data visualization and/or BI tools (e.g. Domo, Tableau, Tableau Prep, Excel) to  analyse data 
  • Demonstrated proficiency in the use of SQL and/or Python to wrangle, clean, and  integrate data from a variety of sources highly regarded
  • Demonstrated understanding of modern data warehouse design principles and data

 

Preferred Qualifications:

  • Demonstrated understanding of marketing analytics concepts, including marketing mix ∙ modeling, churn risk prediction, and customer lifetime value 
  •  Familiarity with SAP systems (ECC, C4C)

 


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.


Job Segment: Database, Data Analyst, Data Architect, Data Warehouse, Warehouse, Technology, Data, Manufacturing