Senior Data Engineer: Snowflake Pipelines & Python

Cognizant; Wilmington (DE); On-site; USD 130,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 with strong Snowflake and Python expertise to design, build, and optimize scalable data pipelines handling large volumes of structured and semi-structured data.

The role requires 7+ years in data engineering, solid SQL and data warehousing experience, and familiarity with CI/CD, version control, and data quality. This is a full-time role with competitive compensation and benefits.

Qualifications

• 7+ years of experience in data engineering, ETL/ELT, data warehousing, or related development.
• Strong hands-on development experience with Snowflake.
• Advanced proficiency in Python for data processing, automation, APIs, and pipeline development.
• Advanced SQL skills, including joins, CTEs, window functions, stored procedures, query optimization, and large-volume data processing.
• Strong troubleshooting and root-cause-analysis skills.
• Experience implementing data-quality, reconciliation, monitoring, and exception-handling frameworks.

Responsibilities

• Design, develop, and maintain scalable ETL/ELT data pipelines using Python, SQL, and Snowflake.
• Build ingestion and transformation processes for data from sources such as Oracle, SQL Server, APIs, flat files, and cloud object 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, warehouse sizing, clustering strategy, and optimization of data-processing patterns.
• Implement data-quality controls including source-to-target validation, reconciliation, duplicate checks, null checks, schema validation, and exception handling.
• Design effective logging, error handling, retry, monitoring, and alerting mechanisms for production pipelines.
• Troubleshoot data discrepancies, failed pipelines, performance bottlenecks, and production incidents.
• Apply Snowflake security concepts including RBAC, roles, privileges, secure views, and data-access controls.
• Participate in code reviews and ensure solutions meet engineering, security, scalability, and maintainability standards.
• Build and maintain CI/CD pipelines using Git-based development and deployment practices.
• Create and maintain technical documentation, data mappings, operational procedures, and implementation specifications.
• Mentor junior engineers and provide technical guidance on Python, SQL, Snowflake, and data-engineering best practices.

Skills

Snowflake

Python

SQL

ETL/ELT

Data Warehousing

Tools

Git

CI/CD

REST APIs

Job description

Cognizant is seeking a Senior Data Engineer with strong Snowflake and Python expertise to design, build, and optimize scalable data pipelines handling large volumes of structured and semi-structured data.

The role requires 7+ years in data engineering, solid SQL and data warehousing experience, and familiarity with CI/CD, version control, and data quality. This is a full-time role with competitive compensation and benefits.