AI Analytics Engineer: BigQuery Pipelines & Dashboards

Monks; Sydney Township (ND); Hybrid; USD 84,000 - 126,000; Full time

Benefits offered by this job

Hybrid work (Sydney/Melbourne)

Early access to AI tools

Job summary

Monks is seeking an Analytics Engineer to turn raw GA4, media and CRM data into modelled datasets in BigQuery for marquee brands. Join the Data team in Sydney or Melbourne (hybrid) as a mid-level, full-time hire, focusing on measurement strategy, data engineering and applied AI.

You'll work on enterprise clients across sectors, build pipelines, and own long-running data products while contributing to AI tool development and governance.

Qualifications

• Strong SQL skills including window functions, CTEs and nested queries.
• Hands-on BigQuery experience with partitioning, clustering and cost control.
• Working knowledge of GA4 data model, BigQuery export schemas, and the GA4 interface.
• Experience building and scheduling pipelines on Google Cloud (Composer, Dataform, dbt, Cloud Run).
• Proficient Python for data extraction, transformation and automation.
• Experience explaining data to non-technical clients and stakeholders.

Responsibilities

• Build and maintain pipelines that bring GA4 exports, ad platform data and CRM data into BigQuery.
• Model raw event data into clean, documented tables using SQL and dbt/Dataform.
• Orchestrate jobs with Cloud Composer, Cloud Functions or Cloud Run.
• Set up data quality tests and monitoring to catch issues before dashboards.
• Translate measurement plans into tables and metrics that answer client questions.
• Develop Looker Studio/Looker semantic layers to ensure consistent reporting.
• Present findings to clients and team in clear, plain language.
• Prepare datasets for AI tools like Gemini and agent-based systems.

Skills

SQL

BigQuery

Python

dbt/Dataform

Airflow/Cloud Composer

GA4

Looker Studio

Google Cloud

Tools

BigQuery

GA4

GTM

DV360

CM360

SA360

Vertex AI

Job description

Monks is seeking an Analytics Engineer to turn raw GA4, media and CRM data into modelled datasets in BigQuery for marquee brands. Join the Data team in Sydney or Melbourne (hybrid) as a mid-level, full-time hire, focusing on measurement strategy, data engineering and applied AI.

You'll work on enterprise clients across sectors, build pipelines, and own long-running data products while contributing to AI tool development and governance.