Commercial Analytics Specialist - Drive Revenue Insights

Qantas Airways; Sydney; Hybrid; AUD 140,000 - 190,000; Full time

Job summary

Monks is a global digital-first consultancy blending creativity, data and technology. We seek an Analytics Engineer to build data pipelines from GA4 exports, ad platforms and CRM data into BigQuery, then model events with dbt or Dataform.

The role involves orchestrating jobs via Cloud Composer and setting up data quality tests, while shaping a semantic layer for Looker Studio dashboards. Candidate will translate measurement plans into tables, answer client questions with SQL, and contribute to

Qualifications

• Strong SQL skills and experience with GA4 data models.
• Hands-on BigQuery experience including partitioning and cost control.
• Experience building and scheduling pipelines on Google Cloud (Composer, Dataform, dbt).
• Python for data work and version control with Git.

Responsibilities

• Build and maintain pipelines bringing GA4 exports, ad platform, and CRM data into BigQuery.
• Model raw event data into clean tables using SQL and dbt or Dataform.
• Orchestrate jobs with Cloud Composer/Airflow or Cloud Run.
• Set up data quality tests and monitoring.
• Work with GA4 BigQuery export schemas and looker dashboards.
• Present findings to clients and internal stakeholders.
• Prepare datasets for BigQuery Analytics tools and AI experiments.

Skills

SQL

BigQuery

Python

Data modelling

Data pipelines

GA4 knowledge

GTM/CM360 knowledge

Tools

dbt

Dataform

Airflow (Cloud Composer)

Looker Studio

Git

Job description

Analytics Engineer - Monks

Location: Sydney or Melbourne (hybrid)

Contract: Permanent, full-time

About Monks

Monks is a global, digital‑first marketing, technology and creative consultancy operating at the intersection of creativity, media, data and culture.

Key Responsibilities

• 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.
• Work with GA4 BigQuery export schemas, unnesting event parameters, sessionising events and rebuilding attribution.
• Partner with tagging specialists to check GTM and GA4 implementations produce reliable data.
• Translate measurement plans into tables and metrics that answer them.
• Answer client questions directly with SQL.
• Build semantic layer behind Looker Studio dashboards.
• Present findings to client and internal stakeholders.
• Prepare and govern datasets for BigQuery Conversational Analytics, Gemini and agent‑based tools.
• Conceptualise and build PoC‑level AI tools on client data.
• Use AI coding assistants in workflow.

What you’ll bring

• Strong SQL skills, including window functions, CTEs, nested or repeated field queries.
• Hands‑on BigQuery experience including partitioning, clustering and cost control.
• Knowledge of GA4: event model, BigQuery export schema.
• Experience building and scheduling pipelines on Google Cloud (Composer, Dataform, dbt).
• Python for data work (API extraction, transformation scripts). Git version control.
• Comfortable explaining data to non‑technical people.
• Interest in applying AI to analytics.
• Experience with GTM, CM360, DV360, SA360, Vertex AI, Gemini APIs or LLM‑based agents is a big plus.
• Exposure to privacy and consent topics, Google Cloud certifications is welcome.