Senior Snowflake / dbt Engineer

Sydney CBD, New South Wales 2000, Australia • Full-time
AI Job Summary
  • Advanced Snowflake SQL and performance optimization for scalable transformations.
  • Hands-on experience with reusable dbt frameworks, models, macros, packages, testing, and deployment.
  • Experience migrating data solutions from Teradata or other legacy platforms to Snowflake.

Role Type

Contract • Full-time • Mid-level Senior

Description

Responsibilities

·                Design and develop scalable Snowflake-based data transformation solutions.

  • Build and maintain reusable dbt frameworks, models, macros, and templates.
  • Develop enterprise data models and transformation standards.
  • Implement automated testing, data-quality controls, and validation frameworks.
  • Manage model lineage, dependencies, and environment promotion processes.
  • Support CI/CD implementation and Git-based development practices.
  • Drive migration and modernization initiatives from legacy data platforms to Snowflake.
  • Collaborate with platform engineering teams to ensure alignment with enterprise standards.

Mandatory Skills

·                Advanced Snowflake SQL and performance optimization skills.

  • Strong hands-on dbt experience including macros, packages, testing, and deployment.
  • Data modelling and transformation engineering expertise.
  • Experience implementing automated testing and data quality frameworks.
  • Strong Git, CI/CD, and DevOps practices.
  • Experience migrating data solutions from Teradata or other legacy platforms.
  • Strong understanding of enterprise data architecture and engineering principles.