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 setting.
• 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.
• Strong 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 explain tech

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