Senior Data Engineer - GCP/ dbt

Ingrity Pty; Sydney; Hybrid; AUD 96,000 - 165,000; Full time

Job summary

INGRITY is seeking a Senior Data Engineer to design, build and optimise scalable data solutions in Sydney, integrating Google BigQuery, dbt and SQL. You will shape data pipelines, models and quality practices while working with stakeholders across analytics and engineering in a hybrid contract role.

Bring 5+ years in data engineering, strong BigQuery and dbt expertise, and advanced SQL skills to deliver trusted data for analytics and reporting in a modern cloud environment.

Qualifications

• 5+ years of experience in Data Engineering with hands-on delivery of cloud data platforms.
• Strong expertise in Google BigQuery, including SQL development and data warehousing.
• Advanced hands-on experience with dbt, developing and maintaining transformation models.
• Solid data modelling experience, including dimensional modelling and star schemas.
• Advanced SQL skills for complex datasets and transformations.
• Experience with Google Cloud Platform (GCP) and modern ELT/ETL architectures.
• Good understanding of data quality, governance and engineering best practices.
• Excellent communication and collaboration with technical and business stakeholders.

Responsibilities

• Design, build and maintain scalable data pipelines using Google BigQuery and dbt.
• Develop and optimise data models, including dimensional modelling and data warehouse structures.
• Create reusable SQL transformations to support analytics and reporting.
• Implement data quality checks, testing and validation across pipelines and models.
• Improve BigQuery performance, efficiency and cost management.
• Collaborate with engineering, analytics and business teams to translate requirements into scalable data solutions.
• Apply engineering best practices including version control, CI/CD, documentation and automated testing.

Skills

BigQuery

dbt

Data modelling

SQL

GCP

Data quality & governance

Communication

Python

Airflow/Cloud Composer

CI/CD & Git workflows

Job description

Senior Data Engineer - GCP / BigQuery / dbt

Location: Sydney, NSW (Hybrid)
Engagement: Contract

The Opportunity:

INGRITY is looking for an experienced Senior Data Engineer to join a data transformation initiative with one of our clients in Sydney.

This is a hands-on role focused on designing, building and optimising scalable data solutions using Google BigQuery, dbt and SQL, with a strong emphasis on data modelling, data quality and engineering best practices.

You'll work closely with data engineers, analysts and business stakeholders to develop robust data pipelines, transform complex datasets and deliver trusted, high-quality data for analytics and reporting.

Key Responsibilities:

• Design, develop and maintain scalable data pipelines and transformations using Google BigQuery and dbt.
• Build and optimise data models, including dimensional modelling, star schemas and data warehouse structures.
• Develop reusable, well-structured SQL transformations to support analytics and reporting.
• Implement data quality checks, testing and validation across data pipelines and models.
• Optimise BigQuery performance, query efficiency and cost.
• Collaborate with engineering, analytics and business teams to translate requirements into scalable data solutions.
• Apply engineering best practices including version control, CI/CD, documentation and automated testing.

Skills & Experience:

• 5+ years of experience in Data Engineering, including hands-on delivery of modern cloud data platforms.
• Strong expertise in Google BigQuery, including SQL development, performance optimisation and data warehousing.
• Advanced hands-on experience with dbt, including developing, testing and maintaining transformation models.
• Strong data modelling experience, particularly dimensional modelling, star schemas and analytical data structures.
• Advanced SQL skills with experience handling complex datasets and transformations.
• Experience with Google Cloud Platform (GCP) and modern ELT/ETL architectures.
• Strong understanding of data quality, governance and engineering best practices.
• Excellent communication skills and ability to work collaboratively with technical and business stakeholders.

Highly Desirable:

• Python for data engineering and automation.
• Experience with orchestration tools such as Airflow or Cloud Composer.
• CI/CD pipelines and Git-based development workflows.
• Experience working in complex enterprise data environments.

Why Join INGRITY?

At INGRITY, we specialise in delivering innovative data, analytics and AI solutions to leading Australian organisations.

You’ll have the opportunity to work on meaningful data transformation projects, collaborate with experienced technical teams and contribute to modern cloud-based data platforms.

If you're a hands-on Senior Data Engineer with strong BigQuery, dbt and data modelling expertise, we'd love to hear from you.