Lead Snowflake Architect & DBT for Scalable Analytics

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

Benefits offered by this job

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

Job summary

Cognizant in Dallas is seeking an experienced Snowflake Architect/DBT to design, implement, and optimize scalable data solutions on the Snowflake Data Cloud. You will architect end-to-end data platforms, build robust ingestion/ETL pipelines, and drive governance and security across analytics workloads.

The role requires deep expertise in Snowflake, DBT, SQL optimization, and modern data tooling. You will collaborate with stakeholders and data teams to deliver data-driven insights and ensure

Qualifications

• 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 techniques.
• 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

Responsibilities

• Design 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 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 architecture, data integration, data lifecycle management.
• Monitor system performance and troubleshoot data-related issues.
• Stay updated with Snowflake features and recommend improvements.

Skills

Snowflake architecture

DBT

SQL optimization

ETL/ELT tools

CI/CD data pipelines

Data governance

Security & RBAC

Tools

Snowpipe

Informatica

Talend

dbt tooling

Azure/AWS/GCP

Job description

Cognizant in Dallas is seeking an experienced Snowflake Architect/DBT to design, implement, and optimize scalable data solutions on the Snowflake Data Cloud. You will architect end-to-end data platforms, build robust ingestion/ETL pipelines, and drive governance and security across analytics workloads.

The role requires deep expertise in Snowflake, DBT, SQL optimization, and modern data tooling. You will collaborate with stakeholders and data teams to deliver data-driven insights and ensure