Snowflake Data Engineer: AI‑Driven Cloud Data Platform

Deloittenz; Auckland; On-site; NZD 120,000 - 180,000; Full time

Job summary

Deloitte in Aotearoa is seeking an experienced Data Engineer to design, build, and optimize Snowflake-based data solutions. You will implement scalable data pipelines, data models, and ingestion across cloud platforms while embedding AI-assisted development practices. Collaborate with cross-functional teams to deliver reliable data platforms.

The role emphasizes security, governance, and performance, with opportunities to contribute to reusable patterns and engineering standards.

Qualifications

• Strong hands-on experience with Snowflake and advanced SQL.
• Solid experience designing and building ETL/ELT pipelines and cloud-based data platforms.
• Strong understanding of data warehousing, data modelling, and modern data engineering principles.
• Good understanding of Snowflake capabilities including databases, schemas, warehouses, stages, streams, tasks, roles, and performance optimisation.

Responsibilities

• Design, develop, and maintain scalable data solutions on Snowflake.
• Build robust ETL/ELT pipelines for structured and semi-structured data.
• Develop high-quality and reusable SQL-based data transformations and engineering frameworks.
• Design dimensional and analytical data models to support reporting, analytics, and AI use cases.
• Build and maintain data ingestion solutions integrating Snowflake with cloud platforms, APIs, databases, files, and other enterprise data sources.
• Implement automated CI/CD pipelines and modern DevOps practices for Snowflake deployments.
• Work with cloud technologies across Azure and/or AWS.
• Implement appropriate RBAC, security, governance, data quality, and monitoring controls.
• Monitor and optimise Snowflake workloads for performance, scalability, reliability, and cost.
• Troubleshoot complex data pipeline and platform issues across development and production environments.
• Collaborate with architects, analysts, engineers, and business stakeholders to translate requirements into practical technical solutions.
• Contribute to engineering standards, reusable patterns, technical documentation, and continuous improvement.
• Proactively leverage CoCo, GitHub Copilot, and other AI-powered development tools across solution design, coding, testing, troubleshooting, code review, and documentation.
• Identify opportunities to use AI and automation to reduce repetitive engineering effort and accelerate the development lifecycle.

Skills

Snowflake

Advanced SQL

ETL/ELT pipelines

Cloud platforms

Python

Git

CI/CD

Tools

dbt

Airflow

Azure Data Factory

Git

Job description

Deloitte in Aotearoa is seeking an experienced Data Engineer to design, build, and optimize Snowflake-based data solutions. You will implement scalable data pipelines, data models, and ingestion across cloud platforms while embedding AI-assisted development practices. Collaborate with cross-functional teams to deliver reliable data platforms.

The role emphasizes security, governance, and performance, with opportunities to contribute to reusable patterns and engineering standards.