Description
Key Responsibilities
Design, develop, and optimize ETL/ELT pipelines using Snowflake, SQL, and PySpark to support analytics and reporting needs.
Write complex, high-performance SQL queries and stored procedures; tune queries and warehouse configurations for cost and performance efficiency.
Develop and maintain SnowSQL scripts for data loading, transformation, automation, and orchestration within the Snowflake workplace.
Build and manage data ingestion pipelines using Python and PySpark for large-scale structured and unstructured data processing.
Implement data modeling, schema design, and data quality/validation frameworks within Snowflake.
Manage Snowflake objects such as warehouses, databases, schemas, roles, and access controls, following best practices for security and governance.
Troubleshoot and resolve performance bottlenecks, data pipeline failures, and data quality issues.
Collaborate with business analysts, data scientists, and other engineering teams to understand requirements and translate them into robust technical solutions.




Document technical designs, data flows, and standard operating procedures clearly for team and stakeholder use.
Actively use AI-assisted tools (e.g., Copilot, ChatGPT, Claude, or similar) to accelerate coding, debugging, documentation, and query optimization tasks.
Mentor junior engineers and contribute to establishing engineering best practices within the team.

Required Skills
Solid proficiency in SQL, including complex joins, window functions, query optimization, and performance tuning.
Solid working knowledge of Python, particularly PySpark, for data processing and transformation at scale.
Robust Snowflake development experience, including SnowSQL, Snowpipe, Streams, Tasks, and Snowflake's role-based access control model.
Experience designing and implementing data warehouse/data lake architectures on Snowflake.
Excellent verbal and written communication skills, with the ability to

📌 Senior Data Engineer – Snowflake Developer Pune (India)
🏢 Zensar Technologies
📍 India