Lead Snowflake DBT(Hybrid)

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

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 architecture
• Data integration
• Data lifecycle management
• 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

Salary and Other Compensation:

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