Job Title: Junior Snowflake Data Engineer
Location: Chennai
Experience: 2-4 Years
Required Skills
- Strong experience in Data Engineering
- Hands-on experience with ETL Pipeline development
- Advanced knowledge of SQL
- Experience working with Snowflake
Duties & Responsibilities
- Lead the design, development, and optimization of ETL/ELT pipelines and workflows
- Write, tune, and optimize advanced SQL queries for large-scale data processing
- Build and maintain data warehouses and data models (relational, dimensional, star schema)
- Translate business requirements into robust, well-architected, and reusable data solutions
- Partner with analysts, data scientists, and stakeholders to deliver trusted, actionable datasets
- Implement and maintain unit tests, integration tests, and validation frameworks to ensure pipeline reliability
- Document workflows, and design decisions to support knowledge sharing and operational continuity
- Apply coding standards, CI/CD practices, version control, and peer code reviews to ensure high-quality deliverables
- Proactively monitor, optimize, and troubleshoot pipelines for performance, scalability, and cost efficiency
- Support deployments and handle post-production monitoring and incident resolution
- Mentor associate and mid-level engineers, providing technical guidance and feedback
Job Description
- 2+ years of hands-on experience in data engineering or related fields
- Expertise in writing complex SQL queries, optimizing, using advanced functionals and turning the performance on cloud data warehouse environment.
- Strong experience with data warehousing concepts, design, and implementation
- Minimum 3 years of hands-on experience with Snowflake or modern cloud data warehouse
- Minimum 2 years of hands-on experience in data modeling
- Minimum 1 year of hands-on Python development (ETL/ELT scripting, OOP, automation)
- Strong knowledge of at least one major cloud platform (AWS, Azure, or GCP)
- Experience with orchestration tools (e.g., Airflow, ADF, Luigi) for workflow management
- Demonstrated ability to lead and mentor teams while managing multiple priorities
- Strong hands-on experience with data warehousing concepts, design, and implementation
- Strong communication and stakeholder management skills
