DBT Data Engineer

XPT Software; City of Brisbane; On-site; AUD 140,000 - 190,000; Full time

Job summary

XPT Software Australia Pty Ltd is seeking an experienced DBT Data Engineer with 8+ years of data engineering experience to join our team. You will design scalable data transformation pipelines, build robust data models, and ensure data quality across cloud data platforms.

The ideal candidate will have hands-on expertise in dbt, SQL, Python, data warehousing, and modern cloud technologies, collaborating with data architects, analysts, and business stakeholders in an Agile environment.

Qualifications

• 8+ years of data engineering experience.
• Hands-on with dbt Core / Cloud.
• Advanced SQL skills.
• Experience in data warehousing and dimensional modeling.
• Experience with dbt models, macros, tests.
• Knowledge of incremental models and materializations.
• Experience with Git and CI/CD.
• Experience with a modern cloud data warehouse (Snowflake, Databricks, Redshift, BigQuery).
• ETL/ELT pipelines experience.
• Understanding data integration and transformation concepts.
• Python for data engineering/automation.

Responsibilities

• Design and maintain scalable data transformation pipelines using dbt.
• Develop complex SQL-based data models using dbt.
• Build and maintain staging, intermediate, and mart layers.
• Implement dbt models, macros, snapshots, seeds, tests, and incremental models.
• Develop optimized SQL transformations for large datasets.
• Implement data quality checks and automated testing using dbt.
• Document data lineage using dbt documentation.
• Integrate dbt with cloud data platforms and pipelines.
• Optimize data models and SQL for performance and cost.
• Implement CDC strategies where required.
• Collaborate with Data Architects, Analysts, BI Developers, and stakeholders.
• Troubleshoot data pipelines in dev/prod.
• Participate in CI/CD for dbt deployments.

Skills

dbt Core / Cloud

SQL

Python

Data warehousing

Dimensional modeling

dbt models

Git CI/CD

Cloud platforms

Tools

Airflow

Fivetran

Matillion

Informatica

Docker

Terraform

Kafka

Job description

• XPT SoftwareAustralia PTY Ltd, incorporated in 2016, is a Software Services company
• XPT works with topclients across Australia in Banking, Insurance, Telecom,Retail, Energy, Mining and Manufacturingdomains.
• We have 120+technocrats in Australia working at our clientlocations.
• XPT SoftwareAustralia is part of group companies which has globalpresence across India & Europe.
• We have served100+ clients globally, fulfilling their onsite-offshoreneeds.

Job Overview

We are seeking an experienced DBT Data Engineer with 8+ years of experience in data engineering, data transformation, and cloud data platforms. The ideal candidate should have strong hands-on expertise in dbt (Data Build Tool), SQL, Python, data warehousing, and cloud data platforms. The role will focus on building scalable transformation pipelines, developing reliable data models, and implementing data quality and testing frameworks.

Key Responsibilities

• Design, develop, and maintain scalable data transformation pipelines using dbt.
• Develop complex SQL-based data models using dbt.
• Build and maintain staging, intermediate, and mart layers following dbt best practices.
• Implement dbt models, macros, snapshots, seeds, tests, and incremental models.
• Develop reusable and optimized SQL transformations for large datasets.
• Implement data quality checks and automated testing using dbt.
• Build and maintain data lineage and documentation using dbt documentation.
• Integrate dbt with cloud data platforms and enterprise data pipelines.
• Optimize data models and SQL queries for performance and cost.
• Implement incremental loading and Change Data Capture (CDC) strategies where required.
• Work closely with Data Architects, Analysts, BI Developers, and Business stakeholders.
• Troubleshoot data pipeline and transformation failures in development and production environments.
• Implement CI/CD processes for dbt deployments using Git and DevOps tools.
• Follow data governance, security, quality, and engineering best practices.
• Participate in code reviews, technical design discussions, and Agile ceremonies.

Must Have Skills

• 8+ years of overall Data Engineering experience
• Strong hands-on experience with dbt / dbt Core / dbt Cloud
• Advanced SQL skills
• Strong experience in data warehousing and dimensional data modeling
• Experience developing dbt models, macros, snapshots, seeds, and tests
• Strong understanding of incremental models and materializations
• Experience with data quality and testing frameworks
• Strong experience with Git and CI/CD
• Hands-on experience with at least one modern cloud data warehouse:
  • Snowflake
  • Databricks
  • Amazon Redshift
  • Google BigQuery
• Experience developing ETL/ELT pipelines
• Strong understanding of data integration and transformation concepts
• Experience with Python for data engineering/automation

Nice to Have

• Experience with AWS / Azure / GCP
• Experience with Airflow / Dagster / Prefect
• Experience with Snowflake
• Experience with Databricks / Delta Lake
• Experience with Amazon Redshift
• Experience with Fivetran / Matillion / Informatica
• Experience with Kafka or streaming data
• Experience with Terraform
• Experience with Docker
• Experience with data governance and catalog tools
• Experience working in Agile/Scrum environments

Technical Skills

Data Transformation: dbt, dbt Cloud, dbt Core

Database/Warehouse: Snowflake, Databricks, Redshift, BigQuery

Languages: SQL, Python

ETL/ELT: dbt, Airflow, Fivetran, Matillion

DevOps: Git, CI/CD, GitHub/GitLab/Azure DevOps

Data Modeling: Star Schema, Snowflake Schema, Dimensional Modeling

Cloud: AWS / Azure / GCP

Data Quality: dbt Tests, Data Validation, Data Reconciliation

Methodology: Agile / Scrum

Be careful - Don’t provide your bank or credit card details when applying for jobs. Don't transfer any money or complete suspicious online surveys. If you see something suspicious, report this job ad .