Job Description

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.

#LI-VP5

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.

#LI-Hybrid