Data Analyst, Hill'S Anz (Sydney, Nsw, Au)

Colgate-Palmolive; Sydney; Híbrido; AUD 90.000 - 130.000; Jornada completa

Descripción de la vacante

Colgate-Palmolive is seeking a Data Analyst on a 12-month contract in Sydney. The role reports to the Commercial Data Analyst within the Hill's ANZ Customer Development team and owns the BI reporting ecosystem across Tableau and Domo.

You will maintain dashboards, data flows, and data pipelines to support commercial decision‑making. You will partner with CBS data engineers on more complex data engineering, modelling, and pipeline design, drive data accessibility, and help elevate ANZ reporting

Formación

• Bachelor’s degree in a quantitative field or equivalent practical experience.
• 2+ years’ experience as a Data Engineer or Data Analyst in a cross‑functional environment.
• Hands‑on experience with Tableau and Domo required.
• Strong SQL skills and familiarity with cloud data stores (GCS / BigQuery / Snowflake).

Responsabilidades

• BI & Reporting: Build, update, and optimise dashboards and data flows in Tableau and Domo.
• Data Pipelines: Use SQL to query data in Snowflake and BigQuery; manage file ingestion.
• Analytics: Translate stakeholder needs into actionable reporting and insights.
• Reliability: Ensure dashboards and pipelines run smoothly and are trusted by stakeholders.
• Continuous improvement: Improve processes, data quality, and documentation.
• Support initiatives: Deliver insight-led reporting for ANZ commercial projects.

Conocimientos

SQL

Python

R

Data analysis

Educación

Bachelor’s degree in quantitative field

Herramientas

Tableau

Domo

BigQuery

Snowflake

Descripción del empleo

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