Senior SQL Developer

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

Role- Senior Sql Developer

Type- Permanent

Location- Sydney

Role Overview

We are looking for a highly experienced SQL professional with deep expertise in complex SQL query design and optimization. The ideal candidate will have a strong background in SQL (including experience in PL/SQL or other RDBMS systems) and some exposure to Python (Pandas) development for data transformation and automation. This role focuses exclusively on Google BigQuery SQL development for advanced analytics and data transformations.

Key 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.

Required Skills & Experience

• 12+ years of hands-on experience in SQL development (experience in PL/SQL or other RDBMS is acceptable).
• Strong expertise in Google BigQuery or similar cloud-based data warehouses is 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

Nice-to-Have

• Familiarity with ETL tools and data pipeline concepts.
• Exposure to cloud platforms (GCP preferred).