Senior Snowflake Data Engineer | Python & ETL Lead

Cognizant; Buffalo (NY); On-site; USD 100,000 - 135,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 is seeking a Senior Data Engineer (Snowflake Lead) in Buffalo to design, implement, and optimize scalable data pipelines using Snowflake, Python, and SQL. You will own ingestion, transformation, and production support for large data volumes, applying strong data-quality and security practices.

The role emphasizes hands-on coding, performance tuning, CI/CD integration, and mentoring junior engineers, with a competitive compensation package and full benefits.

Qualifications

• 7+ years of experience in data engineering, ETL/ELT, data warehousing.
• Strong hands-on Snowflake development.
• Advanced Python for data processing and automation.
• Advanced SQL skills, including joins, CTEs, window functions, stored procedures.
• Experience implementing data-quality, monitoring, and exception-handling frameworks.
• Primary Skills : Snowflake, Python, SQL, ETL/ELT, Data Warehousing.

Responsibilities

• Design, develop, and maintain scalable ETL/ELT data pipelines using Python, SQL, and Snowflake.
• Build ingestion and transformation processes for data from Oracle, SQL Server, APIs, flat files, and cloud storage.
• Develop and optimize Snowflake objects including databases, schemas, tables, views, stages, streams, tasks, and stored procedures.
• Write complex and performance-optimized SQL queries for data transformation and analytics workloads.
• Work with structured and semi-structured formats including CSV, JSON, Parquet, and XML.
• Perform Snowflake performance tuning through query analysis and data-processing optimization.
• Implement data-quality controls and exception handling.
• Design logging, error handling, retry, monitoring, and alerting mechanisms for production pipelines.
• Troubleshoot data discrepancies, failed pipelines, and production incidents.
• Apply Snowflake security concepts including RBAC, roles, privileges, secure views, and data-access controls.
• Mentor junior engineers and provide guidance on Python, SQL, Snowflake.

Skills

Snowflake

Python

SQL

ETL/ELT

Data Warehousing

Tools

Git

CI/CD

REST APIs

Job description

Cognizant is seeking a Senior Data Engineer (Snowflake Lead) in Buffalo to design, implement, and optimize scalable data pipelines using Snowflake, Python, and SQL. You will own ingestion, transformation, and production support for large data volumes, applying strong data-quality and security practices.

The role emphasizes hands-on coding, performance tuning, CI/CD integration, and mentoring junior engineers, with a competitive compensation package and full benefits.