Snowflake Data Architect — Cloud ETL & Analytics

Cognizant; Olympia (WA); On-site; USD 116,000 - 136,000; Full time

Benefits offered by this job

Medical Insurance

Dental Insurance

Vision Insurance

Life Insurance

Paid Holidays

Paid Time Off

401(k) Plan

Disability Insurance

Parental Leave

Employee Stock Purchase Plan

Job summary

Cognizant is seeking a Data Engineer to build scalable data pipelines in Snowflake and AWS, focusing on Life Sciences. You will develop ETL/ELT workflows, implement DBT models, and collaborate across teams to deliver data-driven insights.

The role emphasizes data quality, governance, and leveraging cloud-native services. Strong scripting, modeling, and CI/CD practices are essential for success.

Qualifications

• Strong hands-on experience with Snowflake Data Warehouse.
• Expertise in AWS Cloud Services and cloud-based data architecture.
• Experience with DBT for data transformation and modeling.
• Proficiency in Python and PySpark for data processing and automation.
• Strong understanding of ETL/ELT frameworks, data integration, and pipeline orchestration.
• Experience with Unix/Linux scripting and environment management.
• Knowledge of SQL optimization, data modeling, and database design.
• Familiarity with CI/CD practices and version control tools such as Git.

Responsibilities

• Design, develop, and maintain scalable data pipelines using Snowflake, AWS, Python, and PySpark.
• Build and optimize ETL/ELT processes for ingesting, transforming, and loading data from multiple source systems.
• Develop data transformation models using DBT and implement best practices for data quality and governance.
• Work with AWS services such as S3, Glue, Lambda, EMR, Redshift, and other cloud-native data services.
• Design and support data warehousing solutions in Snowflake, including schema design, performance tuning, and optimization.
• Monitor and troubleshoot data workflows, ensuring reliability, accuracy, and timely delivery.
• Collaborate with business stakeholders, data analysts, and application teams to understand data requirements and implement solutions.
• Participate in data migration and modernization initiatives within Life Sciences environments.
• Develop and maintain technical documentation, data flow diagrams, and operational procedures.
• Ensure compliance with security, regulatory, and data governance standards applicable to Life Sciences organizations.

Skills

Snowflake Data Warehouse

AWS Cloud Services

DBT

Python

PySpark

Unix/Linux scripting

SQL optimization

Data modeling

CI/CD practices

Git

Tools

Snowflake

AWS

DBT

Python

Job description

Cognizant is seeking a Data Engineer to build scalable data pipelines in Snowflake and AWS, focusing on Life Sciences. You will develop ETL/ELT workflows, implement DBT models, and collaborate across teams to deliver data-driven insights.

The role emphasizes data quality, governance, and leveraging cloud-native services. Strong scripting, modeling, and CI/CD practices are essential for success.