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.