Snowflake Data Engineer

Ncsaustralia

Melbourne

On-site

AUD 120,000 - 180,000

Full time

5 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

NCS is seeking an experienced Snowflake Data Engineer to design, build, and maintain scalable data pipelines and transformation frameworks. You will own end-to-end data flow from ingestion to Gold layer outputs, ensuring quality, performance, and alignment with business requirements.

You will design reusable ingestion frameworks for batch, incremental, and streaming loads, develop dbt models across Silver and Gold layers, and implement automated data quality tests to safeguard outputs.

Qualifications

  • Advanced proficiency in Snowflake SQL and performance tuning.
  • Expert-level dbt 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

Responsibilities

  • Design, build, and maintain scalable data pipelines and transformation frameworks in Snowflake.
  • Develop and maintain dbt transformations across Silver and Gold layers.
  • Implement automated testing frameworks for data quality and integrity.
  • Own defect triage, root-cause analysis, and remediation within SLAs.
  • Produce and maintain interface documentation for data contracts and schedules.
  • Apply CI/CD and version control to pipelines and dbt code.
  • Monitor, optimize, and cost-control pipelines through observability tools.
  • Collaborate with Data Modellers, analysts, and stakeholders to ensure fit-for-purpose pipelines.

Skills

Snowflake SQL
dbt expert
ETL/ELT design
Python scripting
Airflow
Git CI/CD
Data quality frameworks
Data modelling
Cloud platforms
Logging/monitoring
Communication
Collaboration
Issue resolution
Infrastructure as code

Tools

Snowflake
dbt
Airflow
Git
CI/CD

Job description

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
Why NCS?

This is a place for people who like to get stuck in, bring ideas to life and make things happen. You'll work alongside experienced people who care about what they do, contribute to meaningful work and have the support to keep learning and grow your career. Whether you want to deepen your expertise, explore something new or take your career in a different direction, there's room to make it your own. We value Adventure, Excellence, Integrity, Ownership and Unity - bringing curiosity, collaboration and accountability to the way we work with our clients and each other.

We celebrate diversity and inclusion

We value different perspectives, experiences and strengths our people bring. We're committed to an inclusive workplace where everyone has the opportunity to contribute, grow and succeed, and to providing equal employment opportunities and reasonable adjustments throughout the recruitment process.

Important information

Applicants will need valid Australian work rights and may be required to undergo relevant background, probity and police checks.

Agencies: NCS accepts candidate submissions only from agencies on our preferred supplier panel through the NCS Agency Portal.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Snowflake Data Engineer
Snowflake Data Engineer

NCS Australia • Melbourne

On-site
AUD 150,000 - 190,000
Snowflake Data Engineer: End-to-End Pipelines
Snowflake Data Engineer: End-to-End Pipelines

NCS Australia • Melbourne

On-site
AUD 150,000 - 190,000
Data Engineer - Data Platforms - Snowflake
Data Engineer - Data Platforms - Snowflake

Whizdom • Sydney

Hybrid
AUD 120,000 - 150,000
Hybrid working environment
Snowflake Data Engineer
Snowflake Data Engineer

Persistent • Sydney

Hybrid
AUD 150,000 - 190,000
Competitive salary
Education sponsorship
Flexible hours
+2
GCP Data Engineer - Contract or Perm
GCP Data Engineer - Contract or Perm

NCS • Sydney

On-site
AUD 120,000 - 180,000
Gcp Data Engineer - Contract Or Perm
Gcp Data Engineer - Contract Or Perm

Ncs Australia • Sydney

On-site
AUD 120,000 - 160,000
Snowflake Data Engineer
Snowflake Data Engineer

Persistent Systems • Sydney

Hybrid
AUD 140,000 - 190,000
Competitive salary and benefits
Talent development with education/cert
Cutting-edge technologies
+2
Data Engineer
Data Engineer

Himanshu Gupta • Brisbane, Gold Coast City

On-site
AUD 110,000 - 160,000
Snowflake Data Engineer – Banking
Snowflake Data Engineer – Banking

PM-Partners group • Sydney

On-site
AUD 130,000 - 190,000
Senior Data Engineer — Snowflake, dbt & AWS in Sydney
Senior Data Engineer — Snowflake, dbt & AWS in Sydney

Synechron • Sydney

On-site
AUD 140,000 - 190,000
Top locations