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.
Language requirements vary depending on roles, but we ask that all candidates have basic English proficiency for company-wide communications purposes. For roles based in Quebec, professional English proficiency is required, as you’ll deliver services to and collaborate with stakeholders outside the province who may not speak French.
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, provincial 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.
