Lead Snowflake Engineer (AWS)

Blend; Hyderabad; On-site; INR 2,500,000 - 4,000,000; Full time

Job summary

Blend is seeking an experienced Senior Data Engineer to design, develop, and optimize scalable data pipelines and cloud-based data warehouse solutions. You will leverage Python, Matillion, and Snowflake in an agile environment to build robust data models and analytics-ready data.

The role involves collaboration with stakeholders and ensuring data quality. The ideal candidate has 4–8 years in data engineering, strong SQL, and hands-on experience with cloud platforms like AWS, Git, CI/CD, and data

Qualifications

• 4 to 8 years of experience in Data Engineering.
• Hands-on experience with Python, Matillion, and Snowflake.
• Experience building ETL/ELT pipelines and data integration solutions.
• Strong SQL skills with query optimization.
• Good understanding of data warehousing concepts and dimensional data modeling.
• Experience working with cloud platforms such as AWS.
• Knowledge of Git, CI/CD pipelines, and Agile methodologies.
• Strong analytical, troubleshooting, and problem-solving abilities.

Responsibilities

• Design, develop, and maintain scalable ETL/ELT pipelines.
• Build and optimize data warehouse solutions on Snowflake.
• Develop robust data processing frameworks and automation scripts using Python.
• Create and maintain data models, transformations, and workflows for analytics.
• Optimize Snowflake performance through query tuning and warehouse management.
• Integrate data from multiple structured and unstructured sources.
• Collaborate with stakeholders, analysts, and engineers to deliver data solutions.
• Implement data quality, validation, monitoring, and error-handling mechanisms.
• Participate in code reviews, testing, deployment, and production support.

Skills

Python

Matillion

Snowflake

ETL/ELT pipelines

SQL

Data warehousing

AWS

Git

CI/CD

Agile

Tools

Airflow

DBT

REST APIs

Job description

Blend is a premier AI services provider, committed to co-creating meaningful impact for its clients through the power of data science, AI, technology, and people. With a mission to fuel bold visions, Blend tackles significant challenges by seamlessly aligning human expertise with artificial intelligence. The company is dedicated to unlocking value and fostering innovation for its clients by harnessing world-class people and data-driven strategy. We believe that the power of people and AI can have a meaningful impact on your world, creating more fulfilling work and projects for our people and clients. For more information, visit www.blend360.com.

Job Description

We are looking for an experienced Senior DataEngineer with strong expertise in Python, Matillion, and Snowflake to design, develop, and optimize scalable data pipelines and cloud-based data warehouse solutions. The ideal candidate should have hands-on experience in ETL/ELT development, data modeling, and cloud data engineering while working in an agile environment.

Key Responsibilities

• Design, develop, and maintain scalable ETL/ELT pipelines using Matillion.
• Build and optimize data warehouse solutions on Snowflake.
• Develop robust data processing frameworks and automation scripts using Python.
• Create and maintain data models, transformations, and workflows to support business analytics.
• Optimize Snowflake performance, including query tuning, clustering, and warehouse management.
• Integrate data from multiple structured and unstructured sources.
• Collaborate with business stakeholders, analysts, and cross-functional engineering teams to deliver high-quality data solutions.
• Implement data quality, validation, monitoring, and error-handling mechanisms.
• Participate in code reviews, testing, deployment, and production support activities.
• Follow best practices for security, governance, and documentation.

Qualifications

• 4 to 8 years of experience in Data Engineering.
• Strong hands-on experience with Python, Matillion, and Snowflake.
• Experience building ETL/ELT pipelines and data integration solutions.
• Strong SQL skills with experience in query optimization.
• Good understanding of data warehousing concepts and dimensional data modeling.
• Experience working with cloud platforms such as AWS
• Knowledge of Git, CI/CD pipelines, and Agile methodologies.
• Strong analytical, troubleshooting, and problem-solving

Additional Information

• Experience with orchestration tools such as Airflow.
• Exposure to DBT is an added advantage.
• Knowledge of REST APIs and data integration techniques.
• Familiarity with data governance and security best practices.