Snowflake Developer

Cognizant
Municipality of Madrid, Spain
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English

Job location

Municipality of Madrid, Spain

Tech stack

Continuous Integration
ETL
Data Migration
Data Systems
Database Queries
DevOps
Python
Performance Tuning
Query Optimization
Role-Based Access Control
Simple Data Format
SQL Stored Procedures
SQL Databases
Teradata
Scripting (Bash/Python/Go/Ruby)
Snowflake
Build Management
Data Pipelines

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.

Apply for this position