Job Description
XPT Software Australia Pty Ltd | Contract
Sydney , Melbourne , Brisbane, Australia | Posted on 10/06/2026
XPT SoftwareAustralia PTY Ltd, incorporated in ****, is a Software Services company
XPT works with topclients across Australia in Banking, Insurance, Telecom,Retail, Energy, Mining andManufacturingdomains.
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 DescriptionJob Overview
We are seeking an experiencedDBT Data Engineer with 8+ years of experiencein data engineering, data transformation, and cloud data platforms.
The ideal candidate should have strong hands-on expertise indbt (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 scalabledata transformation pipelines using dbt.
Develop complexSQL-based data modelsusing dbt.
Build and maintainstaging, intermediate, and mart layersfollowing dbt best practices.
Implementdbt models, macros, snapshots, seeds, tests, and incremental models.
Develop reusable and optimized SQL transformations for large datasets.
Implementdata quality checks and automated testingusing dbt.
Build and maintain data lineage and documentation usingdbt documentation.
Integrate dbt with cloud data platforms and enterprise data pipelines.
Optimize data models and SQL queries for performance and cost.
Implement incremental loading andChange 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 withdbt / dbt Core / dbt Cloud
AdvancedSQLskills
Strong experience indata warehousing and dimensional data modeling
Experience developingdbt models, macros, snapshots, seeds, and tests
Solid understanding ofincremental models and materializations
Experience withdata quality and testing frameworks
Strong experience withGit and CI/CD
Hands-on experience with at least one modern cloud data warehouse:
Snowflake
Databricks
Amazon Redshift
Google BigQuery
Strong understanding of data integration and transformation concepts
Experience withPythonfor dataengineering/automation
Nice to Have
Experience withAWS / Azure / GCP
Experience withAirflow / Dagster / Prefect
Experience withSnowflake
Experience withDatabricks / Delta Lake
Experience withAmazon Redshift
Experience withFivetran / Matillion / Informatica
Experience withKafka or streaming data
Experience withTerraform
Experience withDocker
Experience with data governance and catalog tools
Experience working inAgile/Scrumenvironments
Technical Skills
Data Transformation:dbt, dbt Cloud, dbt Core
Database/Warehouse:Snowflake, Databricks, Redshift, BigQuery
Languages:SQL, Python
ETL/ELT:dbt, Airflow, Fivetran, Matillion
Data Modeling:Star Schema, Snowflake Schema, Dimensional Modeling
#J-*****-Ljbffr

📌 Dbt Data Engineer (Melbourne)
🏢 Zoho
📍 Melbourne