Snowflake Developer

Description

Summary: As a Senior Snowflake Engineer, you will lead a high-impact, client-facing role driving a full migration from Teradata to Snowflake for a top-tier Scandinavian bank. Highlights: 1. Leading ambitious data modernization in financial sector 2. High-impact, client-facing role in a fast-paced environment 3. Opportunity for learning & growth with latest technologies As a Senior Snowflake Engineer, you will play a leading role in one of the most ambitious data modernisation programmes in the financial sector — driving the full migration from Teradata to Snowflake for a top\-tier Scandinavian bank. Come and transform the future with us. HIGH QUALITY PROJECTS \| LATEST TECHNOLOGIES \| REMOTE WITHIN SPAIN \| LEARNING \& GROWTH ABOUT THE ROLE We are looking for a Senior Snowflake Engineer to lead the design, build and delivery of our client's Teradata\-to\-Snowflake migration. You will own end\-to\-end pipeline architecture using IDMC, optimise performance and cost at scale, and ensure data quality, security and governance across the programme. This is a high\-impact, client\-facing role within a fast\-paced, cross\-functional delivery team operating in the BFSI domain. KEY RESPONSIBILITIES * Lead the Teradata → Snowflake migration lifecycle: assessment, planning, execution and cutover readiness. * Design Snowflake data models and objects; architect and build ETL/ELT pipelines using IDMC (preferred). * Optimise performance and cost: warehouse sizing, clustering/partitioning and query tuning. * Implement Snowflake capabilities including Snowpipe, Streams/Tasks and Time Travel. * Manage secure access: RBAC, encryption, storage integrations and external stages. * Rewrite and optimise Teradata SQL; convert Teradata\-specific functions to Snowflake equivalents. * Automate operational tasks using Python and/or Shell scripting. * Perform source\-to\-target data reconciliation and validate transformation logic. * Document solutions, data flows and design decisions; communicate progress to stakeholders. REQUIRED SKILLS \& EXPERIENCE * Strong Snowflake architecture expertise and hands\-on SQL skills (performance tuning and optimisation). * Proven Teradata SQL knowledge including utilities, functions and migration/conversion experience. * Solid background in data warehousing and ETL/ELT design; hands\-on IDMC experience preferred. * Deep knowledge of Snowflake features: Snowpipe, Streams/Tasks, Time Travel/Cloning, micro\-partitions, stages, file formats and RBAC. * Cloud platform experience: Azure, AWS or GCP. * Scripting proficiency in Python and/or Shell for automation and pipeline support. * CI/CD and DevOps practices applied to data pipelines. **Nice to have:** * BFSI domain experience. * Informatica PowerCenter background. * SnowPro certification.