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 environment.
- 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
- Strong 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)
🏢 Zensar Technologies
📍 Pune