Consultant or Senior Consultant, Snowflake Engineer

Do you want to be at the heart of some of the biggest and most ambitious AI & Data projects?

Technology & Transformation: How do you make intelligent, future-proof decisions in a world where change is the one constant? That's exactly what you'll help our clients do. You'll build trusted relationships with business stakeholders - and use the most exciting new technologies available - to create data-driven programmes that transform their organisations.

Your advice will help clients position their organisations to succeed in an ever-evolving marketplace.

As a Snowflake Engineer, you'll design, build and optimise scalable data and AI-ready solutions on the Snowflake Data Cloud, helping clients modernise their data platforms and create trusted foundations for analytics, machine learning and emerging AI capabilities.

We're looking for practitioners with strong data engineering fundamentals, hands-on Snowflake experience and a passion for building scalable, secure and high-performance cloud data solutions.

Connect to your career at Deloitte Deloitte drives progress. Using our vast range of expertise, we help our clients' become leaders wherever they choose to compete. To do this, we invest in outstanding people. We build teams of future thinkers, with diverse talents and backgrounds, and empower them all to reach for and achieve more.

What brings us all together at Deloitte?It'show we approach the thousands of decisions we make everyday. How we behave, our beliefs and our attitudes. In other words: our values. Whatever we do, whereverwe arein the world, welead the way,serve with integrity, take care of each other ,fosterinclusion, andcollaborate for measurable impact. These five shared values lead every decision wemake and action we take, guiding us to deliver impact how and where it mattersmost .

Connect to your opportunity We are seeking Snowflake Engineers to join the Snowflake Transformation & Growth team, a centre of excellence within Deloitte's Engineering, AI & Data service offering. You will work with clients, third parties and Deloitte teams on high-impact transformation programmes, including integrations and legacy data migrations. You will develop your Snowflake expertise while working with experienced multidisciplinary teams and communicating with both technical and business users.

You will apply Snowflake data engineering skills to build analytics and AI-ready data products, translating defined business and technical requirements into reliable, scalable solutions that create trusted data foundations.

Your role As a Snowflake Engineer, you will solve our clients' most challenging business problems by applying advanced data engineering techniques to design, deliver and operate robust and cutting-edge solutions. In this role, you may be expected to:

• Stakeholder engagement: Work with technical stakeholders and delivery leads to understand requirements and deliver data pipelines aligned with agreed architecture and designs.
• Data models: Develop and implement physical data models covering data acquisition, preprocessing, ETL/ELT integrations and deployment.
• Data migration: Support the development and operation of migration activities for legacy on-premise systems, with a focus on scale, efficiency and reliability.
• Technology assessment: Evaluate Snowflake technologies and integrate relevant changes into client solutions and internal frameworks.
• Delivery practices: Contribute to knowledge sharing, reusable code and CI/CD practices across sprint teams.
• Design, build, test and deploy scalable batch and near-real-time data pipelines, reusable data products and analytics solutions on Snowflake using SQL, Python, Snowpark, Snowpipe, Streams, Tasks and Dynamic Tables.
• Deliver across the full data engineering lifecycle, from requirements analysis and solution design through development, testing, deployment, operational readiness and continuous improvement.
• Work with clients and stakeholders to understand business, data and technical requirements, participate in design workshops and contribute to practical solution options.
• Communicate solution choices, trade-offs, dependencies and recommendations clearly to technical and non-technical audiences.
• Design and implement robust data models and ETL/ELT patterns that support enterprise reporting, analytics, machine learning and AI use cases.
• Optimise assigned pipelines and Snowflake workloads for performance, reliability, scalability and cost, escalating engineering risks and implementing agreed mitigations.
• Embed security, role-based access control, governance, lineage and data quality into solutions, using Snowflake capabilities such as masking policies, secure data sharing, account usage views and governance controls.
• Enable analytics, machine learning and AI solutions by preparing trusted, governed and reusable datasets and integrating data products with downstream applications.
• Apply modern engineering practices including version control, automated testing, CI/CD, infrastructure as code, monitoring and data observability.
• Produce and maintain clear technical artefacts including data models, interface specifications, deployment documentation and operational runbooks.
• Contribute to technical reviews, reusable engineering standards and quality assurance, and share knowledge with colleagues across delivery teams.

Connect to your skills and professional experience We are looking for candidates who can demonstrate the following education, experience and technical skills:

Overall, you are a curious and hands-on problem solver who enjoys collaborating to solve complex data challenges. You bring a pragmatic approach to delivering high-quality solutions and can explain technical decisions clearly to different audiences.

Education & Experience

• Bachelor's degree in a technical or quantitative field, or equivalent.
• Experience contributing to the delivery of data solutions, ideally in production environments.
• Experience delivering data programmes in regulated or data-rich industries.
• SnowPro Core certification is mandatory.
• Experience working with business and technical stakeholders to gather requirements and communicate delivery progress or solution approaches.
• Strong analytical, problem-solving and troubleshooting skills.

Technical proficiency

• Experience developing or supporting cloud data warehouses using Snowflake and at least one of AWS, Azure or GCP.
• Proficiency in SQL, Python, data stack frameworks, integration libraries and orchestration tools, including Snowpark, Snowpipe, Streams, Tasks and Dynamic Tables.
• Knowledge of Snowflake architecture, stages, file formats, virtual warehouse configuration, secure data sharing, role-based access control, Time Travel, cloning and replication.
• Experience with query optimisation, query profiles, clustering, warehouse configuration, resource monitors and account usage views.
• Experience with CI/CD, version control, infrastructure as code, automated testing and coding guardrails.
• Ability to explain technical concepts clearly and adapt communication for different audiences.
• Ability to build solutions using Snowflake Cortex Code.
• Strong understanding of data modelling principles for analytics, reporting, machine learning and AI use cases.
• Experience applying modern engineering practices including automated testing, infrastructure as code, monitoring and data observability.
• Knowledge of cloud-native security, governance and access management practices across Snowflake and the relevant cloud platform.
• Experience enabling AI-ready workloads using governed Snowflake data products and relevant Snowflake AI capabilities, where appropriate to the solution.
• Experience with orchestration technologies and cloud integration services.
• Exposure to DevOps (or similar tools), platform automation and infrastructure-as-code tools such as Terraform.

Connect to your business - Technology and Transformation Distinctive thinking, deep expertise, innovation and collaborative working. That's what connects us. That's what makes us Deloitte. If you want to help solve some of the biggest tech and transformational challenges around, join us. Together, we'll make an impact that matters.

Engineering, AI and Data We lead transformation at the heart of our clients; re-engineering the core of our clients' organisations, helping to unleash growth, and creating better futures for their customers, citizens and employees.

Personal independence Regulation and controls are standard practice in our industry and Deloitte is no exception. These controls provide important legal protection for both you and the firm. We are subject to a number of audit regulations, one of which requires that certain colleagues abide by specific personal independence constraints (e.g., in relation to any financial interests and employment relationships). This can mean that you and your "Immediate Family Members" are not permitted to hold certain financial interests (shares, funds, bonds etc.) with audit clients of the firm, and also prohibitions on certain employment relationships (e.g., you are not permitted to hold a secondary employment role with SEC audit clients of the firm whilst being employed by the firm). The recruitment team will provide further detail as you progress through the recruitment process or you can contact the Independence team upon request.

Connect with your colleagues "The great culture, flexibility . click apply for full job details