Senior BigQuery SQL Engineer (Sydney)

CareCone Group; Sydney; On-site; AUD 160,000 - 220,000; Full time

Job summary

CareCone Group is seeking a highly experienced SQL professional focused on complex SQL query design and optimization, with strong knowledge of SQL (PL/SQL or other RDBMS) and exposure to Python (Pandas) for data transformation. The role concentrates on Google BigQuery SQL development for advanced analytics and data transformations. Willingness to train in Google Cloud technologies is essential.

Location: Sydney. Position: Permanent.

Qualifications

• 12+ years of hands-on SQL development experience.
• Experience with Google BigQuery or similar cloud data warehouses preferred.
• Basic Python (Pandas) for data manipulation and automation.

Responsibilities

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

Skills

12+ years experience

SQL development

Google BigQuery

Python Pandas

Tools

BigQuery

Python

Pandas

Job description

CareCone Group is seeking a highly experienced SQL professional focused on complex SQL query design and optimization, with strong knowledge of SQL (PL/SQL or other RDBMS) and exposure to Python (Pandas) for data transformation. The role concentrates on Google BigQuery SQL development for advanced analytics and data transformations. Willingness to train in Google Cloud technologies is essential.

Location: Sydney. Position: Permanent.