Snowflake Data Engineer

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

Please be aware of phishing attempts posing as Deloitte recruiters. Official communications from Deloitte New Zealand will come from “@deloitte.co.nz,” “@smartrecruiters.com,” or our video interview platform Deloitte<[email protected]>. If you receive a suspicious email, verify its authenticity by contacting us at [email protected].