Snowflake Architect

Cognizant; Dallas (TX); On-site; USD 90,000 - 160,000; Full time

Benefits offered by this job

Medical/Dental/Vision/Life Insurance

Paid holidays + Paid Time Off

401(k) plan and contributions

Long-term/Short-term Disability

Paid Parental Leave

Employee Stock Purchase Plan

Job summary

Cognizant is seeking an experienced Snowflake Architect/DBT to design and optimize scalable data solutions on the Snowflake Data Cloud platform. You will lead end-to-end data pipelines, modeling, and governance to support analytics and reporting.

The role requires deep expertise in cloud data architecture, ELT/ETL pipelines, and performance tuning, with strong business acumen to translate data needs into robust solutions.

Qualifications

• Experience designing and implementing Snowflake-based architectures for data warehousing.
• Proficient in dbt, ETL/ELT pipelines, and data governance.
• Strong communication with business stakeholders and BI teams.

Responsibilities

• Design and architect end-to-end data solutions leveraging Snowflake, ensuring scalability, performance, and security.
• Define and implement data models optimized for analytics and reporting.
• Build and optimize data ingestion and transformation pipelines using tools such as Snowpipe, dbt, Informatica, or similar.
• Lead Snowflake platform setup, including account structure and RBAC security governance.
• Optimize query performance, cost management, and warehouse sizing within Snowflake.
• Establish data governance, data quality, and metadata management frameworks.
• Collaborate with business stakeholders, data engineers, and BI teams to deliver data-driven solutions.
• Provide guidance and best practices on data integration; monitor system performance and troubleshoot data-related issues.

Skills

Snowflake Architecture

DBT

SQL Optimization

ETL/ELT Tools

Data Modeling

CI/CD in Data

Data Governance

Cloud Platforms

Data Lakes

Security & Compliance

Tools

Informatica

Talend

Matillion

Azure Data Factory

dbt

Snowpipe

Job description

Role Overview

We are seeking an experienced Snowflake Architect/DBT to design, implement, and optimize scalable data solutions on the Snowflake Data Cloud platform. The ideal candidate will have deep expertise in cloud data architecture, data warehousing, ELT/ETL pipelines, and performance tuning, along with strong business acumen to translate data requirements into robust solutions.

• Design and architect end-to-end data solutions leveraging Snowflake, ensuring scalability, performance, and security
• Define and implement data models (dimensional & normalized) optimized for analytics and reporting
• Build and optimize data ingestion and transformation pipelines using tools such as Snowpipe, dbt, Informatica, or similar
• Lead Snowflake platform setup, including
• Account structure
• Role-based access control (RBAC)Security & governance
• Optimize query performance, cost management, and warehouse sizing within Snowflake
• Establish data governance, data quality, and metadata management frameworks
• Collaborate with business stakeholders, data engineers, and BI teams to deliver data-driven solutions
• Provide guidance and best practices on :
• Data integration
• Monitor system performance and troubleshoot data-related issues
• Stay updated with Snowflake features and recommend improvement

Role Overview

We are seeking an experienced Snowflake Architect/DBT to design, implement, and optimize scalable data solutions on the Snowflake Data Cloud platform. The ideal candidate will have deep expertise in cloud data architecture, data warehousing, ELT/ETL pipelines, and performance tuning, along with strong business acumen to translate data requirements into robust solutions.

Key Responsibilities

• Design and architect end-to-end data solutions leveraging Snowflake, ensuring scalability, performance, and security
• Define and implement data models (dimensional & normalized) optimized for analytics and reporting
• Build and optimize data ingestion and transformation pipelines using tools such as Snowpipe, dbt, Informatica, or similar
• Lead Snowflake platform setup, including
• Account structure
• Role-based access control (RBAC)Security & governance
• Optimize query performance, cost management, and warehouse sizing within Snowflake
• Establish data governance, data quality, and metadata management frameworks
• Collaborate with business stakeholders, data engineers, and BI teams to deliver data-driven solutions
• Provide guidance and best practices on :
• Data integration
• Monitor system performance and troubleshoot data-related issues
• Stay updated with Snowflake features and recommend improvement

Required Skills & Qualifications

Technical Skill

• Strong expertise in Snowflake Data Cloud architecture and administration
• Must have DBT
• Experience with cloud platforms: AWS / Azure / GC
• Proficiency in SQL and advanced query optimization technique
• Hands-on experience with ETL/ELT tools (Informatica, Talend, dbt, Matillion, Azure Data Factory, etc.)
• Knowledge of data modeling techniques (Star Schema, Snowflake Schema, Data Vault)
• Experience with data lakes and hybrid architectures
• Familiarity with data governance, security, and compliance frameworks
• Experience with CI/CD pipelines and DevOps practices in data environments

Preferred Skills

• Snowflake certifications (e.g., SnowPro Advanced Architect)
• Experience with streaming technologies (Kafka, Kinesis)
• Knowledge of Python / PySpark / Scala
• Exposure to BI tools such as Power BI, Tableau, Looker
• Experience working in Agile/Scrum environments

Soft Skills

• Strong problem-solving and analytical skills
• Excellent communication and stakeholder management
• Ability to lead architectural discussions and mentor teams
• Strategic thinking with attention to detail
• Please note this role is not able to offer visa transfer or sponsorship now or in the future*

We're excited to meet people who share our mission and who can make an impact in a variety of ways. Think about your transferable experiences and unique skills that make you stand out.

Salary And Other Compensation

Applications will be accepted until Oct 16, 2026,

The annual salary for this position is between $ 90,000 - $ 160,000 depending on experience and other qualifications of the successful candidate.

This position is also eligible for Cognizant’s discretionary annual incentive program, based on performance and subject to the terms of Cognizant’s applicable plans.

Benefits: Cognizant offers the following benefits for this position, subject to applicable eligibility requirements:

• 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

Disclaimer: The salary, other compensation, and benefits 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.