Snowflake Data Architect — Cloud ETL & Analytics

Cognizant; Madison (WI); On-site; USD 116,000 - 136,000; Full time

Benefits offered by this job

Medical/Dental/Vision/Life Insurance

401(k) plan and contributions

Paid holidays plus Paid Time Off

Paid Parental Leave

Employee Stock Purchase Plan

Job summary

Cognizant is seeking a skilled Data Engineer to support Life Sciences data initiatives using Snowflake, AWS, DBT, Python, PySpark, and Unix. You will build scalable data pipelines, implement ETL/ELT processes, and manage end-to-end data workflows in cloud environments to enable data integration and analytics.

The role focuses on data integration, transformation, and analytics solutions that support business and operational objectives, with collaboration across stakeholders and teams.

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

Git

CI/CD

Glue

EMR

Redshift

S3

Tools

Snowflake

AWS

DBT

Python

PySpark

Unix/Linux

SQL

Git

CI/CD

Glue

EMR

Redshift

S3

Job description

Cognizant is seeking a skilled Data Engineer to support Life Sciences data initiatives using Snowflake, AWS, DBT, Python, PySpark, and Unix. You will build scalable data pipelines, implement ETL/ELT processes, and manage end-to-end data workflows in cloud environments to enable data integration and analytics.

The role focuses on data integration, transformation, and analytics solutions that support business and operational objectives, with collaboration across stakeholders and teams.