We are seeking an experienced Snowflake Developer with strong expertise in Python-based ETL development, Apache Airflow orchestration, and AWS cloud services. The ideal candidate will design, develop, and optimize scalable data pipelines and data warehouse solutions using Snowflake in a cloud-native environment.

Key Responsibilities

• Design, develop, and maintain scalable data warehouse solutions in Snowflake.
• Develop robust ETL/ELT pipelines using Python.
• Build and manage workflow orchestration using Apache Airflow.
• Integrate Snowflake with various AWS services including Amazon S3, AWS Lambda, and Amazon Redshift where applicable.
• Optimize Snowflake performance including clustering, partitioning, query tuning, and warehouse sizing.
• Implement data quality checks, logging, monitoring, and error handling frameworks.
• Work closely with Data Engineers, BI teams, and business stakeholders to gather requirements and translate them into technical solutions.
• Ensure best practices around data governance, security, and compliance.

Required Skills & Qualifications

• Strong hands-on experience with Snowflake (schema design, SnowSQL, Snowpipe, Streams & Tasks).
• 3+ years in Snowflake and 5+ years of experience in ETL development.
• Advanced proficiency in Python (Pandas, PySpark, API integrations).
• Experience building DAGs and scheduling pipelines using Apache Airflow.
• Solid experience with AWS services (S3, EC2, Lambda, IAM, CloudWatch).
• Strong SQL expertise and data modeling experience (Star/Snowflake schema).
• Experience with CI/CD pipelines and version control (Git).
• Knowledge of performance tuning and cost optimization strategies in Snowflake.