Digital & Analytics Specialist

Colgate; Sydney; Hybrid; AUD 110,000 - 130,000; Full time

Job summary

Colgate-Palmolive in Australia is seeking a Digital & Analytics Specialist for a 12-month contract in Sydney. You will design ETL processes, build dashboards in Domo and Sigma, and drive data-driven improvements across supply chain analytics.

You will develop predictive analytics, train end-users on new reports, and collaborate with CS&L teams to deliver actionable insights for management. This role requires a strong data background and hands-on SQL and BI tooling experience.

Qualifications

• Minimum of a Bachelor's degree in data analytics, engineering, computer science or related.
• Experience working in databases like Snowflake, BigQuery, etc.
• Experience in SQL programming: ability to read/write complex SQL queries to analyze data, investigate defects and validate data quality.
• Working knowledge of data modeling, data warehousing, and ability to access relational and multidimensional databases.
• Ability to develop AI tools that help with user queries or automate tasks.
• Ability to learn and work in a changing environment with minimal supervision.
• Strong decision making skills and sound judgment.
• Innovation and willingness to drive process improvement and reporting.

Responsibilities

• Design and implement ETL processes, create dashboards, and optimize efficiency through evaluations.
• Develop and manage ETL processes and pipelines for Colgate-Palmolive approved platforms.
• Build and maintain actionable Domo and Sigma dashboards.
• Monitor process efficiency and recommend adjustments when necessary.
• Conduct training sessions to enhance broader team proficiency with reporting tools.
• Provide quality assurance of imported data, working with QA analysts if necessary.
• Commissioning and decommissioning of data sets.
• Training end-users on new reports, dashboards and AI tools.
• Providing technical expertise in data storage structures, data mining, and data cleansing.
• Work with CS&L team on reporting and automating analytical needs.

Skills

SQL programming

ETL design

Domo

Sigma

Snowflake

BigQuery

Data modeling

AI tools

Data warehousing

Cloud data warehouse

Education

Bachelor's degree in data analytics, engineering, CS or related

Tools

Snowflake

BigQuery

Domo

Sigma

SAP S/4

GOOGLE AI suite

Job description

Established in 1806 as a small soap and candle business in New York City, Colgate-Palmolive is now a truly global company with products sold in over 200 countries and territories under such internationally recognised brand names as Colgate, Palmolive, Softsoap, Irish Spring, Protex, Sorriso, Kolynos, elmex, Tom's of Maine, Sanex, Ajax, Axion, Soupline, Haci Sakir, Suavitel, PCA SKIN, EltaMD, Filorga and Hello as well as Hill's Science Diet and Hill's Prescription Diet.

Colgate-Palmolive is a leading consumer products company that serves hundreds of millions of consumers worldwide with brands and products across four core businesses – Oral Care, Personal Care, Home Care and Pet Nutrition. We are committed to offering products that make lives healthier and more enjoyable, and programmes that enrich communities around the world.

Every day millions of people trust our products to care for themselves and the ones they love. Our goal is to use our technology to create products that will continue to improve the quality of life for our consumers wherever they live.

A career at 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: Digital & Analytics Specialist

Travel Required?: No Travel

Posting Start Date: 24/09/2026

Hybrid

No Relocation Assistance Offered

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

Who We Are

Colgate-Palmolive Company is a global consumer products company operating in over 200 countries specialising 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.

Please note this is a 12 months contractual role

The D&A Specialist supports data management and analytics initiatives by designing and implementing Extract, Transform and Load (ETL) processes, creating and maintaining actionable dashboards in Domo and Sigma, and optimizing process efficiency through the use of AI tools. This position is responsible for facilitating business reviews to identify supply chain efficiencies, supporting the development of predictive analytics models, and preparing insightful reports for management.

Additionally, the role supports customer data projects by providing critical financial, logistics, and customer analysis, leading small-scale projects, and coordinating with key functional experts to drive continuous improvement.

This key player will streamline through collaboration and analytics where needed and also work off an automated analytic priority list as assigned by leadership. The D&A Specialist must leverage both customer data and internal data to drive growth and efficiencies and support demand and supply synchronization initiatives.

Responsibilities:

Design and implement ETL processes, create dashboards, and optimize efficiency through evaluations:

Develop and manage ETL processes and pipelines for Colgate-Palmolive approved platforms

Build and maintain actionable Domo and Sigma dashboards

Monitor process efficiency and recommend adjustments when necessary

Conduct training sessions to enhance broader team proficiency with reporting tools

Provide quality assurance of imported data, working with quality assurance analysts if necessary.

Commissioning and decommissioning of data sets.

Training end-users on new reports, dashboards and AI tools

Providing technical expertise in data storage structures, data mining, and data cleansing.

Work with different members of the CS&L team on reporting and automating analytical needs.

Work cross functionally with different teams on data sets, inputs and outputs.

Required Qualifications and Knowledge:

Minimum of a Bachelor's degree in data analytics, engineering, computer science or related.

Experience working in databases like snowflake, Big query, etc.

Experience in SQL programming: ability to read/write complex SQL queries to analyze data, investigate systemic defects and validate data quality.

Working knowledge of data modeling, data warehousing, and ability to access relational and multidimensional databases.

Ability to develop AI tools that help with user queries or automate tasks

Ability to learn and work in a changing environment with minimal supervision.

Strong decision making skills and sound judgment.

Innovation and willingness to drive process improvement and reporting.

Preferred:

Strong desire to serve the customer, identify and revolve needs and follow up when necessary.

Ability to lead data retrieval, transformation, aggregation, and organization in cloud-based systems (Snowflake preferred) and visualization in Sigma, Domo, or other similar tools.

Ability to write queries in spreadsheet processing programs and SQL.

Prior background within the Consumer Packaged Goods industry.

Technical proficiency in SAP architectures, specifically S/4 and APO modules

Technical proficiency in google AI suite of tools (Gemini, NotebookLM, workspace studio)

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, colour, 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.