Senior BigQuery SQL Architect — Sydney Data Analytics

CareCone Group; Sydney; On-site; AUD 150,000 - 210,000; Full time

Job summary

CareCone Group is seeking a highly experienced Senior SQL Developer to design, optimize, and manage advanced BigQuery analytics workloads in Sydney. The role emphasizes complex SQL for large datasets, performance tuning, and data governance, with exposure to Python for automation.

Independent work with onshore stakeholders is expected. The ideal candidate has deep BigQuery expertise, strong data modeling skills, and a proven track record of delivering scalable data solutions in cloud

Qualifications

• 12+ years hands-on SQL development experience (PL/SQL or other RDBMS acceptable).
• Deep expertise in Google BigQuery and cloud-based data warehouses.
• Experience with Python Pandas for data transformation.
• Ability to work independently with Onshore teams.

Responsibilities

• Design, develop, and optimize complex SQL queries and views in Google BigQuery for analytics.
• Implement advanced transformations using window functions, CTEs, and partitioning.
• Collaborate with analysts to translate requirements into BigQuery solutions.
• Use Python (Pandas) for data wrangling and automation scripts where needed.
• Troubleshoot performance issues and optimize query execution plans.
• Ensure data governance and security standards.

Skills

SQL development

PL/SQL / RDBMS

Google BigQuery

Python (Pandas)

Data modeling

Performance tuning

Analytical skills

Independent work

Job description

CareCone Group is seeking a highly experienced Senior SQL Developer to design, optimize, and manage advanced BigQuery analytics workloads in Sydney. The role emphasizes complex SQL for large datasets, performance tuning, and data governance, with exposure to Python for automation.

Independent work with onshore stakeholders is expected. The ideal candidate has deep BigQuery expertise, strong data modeling skills, and a proven track record of delivering scalable data solutions in cloud