We are seeking an experienced Senior Snowflake Data Engineer to design, build, and optimize scalable data solutions within complex enterprise settings. This is a hands-on engineering role focused on developing reliable data pipelines, improving Snowflake performance and cost efficiency, and modernizing existing data-processing workloads.

Role & responsibilities
Design, develop, and maintain scalable data pipelines and transformation workflows within Snowflake.
Build and optimize ELT/ETL processes using SQL, Python, Snowpark, dbt, and Snowflake-native capabilities.
Modernize existing Python- and stored-procedure-based pipelines using set-based processing, incremental loading, and reusable engineering patterns.
Implement Snowflake-native data-processing solutions using Agile Tables, Streams, Tasks, and stored procedures.
Improve platform performance and cost efficiency through query tuning, warehouse right-sizing, clustering strategies, workload isolation, and auto-suspend and auto-resume policies.
Develop reliable orchestration, dependency management, monitoring,



error handling, retry, and recovery mechanisms.
Design and maintain dimensional, relational, and domain-oriented data models.
Implement data-quality checks, observability, testing, lineage, and documentation standards.
Integrate data from batch and real-time sources using tools such as Fivetran, Kafka, Airflow, or similar technologies.
Contribute to CI/CD pipelines, infrastructure-as-code practices, and automated deployment processes.
Work closely with architects and client stakeholders to translate business and technical requirements into production-ready solutions.
Participate in code reviews, technical design discussions, estimation, and Agile delivery activities.

Required candidate profile
7+ years of experience in data engineering, including significant hands-on experience with Snowflake.
Advanced SQL skills, including complex transformations, query optimization, and

📌 Sr Snowflake Data Engineer Noida
🏢 Birch Tree Consulting
📍 Noida