Snowflake Architect

Cognizant Technology Solutions Corporation; Missouri; On-site; USD 140,000 - 200,000; Full time

Job summary

Cognizant Technology Solutions Corporation in the United States seeks an experienced Snowflake Architect to design, build, and optimize scalable cloud data platforms using Snowflake. The role emphasizes hands-on architecture, data modeling, performance tuning, security, and seamless cloud integration.

You will lead the migration of legacy data platforms to Snowflake, design ETL/ELT pipelines with Informatica, dbt, Matillion, or Fivetran, and guide data engineering teams toward standardized

Qualifications

• 8+ years of data engineering or data architecture experience.
• Expertise in Snowflake architecture, admin, performance tuning, and cost optimization.
• Advanced SQL and data warehousing knowledge.
• Hands-on ETL/ELT pipeline development experience.
• Experience with AWS, Azure, or GCP.
• Strong understanding of data governance and security (RBAC, masking).
• Ability to translate business requirements into scalable architectures.

Responsibilities

• Architect and implement enterprise-scale Snowflake data platforms.
• Design scalable data warehouse, data lake, and lakehouse architectures.
• Lead migration of legacy/on-prem data platforms to Snowflake.
• Design and optimize ETL/ELT pipelines using Informatica, dbt, Matillion, Fivetran.
• Implement Snowflake capabilities such as Snowpipe, Time Travel, and secure data sharing.
• Collaborate with business and analytics teams to set technical roadmaps.
• Define architecture standards and reusable frameworks.

Skills

Snowflake architecture

SQL

Data modeling

ETL/ELT pipelines

Cloud platforms AWS/Azure/GCP

Data governance & security

Stakeholder collaboration

Tools

Informatica

dbt

Matillion

Fivetran

Job description

We are looking for an experienced Snowflake Architect to design, build, and optimize scalable cloud data platforms using Snowflake. The ideal candidate will have strong hands-on experience with Snowflake architecture, data modeling, performance optimization, security, and integration with modern cloud and data engineering ecosystems.

Key Responsibilities

• Architect and implement enterprise-scale Snowflake data platforms, including databases, schemas, warehouses, roles, and resource monitors.
• Design scalable data warehouse, data lake, and lakehouse architectures using Snowflake.
• Lead migration of legacy/on-prem data platforms such as Teradata, Oracle, SQL Server, Hadoop, or similar technologies to Snowflake.
• Design and optimize ETL/ELT pipelines using tools such as Informatica, dbt, Matillion, Fivetran, or cloud-native services.
• Implement advanced Snowflake capabilities such as Snowpipe, Streams, Tasks, Dynamic Tables, Time Travel, zero-copy cloning, secure data sharing, and Snowpark.
• Optimize queries, warehouse sizing, clustering, storage, concurrency, and overall Snowflake performance and cost.
• Establish security architecture including RBAC, masking policies, row access policies, encryption, SSO, and governance controls.
• Integrate Snowflake with AWS, Azure, or GCP and downstream BI/analytics platforms.
• Define architecture standards, reusable frameworks, best practices, and technical roadmaps.
• Provide technical leadership to data engineering teams and collaborate with business, analytics, security, and cloud stakeholders.

Required Skills

• 8+ years of overall data engineering/data architecture experience, with significant hands-on Snowflake experience.
• Strong expertise in Snowflake architecture, administration, performance tuning, and cost optimization.
• Advanced SQL and strong understanding of data modeling and data warehousing.
• Hands-on experience building complex ETL/ELT and data ingestion pipelines.
• Experience with at least one major cloud platform: AWS, Azure, or GCP.
• Strong understanding of data governance, security, RBAC, and enterprise data architecture.
• Ability to work directly with business and technology stakeholders and translate requirements into scalable technical architecture.