Consultant/Senior Consultant, Snowflake Engineer, Snowflake Transformation & Growth, Engineering, AI & Data, Technology & Transformation

Connect to your Industry

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’s how we approach the thousands of decisions we make every day. How we behave, our beliefs and our attitudes. In other words: our values. Whatever we do, wherever we are in the world, we lead the way, serve with integrity, take care of each other, foster inclusion, and collaborate for measurable impact. These five shared values lead every decision we make and action we take, guiding us to deliver impact how and where it matters most.

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, and range of experiences that Deloitte offers is what sets this firm apart. In Technology & Transformation, Deloitte is far ahead of any of our immediate competitors.” - Sophia, Technology & Transformation

“What attracted me to Deloitte were the endless opportunities and the collective experience of other like-minded individuals. Deloitte’s clients include many of the world’s largest organisations; I wanted to be part of a team that made a difference that I could be proud of.” - Dan, Technology & Transformation

Our hybrid working policy

You’ll be based in London with hybrid working.

At Deloitte we understand the importance of balancing your career alongside your home life. That’s why we’ll support you to work flexibly through our hybrid working policy. Depending on the requirements of your role, you’ll have the opportunity to work in your local office, virtual collaboration spaces, client sites and remotely. You’ll get the chance to meet face to face when needed, while you collaborate and learn from colleagues, share your experiences, and build the relationships that will fuel your career and prioritise your wellbeing. Please check with your recruiter for the specific working requirements that may apply for your role.

Our commitment to you

Making an impact is more than just what we do: it’s why we’re here. So we work hard to create an environment where you can experience a purpose you believe in, the freedom to be you, and the capacity to go further than ever before.

We want you. The true you. Your own strengths, perspective and personality. So we’re nurturing a culture where everyone belongs, feels supported and heard, and is empowered to make a valuable, personal contribution. You can be sure we’ll take your wellbeing seriously, too. Because it’s only when you’re comfortable and at your best that you can make the kind of impact you, and we, live for.

Your expertise is our capability, so we’ll make sure it never stops growing. Whether it’s from the complex work you do, or the people you collaborate with, you’ll learn every day. Through world-class development, you’ll gain invaluable technical and personal skills. Whatever your level, you’ll learn how to lead.

Connect to your next step

A career at Deloitte is an opportunity to develop in any direction you choose. Join us and you’ll experience a purpose you can believe in and an impact you can see. You’ll be free to bring your true self to work every day. And you’ll never stop growing, whatever your level.

Discover more reasons to connect with us, our people and purpose-driven culture at deloitte.co.uk/careers