About the Role

Swits Digital Private Limited is seeking a motivated Junior Snowflake Data Engineer to join our team in Chennai, India. This permanent role offers an exciting opportunity to contribute to data-driven solutions.

Key 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.

Qualifications and Skills

• 2+ years of hands-on experience in data engineering or related fields.
• Expertise in writing complex SQL queries, optimizing, using advanced functionals, and tuning performance on cloud data warehouse environments.
• Strong experience with data warehousing concepts, design, and implementation.
• Minimum 3 years of hands-on experience with Snowflake or modern cloud data warehouses.
• 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 communication and stakeholder management skills.