SQL Developer

Renaissance InfoSystems; Sydney; On-site; AUD 120,000 - 160,000; Full time

Job summary

Renaissance Info Systems in Sydney seeks an experienced SQL Developer focused on Google BigQuery analytics and data transformations. You design and optimize complex queries and data views, leveraging Python for data wrangling and automation.

You will collaborate with analysts and onshore teams to deliver scalable BigQuery solutions while ensuring governance and performance tuning. This is a permanent, full-time role based in Sydney.

Qualifications

• 12+ years of hands-on SQL development experience.
• Experience with PL/SQL or other RDBMS platforms.
• Strong expertise in Google BigQuery or similar cloud-based data warehouses.
• Ability to work independently, engage with onshore stakeholders, and deliver SQL solutions.
• 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.

Responsibilities

• Design, develop, and optimize complex SQL queries and views in BigQuery for analytics.
• Implement advanced 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.
• Troubleshoot performance issues and optimize query execution plans.
• Ensure compliance with data governance and security standards.

Skills

SQL

BigQuery

PL/SQL

RDBMS

Python (Pandas)

Data modeling

Partitioning

Performance tuning

Independent work

Stakeholder engagement

Tools

Google BigQuery

Python

Google Cloud Platform (GCP)

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.

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.