Urgent Hiring | Snowflake Data Engineer | Remote
Position: Snowflake Data Engineer Experience: 7–10 Years
Work Location: Remote (Mandatory 3-day office visit in Mumbai or Bangalore for onboarding) Working Hours: 2:00 PM – 10:00 PM IST
Job Description
We are looking for an experienced Snowflake Data Engineer with strong expertise in Snowflake, Advanced SQL, Python, ETL development, Apache Airflow, and AWS.
The ideal candidate should have hands-on experience in designing, developing, optimizing, and maintaining scalable data pipelines and data warehouse solutions.
Key Responsibilities
- Design, develop, and maintain data pipelines using Snowflake, SQL, and Python.
- Write and optimize complex SQL queries for efficient data processing.
- Develop and manage ETL workflows using Apache Airflow.
- Integrate AWS services, particularly Amazon S3.
- Design data warehouse schemas, fact tables, and dimension tables.
- Implement Slowly Changing Dimensions (SCD).
- Perform data validation, reconciliation, and quality checks.
- Support business reporting and analytical requirements.
- Troubleshoot pipeline failures and conduct root cause analysis.
- Collaborate with cross-functional teams in an Agile environment.
- Participate in all stages of the software development lifecycle.
Mandatory Technical Skills
- Snowflake Data Warehousing
- Advanced SQL & Query Performance Optimization
- Python
- ETL Development & Pipeline Maintenance
- Apache Airflow
- AWS – Amazon S3 & Connection Management
- Data Warehouse Architecture
- Dimensional Data Modelling (Fact & Dimension Tables)
- Slowly Changing Dimensions (SCD)
- Data Analysis & Business Reporting
- Data Reconciliation & Validation
- Agile Methodology
- Troubleshooting & Root Cause Analysis
Candidate Requirements
- 7–10 years of overall IT/data engineering experience.
- Strong hands-on Snowflake development experience.
- Proven expertise in complex SQL queries and performance tuning.
- Practical experience with Python, Airflow, and AWS.
- Strong analytical, troubleshooting, and communication skills.
- Ability to work independently in a remote environment.
- Willingness to visit the Mumbai or Bangalore office for 3 days during onboarding.
- Availability to work from 2:00 PM to 10:00 PM IST.
Pay: ₹90,000.00 - ₹100,000.00 per month