About this role
Lead Data Engineer
Primary Skills
- BigTable, Cloud Functions, Cloud Spanner, GKE
Specialization
- GCP Data Engineer Advanced: Senior Data Engineer
Job requirements
Job Title: Data Engineer – Snowflake, DBT, Python & SQL
Experience
5–8 Years
Location
Bangalore / Hyderabad / Pune / Chennai / Gurgaon
Job Summary
We are seeking a skilled Data Engineer with strong expertise in Snowflake, DBT, SQL, and Python to design, develop, and maintain scalable data solutions. The ideal candidate will have hands-on experience building modern data pipelines, implementing data warehouse solutions, and enabling analytics through efficient data modeling and transformation practices.
Key Responsibilities
- Design, build, and maintain scalable ETL/ELT data pipelines using DBT, SQL, and Python .
- Develop and optimize Snowflake-based data warehouse solutions for enterprise analytics and reporting.
- Create robust data models and transformation frameworks to support business requirements.
- Implement data ingestion, cleansing, transformation, and validation processes.
- Develop and maintain stored procedures, views, and database objects within cloud data platforms.
- Optimize SQL queries, data models, and pipelines for performance and scalability.
- Work closely with business stakeholders, analysts, and engineering teams to translate requirements into technical solutions.
- Monitor data quality and troubleshoot data-related issues across platforms.
- Leverage Snowflake features such as Snowpipe, Time Travel, Zero Copy Cloning, and Fail Safe .
- Participate in code reviews, testing, deployment, and documentation activities.
- Support data governance, security, and best practices across the data ecosystem.
Required Skills
Snowflake
- Strong hands-on experience with Snowflake Data Warehouse .
- Experience with:
- Snowpipe
- Zero Copy Cloning
- Time Travel
- Fail Safe
- SnowSQL
- Data Sharing/Data Exchange
- Performance tuning and optimization of Snowflake workloads.
DBT
- Strong expertise in DBT (Data Build Tool) .
- Experience developing reusable transformation models.
- Understanding of DBT testing, documentation, and deployment practices.
SQL
- Advanced SQL skills with experience handling large-scale datasets.
- Expertise in query optimization, joins, analytical functions, and performance tuning.
- Experience with stored procedures and database development.
Python
- Strong Python programming skills for data processing and automation.
- Experience with data engineering frameworks and scripting.
Data Engineering
- Strong understanding of ETL/ELT concepts and modern data architectures.
- Experience in data warehousing and dimensional modeling.
- Knowledge of data governance, data quality, and metadata management.
Preferred Skills
- Experience with orchestration tools such as Airflow .
- Exposure to cloud platforms such as AWS, Azure, or GCP .
- Knowledge of CI/CD practices and Git-based version control.
- Experience with reporting and visualization tools such as Power BI, Tableau, or Looker .
- Exposure to AI/GenAI capabilities within data engineering solutions.
Educational Qualifications
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
Preferred Certifications
- Snowflake SnowPro Certification
- DBT Certification
- AWS/Azure/GCP Data Engineering Certifications
- Databricks or Cloud Data Platform Certifications
Primary Skills
Snowflake, DBT, SQL, Python
Secondary Skills
Data Modeling, ETL/ELT, Airflow, AWS/Azure/GCP, Power BI/Tableau, Data Warehousing