Public listing

Snowflake Data Engineer

NCS Australia Melbourne, VIC, Australia
  • Work modeHybrid
  • EmploymentContract
  • ListedPosted 4 days ago
  • SourceSmartrecruiters

Role overview

About the role

Description supplied by the original job listing.

We are seeking an experienced Snowflake Data Engineer to design, build, and maintain scalable data pipelines and transformation frameworks. You will own the end-to-end data flow from ingestion through to consumption-ready Gold layer outputs, ensuring data quality, performance, and alignment with business requirements.
As a Snowflake Data Engineer, you will design and build reusable ingestion frameworks supporting batch, incremental, and streaming loads with robust error handling and schema evolution capabilities. You will develop and maintain dbt transformation models across Silver (cleansed, conformed) and Gold (consumption-ready) layers, ensuring alignment with source-to-target mappings and business rules. You will implement comprehensive automated testing frameworks (uniqueness, not-null, referential integrity, and custom business-rule tests) to safeguard data quality, validate Gold layer outputs against agreed models, and perform reconciliation testing across source, Silver, and Gold layers. You will own defect triage, investigation, and resolution within agreed SLAs, conducting root-cause analysis and implementing preventative fixes. You will produce and maintain interface documentation covering source connections, data contracts, schedules, dependencies, and technical metadata lineage. You will apply CI/CD and version control standards to all pipeline and dbt code, ensuring peer-reviewed, tested deployments across environments. You will monitor and optimise pipeline performance, reliability, and cost through logging, alerting, and observability implementation. Finally, you will collaborate closely with Data Modellers, analysts, and stakeholders to ensure delivered pipelines are fit for purpose, performant, and aligned to business definitions.
Advanced proficiency in Snowflake SQL, schema design, performance tuning, and Snowflake-specific features (stages, pipes, streams, dynamic tables)
Expert-level dbt (data build tool) experience: building, testing, documenting projects; model dependencies and macro development
Strong foundation in ETL/ELT design, data warehousing concepts, and dimensional modelling
Expert SQL writing, query optimisation, and complex transformation logic
Scripting capability in Python or similar languages for orchestration, data validation, and custom transformations
Experience with orchestration tools (Airflow, Prefect, or equivalent)
Proficiency with Git workflows, branching strategies, and CI/CD pipeline integration
Proven experience designing and implementing data quality frameworks
Familiarity with automated testing tools and methodologies
Understanding of data validation, reconciliation, and audit patterns
Hands-on experience with cloud data platforms (AWS, Azure, or GCP)
Familiarity with infrastructure-as-code, containerisation, or deployment automation
Understanding of logging, monitoring, and alerting tools
Strong problem-solving and analytical mindset
Clear communication and documentation abilities
Collaborative approach to cross-functional teamwork
Proactive issue identification and resolution
Meticulous attention to detail and commitment to data accuracy
Demonstrated track record of delivering production data pipelines at scale

Skills
Snowflake, Python, Git, AWS, Azure, GCP, CI/CD, SQL, Airflow, Automation Testing

Employment type
Contract

Work arrangement
Hybrid

Skills from the listing

  • Snowflake
  • Python
  • Git
  • AWS
  • Azure
  • GCP
  • CI/CD

Your early-applicant advantage

How quickly JobBeeper finds and shares openings.

23 min from Smartrecruiters publishing this role to us finding it
10 min median time from a role going live to a subscriber being told
6 hours subscribers had this role before this page existed
68,394 roles found in the last 24 hours
See available plans →

Job alerts

Get notified about new openings

Save your preferences, then add a paid plan for matching job alerts.

Create free account
Log in to apply