SQL Developer

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

About Us: Renaissance Info Systems is a technology and digital recruitment agency, connecting contract and permanent professionals with clients across Asia-Pacific. We aim to differentiate ourselves through our level of responsiveness, and our understanding that comes from being an IT recruitment agency from the IT Industry. Our recruiters balance sophisticated and simple inter-personal techniques to assure a strong candidate network. Know More: http://www.reninfo.com.au.

About Us: Renaissance Info Systems is a technology and digital recruitment agency, connecting contract and permanent professionals with clients across Asia-Pacific. We aim to differentiate ourselves through our level of responsiveness, and our understanding that comes from being an IT recruitment agency from the IT Industry. Our recruiters balance sophisticated and simple inter-personal techniques to assure a strong candidate network. Know More: http://www.reninfo.com.au.

SQL Developer

Location: Sydney, NSW

Employment Type: Permanent, Full-Time

Engagement: Direct with the Client

Role Overview

We are seeking a highly experienced SQL Developer with deep expertise in complex SQL query design and optimization. The ideal candidate will have a strong background in SQL, including PL/SQL or other RDBMS systems, and some exposure to Python (Pandas) for data transformation and automation.

This role focuses exclusively on Google BigQuery SQL development for advanced analytics and data transformations. Experience with Google Cloud is a plus but not mandatory. The successful candidate should be a self-starter who is willing to learn and develop their skills across Google Cloud technologies while delivering SQL solutions independently.

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 capabilities, including window functions, CTEs, and partitioning.
• Collaborate with analysts and business stakeholders to translate requirements into efficient BigQuery solutions.
• Use Python (Pandas) for data wrangling and automation scripts where required.
• 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 SQL development experience. Experience with PL/SQL or other RDBMS platforms is acceptable.
• Strong expertise in Google BigQuery or similar cloud-based data warehouses is preferred but not mandatory.
• Ability to work independently, engage with onshore stakeholders, and deliver SQL solutions.
• Proven ability to write and optimize complex SQL queries for large datasets.
• Basic experience with Python, particularly 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, preferably GCP.