Job Description, Responsibilities & Requirements
About the Position
We are seeking a Lead Data Migration Architect with deep expertise in Snowflake and enterprise data modernization to lead large-scale migration programs from legacy platforms including SQL Server, DB2, and AS/400. This role will define target-state Snowflake architectures, migration strategies, reconciliation frameworks, and modernization roadmaps. The architect will leverage AI-powered accelerators, including Gemini Enterprise, to automate schema conversion, data transformation, validation, and migration processes. The ideal candidate combines strong Snowflake platform expertise with hands-on experience delivering complex migration and modernization initiatives.
Responsibilities
- Define and lead enterprise data migration strategies from SQL Server, DB2, and AS/400 platforms to Snowflake.
- Architect scalable Snowflake data platforms including data warehousing, ingestion, transformation, governance, and analytics layers.
- Design migration factory frameworks with reusable patterns, automation pipelines, migration waves, and industrialized delivery processes.
- Develop data migration, reconciliation, validation, and data quality frameworks to ensure migration accuracy and completeness.
- Lead schema mapping, data type conversion, and transformation design between legacy databases and Snowflake.
- Optimize Snowflake performance through clustering, partitioning, query tuning, workload management, and cost optimization.
- Leverage Gemini Enterprise to accelerate metadata discovery, schema conversion, data quality validation, reconciliation, and migration documentation.
- Collaborate with data engineers, application architects, DBAs, and business stakeholders to execute modernization programs.
- Establish governance, lineage, auditability, and operational standards across migration initiatives.
- Provide technical leadership, mentor teams, and drive adoption of Snowflake best practices and modern data architecture patterns.
Requirements
- 10+ years of experience in data architecture, data migration, or enterprise modernization programs.
- Strong hands-on experience with Snowflake architecture, data modeling, performance optimization, and administration.
- Expertise in migrating data from legacy platforms such as SQL Server, DB2 (LUW/iSeries), and AS/400 into Snowflake.
- Experience designing large-scale migration factories, automation frameworks, and industrialized migration processes.
- Strong understanding of Snowflake capabilities including Snowpipe, Tasks, Streams, Time Travel, Data Sharing, and Native Apps.
- Expertise in data quality engineering, reconciliation frameworks, metadata management, lineage, and governance.
- Experience with ETL/ELT tools such as dbt, Informatica, Matillion, Fivetran, or similar data integration platforms.
- Familiarity with cloud ecosystems (AWS, Azure, or GCP) and modern data lake/lakehouse architectures.
- Experience leveraging AI-assisted tools such as Gemini Enterprise for migration acceleration and automation.
- Strong communication, stakeholder management, and technical leadership skills.
We Offer
- Competitive salary between $137,500 - $161,500 depending on experience and other qualifications.
- Cognizant’s discretionary annual incentive program, based on performance.
- Medical/Dental/Vision/Life Insurance
- Paid holidays plus Paid Time Off
- 401(k) plan and contributions
- Long-term/Short-term Disability
- Paid Parental Leave
- Employee Stock Purchase Plan
About the Company
Cognizant (Nasdaq: CTSH) is an AI Builder and technology services provider, bridging the gap 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, drive tangible outcomes and keep global enterprises ahead in a fast-changing world. See how at cognizant.ai or follow us on Twitter.
Application Information
Applications will be accepted until 8 Jul 2026.
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.
Benefits that help you thrive and grow
Our benefits program is built with you in mind-so you can enjoy a fulfilling, balanced, and healthy life.
Financial wellbeing
We regularly review market data to ensure compensation reflects the value you bring. Your benefits extend beyond pay and may include retirement plans, financial education, etc.
Physical and mental health
We empower you to prioritize your wellbeing through paid time off, flexible working where possible, healthcare plans, counselling, our Mental Health Allyship program, and more.
Your career, your way
With 350,000+ roles at Cognizant, you’ll have opportunities to explore new technologies, industries, and locations-and build the skills you need to grow your career.
Real-world impact
Think about the biggest brands you rely on. Chances are, they rely on us to help strengthen their business. Here, you’ll turn bold ideas into solutions that improve lives everywhere.
Your path to Cognizant
Here’s what you can expect from our hiring process. Please keep in mind that it may vary by role and location. Explore our FAQs to learn more.
Step 1: Apply to the right opportunity
Find an open role that matches your skills and career goals and show us why you’re the person for the job. Don’t see the right opportunity? Consider joining our Talent Community.
Step 2: Connect with your recruiter
If one of our recruiters sees a fit, they’ll set up a short intro call to learn more about you and how your experiences and skills match the role.
Step 3: Show off your skills
If you and our team would like to continue the process, you’ll interview with our hiring team. Some roles may also require technical assessments and/or client interviews.
Step 4: Decision time
Our team will then review each candidate’s potential to succeed in the role. This step may take some time because we want to find the right fit for both you and us-but you can count on us to keep you updated.