Data Analyst, Hill's ANZ

Colgate; Sydney; Hybrid; AUD 90,000 - 115,000; Full time

Job summary

Colgate is seeking a Data Analyst for a 12-month contract in Sydney. You will own the BI reporting ecosystem across Tableau and Domo, maintain dashboards and data flows, and partner with data engineers to optimize pipelines supporting commercial decisions.

The role emphasizes data quality, reliable reporting, and actionable insights, with hybrid work in Sydney and a focus on ANZ business needs within Hill's ANZ Customer Development teams.

Qualifications

• Bachelor’s degree in a quantitative field or equivalent practical experience.
• At least 2 years of experience as a Data Engineer or Data Analyst in a cross-functional, business‑facing environment.
• Minimum 2 years of hands‑on experience with Tableau (dashboards and Tableau Prep Builder) and Domo.
• Strong SQL and relational database skills, with practical experience working with Google Cloud Storage, BigQuery, or Snowflake.
• Proficiency in data analysis using Python or R, with the ability to manipulate, transform, and validate data for reporting and analytics purposes.

Responsibilities

• BI & Reporting (Tableau & Domo): Build, update, and optimise dashboards and data flows, and troubleshoot refresh or data quality issues to ensure reporting reliability.
• Data Pipelines & Cloud Infrastructure: Query and prepare data using SQL in Snowflake and BigQuery, manage file ingestion via Google Cloud Storage, and partner with IT/CBS data engineers on pipeline fixes and enhancements.
• Business Partnership & Analytics: Translate commercial stakeholder needs into functional reporting, deliver actionable insights, and promote data accessibility and self-service across teams.
• Reliability & Adoption: Maintain smooth, accurate, and timely dashboard and pipeline operations so that stakeholders trust and actively use reports to make business decisions.
• Continuous Improvement: Proactively improve processes, documentation, and data quality, including contributing to root cause analysis and sustainable fixes for recurring data or reporting issues.
• Support for Key Initiatives: Support significant ANZ commercial projects and business reviews with insight-led reporting and analysis that highlights trends, performance drivers, and opportunities.

Skills

Tableau

Domo

SQL

Python

R

Education

Bachelor's degree in a quantitative field

Tools

Google Cloud Storage

BigQuery

Snowflake

Tableau Prep Builder

Job description

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.

No Relocation Assistance Offered

Job Number#176569 - Sydney, New South Wales, Australia

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.

Title: Data Analyst (12-month - Contract role)

Location: Sydney Office (Hybrid: Minimum 3 days in office, moving to 4 fixed Mon–Thurs)

Role Summary

The Data Analyst (12-month Contract) reports to the Commercial Data Analyst within the Hill’s ANZ Customer Development – ODG/Retail Marketing team and owns the BI reporting ecosystem across Tableau and Domo. The role focuses on maintaining and optimising dashboards and data flows, managing data pipelines into our BI tools, and partnering closely with CBS data engineers on more complex data engineering, modelling, and pipeline design. You will play a key role in elevating our ANZ reporting and insights ecosystem so that stakeholders have reliable, trusted, and actionable reporting that underpins commercial decision-making across the business.

Responsibilities

• BI & Reporting (Tableau & Domo): Build, update, and optimise dashboards and data flows, and troubleshoot refresh or data quality issues to ensure reporting reliability.
• Data Pipelines & Cloud Infrastructure: Query and prepare data using SQL in Snowflake and BigQuery, manage file ingestion via Google Cloud Storage, and partner with IT/CBS data engineers on pipeline fixes and enhancements.
• Business Partnership & Analytics: Translate commercial stakeholder needs into functional reporting, deliver actionable insights, and promote data accessibility and self-service across teams.
• Reliability & Adoption: Maintain smooth, accurate, and timely dashboard and pipeline operations so that stakeholders trust and actively use reports to make business decisions.
• Continuous Improvement: Proactively improve processes, documentation, and data quality, including contributing to root cause analysis and sustainable fixes for recurring data or reporting issues.
• Support for Key Initiatives: Support significant ANZ commercial projects and business reviews with insight-led reporting and analysis that highlights trends, performance drivers, and opportunities.

Required Qualifications

• Bachelor’s degree in a quantitative field such as Computer Science, Statistics, Data Science, Information Systems, or equivalent practical experience.
• At least 2 years of experience as a Data Engineer or Data Analyst in a cross-functional, business‑facing environment.
• Minimum 2 years of hands‑on experience with Tableau (dashboards and Tableau Prep Builder) and Domo.
• Strong SQL and relational database skills, with practical experience working with Google Cloud Storage, BigQuery, or Snowflake.
• Proficiency in data analysis using Python or R, with the ability to manipulate, transform, and validate data for reporting and analytics purposes.

Preferred Qualifications

• Experience with Circana Unity+ or similar syndicated data platforms.
• Experience with broader data engineering concepts (e.g., ETL/ELT, data modelling, data warehousing), ideally on cloud platforms.
• Experience performing root cause analysis on data issues and contributing to process, documentation, and data quality improvements.
• Familiarity with Python and/or R for data manipulation and automation beyond basic analysis.
• Experience harmonising, processing, and extracting value from large, disconnected datasets in a commercial, CPG, FMCG, or retail environment.

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.