2 days ago
Base Salary
$130k - $150k/yr
Responsibilities
- Design, develop, and maintain scalable ETL/ELT pipelines using Snowflake, Python, and SQL.
- Build and optimize ingestion, transformation, and integration solutions for structured and semi-structured data.
- Develop and manage Snowflake databases, schemas, tables, views, streams, tasks, stages, and stored procedures.
- Monitor, troubleshoot, and enhance pipelines through performance tuning, data quality controls, logging, reconciliation, and exception handling.
- Provide production support and root cause analysis for data solutions.
- Use Git-based development practices and CI/CD deployment pipelines.
- Contribute to code reviews, technical guidance, documentation, and engineering standards.
- Mentor junior engineers and lead technical discussions when needed.
Requirements
- 7+ years of experience in data engineering, ETL/ELT development, data warehousing, or related software engineering roles.
- Strong hands-on experience designing and developing Snowflake solutions.
- Advanced Python proficiency for data processing, automation, API integration, and pipeline development.
- Advanced SQL expertise, including complex joins, CTEs, window functions, query optimization, and large-scale data processing.
- Experience with CSV, JSON, Parquet, and XML data formats.
- Experience implementing data quality, reconciliation, monitoring, logging, and exception-handling frameworks.
- Strong troubleshooting, root cause analysis, and production support capabilities.
- Experience with Git-based development practices and CI/CD deployment pipelines.
- Working knowledge of Snowflake security concepts, including RBAC, roles, privileges, secure views, and data access controls.
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related discipline, or equivalent professional experience.
- Preferred experience with Oracle, SQL Server, cloud storage platforms, and REST APIs.
- Preferred experience with Snowflake Streams, Tasks, Snowpipe, Stages, warehouse optimization, highly available cloud data solutions, data governance, and enterprise data management.
Benefits
- Medical, dental, vision, and life insurance.
- Paid holidays and paid time off.
- 401(k) plan and contributions.
- Long-term and short-term disability coverage.
- Paid parental leave.
- Employee Stock Purchase Plan.
- Eligible for a discretionary annual incentive program based on performance.
- Onsite position requiring five days per week in a client or Cognizant office in Buffalo, New York.
About Cognizant
Cognizant is a public IT services and consulting firm that designs, builds, and runs enterprise technology, including digital engineering, cloud modernization, data/AI, and managed services. It sells consulting, systems integration, and outsourcing on multi-year engagements to large enterprises in healthcare, banking, retail, communications, and manufacturing. Founded in 1994 and headquartered in Teaneck, New Jersey, Cognizant is NASDAQ-listed (CTSH) and a Fortune 500 company.