Snowflake Data Engineer

About Deloitte

At Deloitte, we embrace individuality and value curiosity, passion, and the drive to work with talented people on meaningful projects. We seek individuals eager to make a significant impact.

Role Overview

This opportunity is for a motivated and seasoned Snowflake Data Engineer to join our expanding AI & Data team. The role is perfect for those passionate about cutting-edge data engineering, eager to tackle challenging technical problems, and enthusiastic about leveraging AI-assisted engineering tools for faster and more intelligent delivery.

Key Responsibilities

• Create, develop, and sustain scalable cloud data solutions utilizing Snowflake and modern data engineering technologies.
• Manage the full lifecycle of data engineering tasks including data ingestion, transformation, modelling, automation, deployment, optimization, and production support.
• Construct robust ETL/ELT pipelines for both structured and semi-structured data.
• Design dimensional and analytical data models to support reporting, analytics, and AI applications.
• Develop data ingestion mechanisms integrating Snowflake with cloud platforms, APIs, databases, files, and other enterprise data sources.
• Establish automated CI/CD pipelines and apply contemporary DevOps methodologies for Snowflake deployments.
• Utilize cloud platforms such as Azure and/or AWS in solution development.
• Implement strong role-based access control (RBAC), security protocols, data governance, quality assurance, and monitoring.
• Optimize Snowflake workloads to ensure high performance, scalability, reliability, and cost-efficiency.
• Diagnose and resolve complex issues in data pipelines and platform environments both in development and production.
• Collaborate with architects, analysts, engineers, and stakeholders to turn requirements into effective technical solutions.
• Contribute to engineering standards, reusable patterns, documentation, and continuous enhancement efforts.
• Leverage AI development tools such as CoCo and GitHub Copilot for solution design, coding, testing, code review, troubleshooting, and documentation.
• Identify and implement AI and automation opportunities to streamline engineering efforts and accelerate delivery cycles.

Required Qualifications and Skills

• Extensive hands-on experience with Snowflake and advanced SQL development.
• Proven background in designing and building cloud-based ETL/ELT pipelines and data platforms.
• Solid knowledge of data warehousing concepts, data modelling, and modern data engineering best practices.
• In-depth understanding of Snowflake features including databases, schemas, warehouses, stages, streams, tasks, roles, and performance tuning.
• Familiarity with orchestration and transformation tools such as Azure Data Factory, dbt, Airflow, or similar is advantageous.
• Experience using Git, continuous integration/delivery tools, and software engineering best practices.
• Python programming experience is a plus.
• Awareness of infrastructure-as-code methodologies.
• Strong analytical and problem-solving capabilities.
• Excellent communication skills enabling effective teamwork with both technical and non-technical collaborators.
• A proactive AI-driven engineering approach, confidently incorporating tools like CoCo and GitHub Copilot to enhance development speed and quality.
• Ability to exercise sound judgment with AI-generated outputs, focusing on security, maintainability, accuracy, and engineering standards.

Success Profile

Ideal candidates take initiative in managing data engineering challenges from concept to production. They prioritize building scalable, maintainable, secure, and automated solutions with strong engineering principles. Comfort working within diverse cloud data ecosystems and enthusiasm for continuous improvement through automation, reusable patterns, and AI-assisted tools is essential. A mix of technical expertise alongside a delivery-oriented mindset and commitment to ongoing enhancement defines success.

Why Join Deloitte?

• Engage with leading New Zealand companies on innovative projects.
• Work on extensive, modern Snowflake data platform deployments.
• Tackle real-world, complex data engineering problems.
• Gain experience spanning data engineering, cloud technologies, analytics, governance, and AI.
• Adopt modern engineering methods and AI-augmented development practices.
• Collaborate with seasoned data engineers, architects, and technology leaders.
• Contribute to reusable solutions and engineering standards enhancing data platform delivery.
• Exposure to a variety of progressive data technologies.

Additional Information

Deloitte in Aotearoa is committed to creating impactful solutions supported by robust global leadership. We honor the unique cultural heritage of New Zealand, acknowledging Māori as the Indigenous people and upholding responsibilities to Te Tiriti o Waitangi. Our core values emphasize care, inclusion, and enabling everyone to reach their potential, fostering positive outcomes for clients, communities, and personnel alike.

We value our people's contributions beyond remuneration by promoting trust, wellbeing, balance, and personal connection, offering flexible work options, subsidized qualifications and memberships, health and income protection insurances, 22 annual leave days, social engagements, volunteer opportunities, and sustainability initiatives.

We champion diversity, encouraging women and under-represented groups to apply even if qualifications or experience do not perfectly align. Applicants are advised to be vigilant of phishing scams and verify communications using official Deloitte digital domains.