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.
About us
Cognizant (Nasdaq: CTSH) is an AI Builder and technology services provider, building the bridge between AI investment and enterprise value by building full-stack AI solutions for our clients. Our deep industry, process and engineering expertise enables us to build an organization’s unique context into technology systems that amplify human potential, realize tangible returns and keep global enterprises ahead in a fast-changing world. See how at www.cognizant.com or @cognizant.
Additional employment information
Compensation information is accurate as of the date of this posting. Cognizant reserves the right to modify this information at any time, subject to applicable law.
Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview.
Cognizant is an equal opportunity employer. Your application and candidacy will not be considered based on race, color, sex, religion, creed, sexual orientation, gender identity, national origin, disability, genetic information, pregnancy, veteran status or any other characteristic protected by federal, state or local laws.
If you have a disability that requires reasonable accommodation to search for a job opening or submit an application, please email [email protected] with your request and contact information.
