Job Description
XPT Software Australia Pty Ltd | Contract
n
Sydney , Melbourne , Brisbane, Australia | Posted on 10/06/2026
n
n
XPT SoftwareAustralia PTY Ltd, incorporated in ****, is a Software Services company
n
XPT works with topclients across Australia in Banking, Insurance, Telecom,Retail, Energy, Mining and
Manufacturingdomains.
n
We have 120+technocrats in Australia working at our clientlocations.
n
XPT SoftwareAustralia is part of group companies which has globalpresence across India & Europe.
n
We have served100+ clients globally, fulfilling their onsite-offshoreneeds.
n
Job DescriptionJob Overviewn
n
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 robust 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 Responsibilitiesn
n
n
Design, develop, and maintain scalable
data transformation pipelines using dbt
.
n
Develop complex
SQL-based data models
using dbt.
n
Build and maintain
staging, intermediate, and mart layers
following dbt best practices.
n
Implement
dbt models, macros, snapshots, seeds, tests, and incremental models
.
n
Develop reusable and optimized SQL transformations for large datasets.
n
Implement
data quality checks and automated testing
using dbt.
n
Build and maintain data lineage and documentation using
dbt documentation
.
n
Integrate dbt with cloud data platforms and enterprise data pipelines.
n
Optimize data models and SQL queries for performance and cost.
n
Implement incremental loading and
Change Data Capture (CDC)
strategies where required.
n
Work closely with Data Architects, Analysts, BI Developers,



and Business stakeholders.
n
Troubleshoot data pipeline and transformation failures in development and production environments.
n
Implement CI/CD processes for dbt deployments using Git and DevOps tools.
n
Follow data governance, security, quality, and engineering best practices.
n
Participate in code reviews, technical design discussions, and Agile ceremonies.
n
Must Have Skillsn
n
n
8+ years of overall Data Engineering experience
n
Strong hands-on experience with
dbt / dbt Core / dbt Cloud
n
Advanced
SQL
skills
n
Strong experience in
data warehousing and dimensional data modeling
n
Experience developing
dbt models, macros, snapshots, seeds, and tests
n
Strong understanding of
incremental models and materializations
n
Experience with
data quality and testing frameworks
n
Strong experience with
Git and CI/CD
n
Hands-on experience with at least one modern cloud data warehouse:n
n
Snowflake
n
Databricks
n
Amazon Redshift
n
Google BigQuery
n
n
Strong understanding of data integration and transformation concepts
n
Experience with
Python
for data
engineering/automation
n
Nice to Haven
n
n
Experience with
AWS / Azure / GCP
n
Experience with
Airflow / Dagster / Prefect
n
Experience with
Snowflake
n
Experience with
Databricks / Delta Lake
n
Experience with
Amazon Redshift
n
Experience with
Fivetran / Matillion / Informatica
n
Experience with
Kafka or streaming data
n
Experience with
Terraform
n
Experience with
Docker
n
Experience with data governance and catalog tools
n
Experience working in
Agile/Scrum
environments
n
Technical Skillsn
n
Data Transformation:
dbt, dbt Cloud, dbt Core
n
Database/Warehouse:
Snowflake, Databricks, Redshift, BigQuery
n
Languages:
SQL, Python
n
ETL/ELT:
dbt, Airflow, Fivetran, Matillion
n
Data Modeling:
Star Schema, Snowflake Schema, Dimensional Modeling
#J-*****-Ljbffr

📌 Dbt Data Engineer (Melbourne)
🏢 Zoho
📍 Melbourne