Snowflake Developer
Role details
Job location
Tech stack
Job description
We are seeking a Snowflake Engineer to design, build and maintain ETL/ELT pipelines and Snowflake objects as part of a strategic Teradata-to-Snowflake migration programme for a leading Nordic bank. Working alongside senior architects and business analysts, you will translate business requirements into robust data solutions and ensure performance, quality and security standards are met throughout delivery., · Design and build ETL/ELT pipelines and Snowflake objects using Snowflake and IDMC.
· Create and maintain Snowflake tables, views, schemas, stages, stored procedures and data models.
· Translate business requirements into Snowflake/IDMC technical solutions.
· Tune performance and cost: warehouse sizing, clustering/partitioning and query optimisation.
· Implement Snowflake features: Snowpipe, Streams/Tasks, Time Travel/Cloning; manage integrations, stages and file formats.
· Perform data reconciliation and ensure data quality, RBAC compliance and access control.
· Support batch and incremental load strategies across the migration pipeline.
Requirements
· Hands-on Snowflake experience: architecture, SQL, object creation and performance tuning.
· Knowledge of Snowflake features: Snowpipe, Streams/Tasks, Time Travel/Cloning, micro-partitions, external stages, file formats and RBAC.
· ETL/ELT and data migration experience; IDMC preferred.
· Strong SQL skills; familiarity with Teradata utilities and conversion of Teradata functions to Snowflake equivalents.
· Scripting/automation experience with Python and/or Shell.
· Exposure to CI/CD and DevOps practices for data pipelines.
Nice to have:
· SnowPro certification.
· BFSI domain experience.