Snowflake Data Engineer

Sorry, this job was removed at 08:43 a.m. (UTC) on Monday, Nov 16, 2026
Be an Early Applicant
Melbourne, Victoria, AUS
Hybrid
Entry level
Artificial Intelligence • Cloud • Information Technology • Consulting • Cybersecurity • Big Data Analytics
Extraordinary Together
The Role
Designs and maintains scalable Snowflake data pipelines and dbt transformation frameworks across ingestion, Silver, and Gold layers. Responsibilities include automated data quality testing, reconciliation, defect resolution, documentation, CI/CD, monitoring, performance and cost optimization, and collaboration with data modellers, analysts, and stakeholders. The role requires production-scale pipeline delivery, robust error handling, schema evolution, and alignment with business requirements.
Summary Generated by Built In
Company Description

Make extraordinary happen

At NCS Australia, we’re the challenger alternative in technology services and consulting. With more than 47 years of Australian heritage, we partner with governments and leading organisations to solve complex challenges, embrace new opportunities and deliver outcomes that make a real difference.

Our people bring together expertise across technology, consulting, delivery, operations, sales and corporate functions. We work collaboratively, challenge the status quo and give our people the opportunity to make an impact — for our clients, our communities and each other.

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.

Qualifications

  • 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

Additional Information

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.

Ready to make extraordinary happen?

We'd love to hear from you.

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.

Skills Required

  • Advanced proficiency in Snowflake SQL, schema design, performance tuning, and Snowflake-specific features including stages, pipes, streams, and dynamic tables
  • Expert-level dbt experience building, testing, documenting projects, managing model dependencies, and developing macros
  • Strong foundation in ETL/ELT design, data warehousing concepts, and dimensional modelling
  • Expert SQL writing, query optimization, and complex transformation logic
  • Scripting capability in Python or similar languages for orchestration, data validation, and custom transformations
  • Experience with orchestration tools such as 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 such as AWS, Azure, or GCP
  • Familiarity with infrastructure-as-code, containerization, 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
  • Valid Australian work rights

Similar Jobs

Commonwealth Bank Logo Commonwealth Bank

Data Engineer

Fintech • Financial Services
In-Office
2 Locations
52000 Employees

Versent Logo Versent

Senior Data Engineer

Information Technology • Consulting
In-Office
4 Locations
456 Employees

Block Logo Block

Channel Sales Support Agent

Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
In-Office or Remote
Melbourne, Victoria, AUS
12000 Employees

Pfizer Logo Pfizer

External Supply PC1 Network Strategy Lead

Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
Remote or Hybrid
9 Locations
121990 Employees
163K-272K Annually
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Thiruvalla
1,358 Employees
Year Founded: 2001

What We Do

NCS in Australia is reinventing technology services from the inside out. We provide advisory, design, build and managed services to our clients, with unrivalled service, attention and understanding every step of the way. We understand day 1001 is just an important as day 1, and we collaborate with clients, striving to provide adaptive approaches, outcomes and thinking by keeping our eye on tomorrow and the days after tomorrow. Our diverse workforce of around 1,300 people has delivered a wealth of large-scale, mission-critical, and multi-platform outcomes for governments and businesses nationally. We are the Australian arm of the pan-APAC technology leader NCS Group, a subsidiary of Singtel Group. Combining the experience and expertise of its 13,000-strong team across 57 specialisations, NCS provides differentiated and end-to-end technology services to clients with its capabilities in digital, data, cloud and platforms, as well as core offerings in application, infrastructure, engineering and cybersecurity. NCS also believes in building a strong partner ecosystem with leading technology players, research institutions and start-ups to support open innovation and co-creation. For more information about NCS Australia, visit ncs.co/en-au or contact our team today. To learn more about NCS Group, visit ncs.co.

Similar Companies Hiring

Blee Thumbnail
Artificial Intelligence • Marketing Tech • Software
New York, New York
33 Employees
Vega Thumbnail
Artificial Intelligence • Automotive • Insurance • Transportation
US
65 Employees
RapidScale Thumbnail
Cloud • Information Technology • Consulting
Raleigh, NC
600 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account