Digital & Analytics Specialist

Colgate Palmolive; Sydney; On-site; AUD 120,000 - 150,000; Full time

Job summary

Colgate-Palmolive seeks a D&A Specialist to design and implement ETL processes, build dashboards in Domo and Sigma, and optimize analytics across supply chain and customer data projects.

You will lead small projects, collaborate with cross-functional teams, and develop predictive analytics with AI tools in a dynamic environment.

Qualifications

• Bachelor's degree in data analytics, engineering, computer science or related.
• Proficient SQL: read/write complex queries to analyze data and validate quality.
• Knowledge of data modeling, data warehousing, relational/multidimensional databases.
• Ability to develop AI tools to assist queries or automate tasks.

Responsibilities

• Design and implement ETL processes; create dashboards; optimize efficiency.
• Develop and manage ETL pipelines for Colgate-Palmolive approved platforms.
• Build and maintain actionable Domo and Sigma dashboards.
• Monitor process efficiency and recommend adjustments as needed.
• Conduct training to enhance team proficiency with reporting tools.
• Ensure data quality with QA analysts as needed.
• Train end-users on reports, dashboards and AI tools.
• Collaborate with CS&L team on reporting and automating analytics needs.
• Coordinate with teams on data sets, inputs and outputs.

Skills

SQL

Data modeling

Data warehousing

AI tools

Cloud data engines

Dashboards

ETL pipelines

Domo

Sigma

Snowflake

Education

Bachelor's degree in data analytics, engineering, computer science or related

Tools

Domo

Sigma

Snowflake

SQL

Job description

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.

Key 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
• Commission and decommission data sets
• Train end-users on new reports, dashboards and AI tools
• 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

About you

• Minimum of a Bachelor's degree in data analytics, engineering, computer science or related
• 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
• Strong desire to serve the customer, identify and resolve 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

About us

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. We are 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.