Snowflake Data Engineer

Weekday AI (YC W21); Bengaluru; On-site; INR 1,800,000 - 3,200,000; Full time

Job summary

Weekday AI (YC W21) invites applications for an experienced Snowflake Data Engineer in Bengaluru, with Hyderabad and Pune as feasible locations. You will design, develop, and maintain scalable, high‑performance data pipelines using Snowflake, dbt, and Python to empower BI and analytics.

You will collaborate with data architects, analytics engineers, and business stakeholders to ensure data quality, security, and availability, while implementing incremental loading and robust testing.

Qualifications

• Strong hands-on Snowflake data warehousing experience.
• Experience with dbt for data transformation, modeling, testing, and documentation.
• Proficiency in Python for data processing, scripting, and automation.

Responsibilities

• Design, develop, and maintain scalable data pipelines with Snowflake, Python, and dbt.
• Optimize ETL/ELT processes for performance and cost efficiency.
• Collaborate with data architects and stakeholders to ensure data quality and availability.
• Implement data governance and security practices.
• Monitor pipelines and troubleshoot issues.

Skills

Snowflake

dbt

Python

ETL/ELT

Data modeling

Data quality

Production troubleshooting

Tools

SQL

Git

Airflow

CI/CD

PySpark

Cloud platforms

Job description

Job Description:

This role is for one of Weekday’s clients

Min Experience: 5+ years
Location: Bengaluru, Hyderabad, Telangana, India, Pune, Maharashtra, India
JobType: full-time

We are looking for an experienced Snowflake Data Engineer with strong expertise in Snowflake, dbt, and Python to design, develop, and maintain scalable, reliable, and high-performance data solutions. The ideal candidate will have hands-on experience building modern data pipelines, transforming complex datasets, and developing efficient data models to support business intelligence, analytics, and data-driven decision-making.

You will collaborate with data architects, analytics engineers, business stakeholders, and other technical teams to build robust data platforms and ensure data quality, performance, and availability across the organization.

Key Responsibilities

• Data Engineering and Pipeline Development
  • Design, develop, and maintain scalable data pipelines using Snowflake, Python, and dbt.
  • Build and optimize ETL/ELT workflows to ingest, transform, and process structured and semi-structured data from multiple sources.
  • Develop efficient data models and transformation logic to support reporting, analytics, and downstream applications.
  • Implement incremental data loading, change data capture, and automated data processing wherever applicable.
  • Ensure data pipelines are reliable, maintainable, and aligned with business requirements.
• Snowflake Development and Optimization
  • Develop and manage Snowflake databases, schemas, tables, views, and other database objects.
  • Optimize Snowflake queries, warehouse configurations, and data processing workflows for performance and cost efficiency.
  • Work with Snowflake features such as streams, tasks, stages, and Snowpipe to support data ingestion and automation.
  • Implement appropriate data access controls, security practices, and governance standards.
  • Troubleshoot data processing issues and resolve performance bottlenecks.
• dbt Development and Data Transformation
  • Develop, maintain, and optimize dbt models to implement modular, reusable, and scalable data transformations.
  • Apply best practices for data modeling, model dependencies, incremental processing, and project organization.
  • Implement dbt tests, documentation, and data quality checks to ensure accuracy and consistency.
  • Manage model versioning, deployment workflows, and dependencies across development and production environments.
• Python-Based Automation
  • Develop Python scripts and utilities to automate data ingestion, validation, transformation, and monitoring.
  • Build reusable components to improve data processing efficiency and reduce manual intervention.
  • Integrate Python applications with Snowflake and other data platforms or APIs.
• Collaboration and Continuous Improvement
  • Collaborate with cross-functional teams to understand data requirements and translate them into technical solutions.
  • Participate in code reviews, technical design discussions, testing, and production deployments.
  • Monitor pipeline performance, troubleshoot production issues, and continuously improve data engineering practices.

Must-Have Skills

• Strong hands-on experience with Snowflake data warehousing and cloud data engineering.
• Practical experience with dbt for data transformation, modeling, testing, and documentation.
• Proficiency in Python for data processing, scripting, and workflow automation.
• Strong understanding of ETL/ELT concepts, data warehousing principles, and scalable data pipeline architecture.
• Experience with performance optimization, data quality management, and production troubleshooting.

Good-to-Have Skills

• Strong SQL skills, including complex queries, joins, CTEs, and query optimization.
• Experience with PySpark and distributed data processing.
• Familiarity with cloud platforms such as AWS, Azure, or GCP.
• Knowledge of orchestration tools, CI/CD pipelines, Git, and data governance practices.

Preferred Candidate Profile

• 5–10 years of relevant experience in data engineering, with substantial hands-on exposure to Snowflake, dbt, and Python.
• Strong analytical and problem-solving abilities.
• Excellent communication and collaboration skills.
• Ability to work independently, manage priorities, and deliver high-quality data solutions in a fast-paced environment.

Requirements: