Snowflake Data Engineer

Company Description

Join us. But be you. At Deloitte, you’ll do more than just join something, you’ll add something. You’ve found a place that values your curiosity, passion, and desire to work alongside brilliant people on the things that really matter. There really is only one question: What impact do YOU want to make?

We are looking for an experienced and motivated Snowflake Data Engineer to join our growing AI & Data team. This role is ideal for someone who is passionate about modern data engineering, enjoys solving complex technical challenges, and is keen to embrace AI-assisted engineering practices to deliver solutions faster and smarter.

About the Role

As a Snowflake Data Engineer, you will design, build, and maintain scalable cloud data solutions using Snowflake and modern data engineering technologies.

You will have the opportunity to work across the full engineering lifecycle — from data ingestion and transformation through to modelling, automation, deployment, optimisation, and production support.

We are also looking for someone with an AI-enabled engineering mindset who actively uses tools such as CoCo, GitHub Copilot, and other AI development tools to accelerate delivery while maintaining strong engineering, security, and quality standards.

Job Description

Key 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.

Qualifications

• What We’re Looking For

• 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.

• Experience with orchestration and transformation technologies such as Azure Data Factory, dbt, Airflow, or similar tools are advantageous.

• Experience with Git, CI/CD, and modern software engineering practices.

• Experience with Python is advantageous.

• Familiarity with infrastructure-as-code technologies.

• Strong analytical, troubleshooting, and problem-solving skills.

• Good communication skills and the ability to collaborate effectively with both technical and non-technical stakeholders.

• An AI-enabled engineering mindset — proactively using tools such as CoCo, GitHub Copilot, and other AI capabilities to accelerate development, automate repetitive tasks, improve code quality, and deliver solutions more efficiently.

• Good judgement when using AI-generated outputs, with a strong focus on security, maintainability, accuracy, and engineering quality.

• What Success Looks Like

• You are someone who can take ownership of a data engineering problem from design through to production.

• You care about building solutions that are not only functional, but also scalable, maintainable, secure, automated, and well engineered.

• You are comfortable working across the broader cloud data ecosystem and are always looking for better ways of working — whether through reusable engineering patterns, automation, or effective use of AI-assisted development tools.

• Most importantly, you combine strong technical capability with a delivery-focused and continuous-improvement mindset.

• Why Join Us?

You will have the opportunity to:

• Work on exciting project for some of New Zealand’s best companies

• Work on modern, enterprise-scale Snowflake data platform deployments.

• Solve complex, real-world data engineering challenges.

• Work across data engineering, cloud, analytics, governance, and AI.

• Develop experience with modern engineering and AI-assisted development practices.

• Work alongside experienced data engineers, architects, and technology leaders.

• Contribute to reusable solutions and engineering practices that improve how we deliver data platforms.

• Get the opportunity to work on a variety of different modern data tools.

• If you are passionate about Snowflake, modern data engineering, and using AI to transform the way engineering teams work, we would love to hear from you.

• Additional Information

• So, who is Deloitte in Aotearoa?

• We are driven to create an impact that matters at every opportunity. Supported by a strong leadership team and member firms from over 150 countries across the globe, Deloitte in Aotearoa is in the business of solving complex problems. Over our 175-year history, we have built a reputation for impactful delivery across all areas of our business.

• Deloitte in Aotearoa recognises the uniqueness of our country identified in our founding document, Te Tiriti o Waitangi. We uphold our responsibility(s) to the founding document and acknowledge Māori as the Tangata Whenua/Indigenous people.

• Our shared values are at the heart of everything we do. Living these values, including ‘Manaaki/taking care of each other’ and ‘Hāpai tangata/fostering inclusion’, is essential to ensuring everyone feels included at work and able to reach their full potential. Our values drive our desire to create positive outcomes for our clients, communities, and people.

• Deloitte Talent Experience

• We hold a simple belief – that our people’s hard work should be recognised and rewarded beyond their remuneration. We have reimagined what ‘work’ looks like and how we can empower all our people to create a work experience that is distinct to their needs. Founded on concepts of trust, balance, wellbeing, and the importance of personal connection, this is the Deloitte experience.

We offer:

• Flexible work arrangements – work in a way that suits you, us and our clients best

• Subsidised professional qualifications and paid professional memberships

• Subsidised health insurance

• Income protection insurance

• 22 days annual leave

• Social events, social sports teams, and monthly firm drinks

• A focus on wellness and well-being

• Community focused volunteer days

• A focus on the environment and sustainability

• We believe the strongest teams are made up of diverse individuals and we are proud to be an equal opportunities employer. We recognise that women and individuals from under-represented backgrounds may hesitate to apply if they don't meet all criteria. If you're passionate about this role and believe you have the skills, we encourage you to apply, even if your experience, ideal working hours or qualifications aren't a perfect match.