Senior BigQuery SQL Engineer - Analytics & Automation

Zone IT Solutions; Sydney; On-site; AUD 120,000 - 180,000; Full time

Job summary

Zone IT Solutions is seeking a highly experienced Senior SQL Developer to design, optimize, and manage complex SQL queries in Google BigQuery for advanced analytics and data transformations.

The role requires 12+ years in SQL development, strong BigQuery expertise, and a willingness to learn related Google Cloud technologies. A background in Python Pandas for data manipulation is a plus.

Qualifications

• 12+ years of hands-on SQL development experience (PL/SQL or other RDBMS acceptable).
• Strong expertise in Google BigQuery or similar cloud-based data warehouses preferred but not mandatory.
• Self-starter with ability to interact with Onshore and deliver SQL solutions independently.
• Proven ability to write and optimize complex SQL queries for large datasets.
• Basic experience with Python, especially Pandas for data manipulation.
• Solid understanding of data modeling, partitioning, and performance tuning in BigQuery.
• Excellent problem-solving and analytical skills.

Responsibilities

• Design, develop, and optimize complex SQL queries and views in Google BigQuery for large-scale analytical workloads.
• Implement advanced transformations and aggregations using BigQuery’s capabilities (e.g., window functions, CTEs, partitioning).
• Collaborate with analysts and business stakeholders to translate requirements into efficient BigQuery solutions.
• Use Python (Pandas) for data wrangling and automation scripts where needed.
• Troubleshoot performance issues and optimize BigQuery query execution plans.
• Ensure compliance with data governance and security standards.

Skills

SQL development

BigQuery

Python Pandas

Query optimization

Data transformation

Tools

PL/SQL

Job description

Zone IT Solutions is seeking a highly experienced Senior SQL Developer to design, optimize, and manage complex SQL queries in Google BigQuery for advanced analytics and data transformations.

The role requires 12+ years in SQL development, strong BigQuery expertise, and a willingness to learn related Google Cloud technologies. A background in Python Pandas for data manipulation is a plus.