Senior BigQuery SQL Developer for Data Analytics & Cloud

Renaissance InfoSystems; Sydney; On-site; AUD 140,000 - 190,000; Full time

Job summary

Renaissance Info Systems in Sydney seeks a highly experienced SQL Developer with deep expertise in complex SQL query design and optimization. The role focuses on Google BigQuery for analytics and data transformations, with exposure to Python (Pandas) for data wrangling.

The successful candidate will work directly with the client, designing and optimizing queries, implementing transformations, and ensuring performance and data governance in a cloud-enabled environment.

Qualifications

• 12+ years of hands-on SQL development experience.
• Strong expertise in Google BigQuery or similar cloud data warehouses.
• Basic Python (Pandas) for data manipulation.

Responsibilities

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

Skills

SQL development

BigQuery

Python (Pandas)

Data modeling

Performance tuning

Partitioning

Onshore collaboration

Tools

Google BigQuery

Job description

Renaissance Info Systems in Sydney seeks a highly experienced SQL Developer with deep expertise in complex SQL query design and optimization. The role focuses on Google BigQuery for analytics and data transformations, with exposure to Python (Pandas) for data wrangling.

The successful candidate will work directly with the client, designing and optimizing queries, implementing transformations, and ensuring performance and data governance in a cloud-enabled environment.