Fleet Optimization & Analytics Specialist

Invocare; Sydney; Hybrid; AUD 110,000 - 150,000; Full time

Job summary

Colgate-Palmolive is seeking an Analytics Engineer to build data foundations from GA4, ad data, and CRM. You will model data in BigQuery and enable AI-enabled insights for marketing decisions.

The role is based in Sydney or Melbourne with a hybrid work model. You will join a regional data team delivering measurement, tagging, data engineering, reporting, and applied AI across major brands.

Qualifications

• Strong SQL skills with complex queries and data analysis
• Experience building pipelines and data models in cloud data warehouses
• Proficiency with BigQuery, Looker Studio, and BI tools
• Familiarity with ETL/ELT concepts, data quality, and governance

Responsibilities

• Build and maintain ETL pipelines for GA4, ad platform data, and client CRM
• Create and manage dashboards in Domo, Sigma, and Looker Studio
• Develop AI-assisted analytics tools and PoC solutions
• Ensure data quality, governance, and monitoring across pipelines
• Collaborate with cross-functional teams to deliver insights
• Present findings to clients and internal stakeholders clearly

Skills

SQL expertise

Data modelling

BigQuery

dbt/Dataform

Python for data work

GA4 understanding

Data visualization

Cloud platforms

Communication skills

Tools

BigQuery

Looker Studio

Looker

Domo

Sigma

dbt

Cloud Composer (Airflow)

Google Cloud

GTM/GMP data tools

Job description

The job posting under review is the Fleet Optimization Analytics Specialist role for Sydney.

No Relocation Assistance Offered

Job Number# - 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.

Contract: 12 months

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.

About Monks

Monks is a global, digital-first marketing, technology, and creative consultancy operating at the intersection of creativity, media, data, and culture. In APAC, our 700-strong team spans 14 offices across 11 countries, connected by a single, unified operating model.

As pioneers in the AI economy, we live an AI-first culture internally while helping enterprise clients shift from manual workflows to AI-native orchestration — scaling custom agent solutions (Monks.Flow), AI-driven campaigns, and next-gen AI search capabilities. By connecting brand strategy, media, data and emerging technology around the consumer, we build intelligent platforms and content ecosystems for the world's leading brands. We foster a diverse, equitable, and inclusive workplace where authentic collaboration fuels industry-changing work.

The Role

Monks is looking for an Analytics Engineer to build the data foundations our clients' marketing decisions run on. You will turn raw GA4, media and CRM data into modelled, trusted datasets in BigQuery for some of the region's biggest brands. You will also help us put AI to work on that data.

You will join the Data team in Sydney or Melbourne (hybrid) as a full time, permanent, mid-level hire. The team covers measurement strategy, tagging and implementation, data engineering, reporting and applied AI. Our stack is built on Google Cloud: GA4, Google Tag Manager, BigQuery, Looker Studio and the Google Marketing Platform. We are increasingly building agentic and Gemini-based tools on top of client data.

The ideal candidate has built pipelines and models on Google Cloud for marketing data, writes strong SQL and is comfortable explaining the results to clients. You will work on a mix of engagements. Some are short builds with a clear finish line. Others are long-running data products you will own and improve over time.

This role offers a huge opportunity for growth within our AUNZ team and APAC data team with clear channels of progression into leadership. You will work on enterprise brands across automotive, retail, financial services and higher education. You will also get early access to the AI tools we are building plus a say in how they evolve.

What You'll Do

• Pipelines and modelling: build and maintain pipelines that bring GA4 exports, ad platform data (Google Ads, DV360, Meta, CM360) and client CRM data into BigQuery.
• Model raw event data into clean, documented tables using SQL and dbt or Dataform.
• Orchestrate jobs with Cloud Composer (Airflow), Cloud Functions or Cloud Run.
• Set up data quality tests and monitoring so issues are caught before they reach a dashboard.
• GA4 and measurement: work with GA4 BigQuery export schemas, unnesting event parameters, sessionising events and rebuilding attribution where the UI falls short.
• Partner with our tagging specialists to check that GTM and GA4 implementations produce data the models can rely on.
• Translate measurement plans into the tables and metrics that answer them.
• Analysis and reporting: answer client questions directly with SQL, from funnel drop-off to channel performance to customer lifetime value.
• Build the semantic layer behind Looker Studio and Looker dashboards so numbers match across reports.
• Present findings to client and internal stakeholders in plain language.
• AI: prepare and govern datasets for BigQuery Conversational Analytics, Gemini and agent-based tools.
• Conceptualise and build PoC-level AI tools on client data such as natural language querying, automated insight summaries and anomaly detection.
• Use AI coding assistants in your own workflow to ship faster with fewer errors.

What You'll Bring

• You write strong SQL: window functions, CTEs and nested or repeated field queries without reaching for a reference.
• You have hands-on BigQuery experience including partitioning, clustering and cost control.
• You have working knowledge of GA4: the event model, the BigQuery export schema and how it differs from the GA4 interface.
• You have built and scheduled pipelines on Google Cloud (Composer, Dataform, dbt, Cloud Run or similar).
• You use Python for data work: API extraction, transformation scripts and light automation.
• You use version control with Git and have a habit of documenting what you build.
• You are comfortable explaining data to non-technical people, including clients.
• You are interested in applying AI to analytics work, backed by something you have tried or built.
• Experience with Google Tag Manager (client side or server side), Google Marketing Platform data (CM360, DV360, SA360), Vertex AI, Gemini APIs or LLM-based agents is a big plus in consideration.
• Exposure to privacy and consent topics such as Consent Mode, first-party data and the Australian Privacy Act is welcome, as are Google Cloud certifications (Professional Data Engineer or similar).