Senior Data Engineer (DBT + Snowflake + SQL) 5+

Dreampath Services; Mumbai; Hybrid; INR 1,500,000 - 3,000,000; Full time

Job summary

Dreampath Services in Mumbai seeks an experienced Data Engineer to design scalable data models, build reliable data pipelines, and optimize data warehouse performance for analytics and BI initiatives.

You will work with SQL, DBT, Snowflake, Kafka and SnapLogic, contribute to data governance, and collaborate with business and tech stakeholders to deliver high-quality data solutions. The role is full-time with hybrid work requiring 10 days onsite per month.

Qualifications

• 6+ years of data engineering experience.
• Strong SQL, DBT, Snowflake, Kafka, and SnapLogic expertise.
• Experience with data modeling (Star/Snowflake/Data Vault) and ETL/ELT workflows.
• Ability to collaborate with business and technical stakeholders to deliver data solutions.

Responsibilities

• Design, develop, and maintain scalable data transformation pipelines using DBT.
• Build and optimize Snowflake data models and queries.
• Develop real-time data ingestion with Kafka and orchestrate workflows with SnapLogic.
• Implement CI/CD pipelines using GitHub Actions.
• Ensure data quality through testing, lineage, and governance.
• Document data models, transformations, and metrics; collaborate with stakeholders.

Skills

SQL

DBT

Snowflake

Data Modeling

Query Optimization

Kafka

SnapLogic

Git

CI/CD

Data Quality & Governance

Tools

GitHub

GitHub Actions

Job description

Experience: 6+ Years

Employment Type: Full-Time (FTE)

Work Mode: Hybrid (10 days onsite every month in Mumbai)

Job Summary

We are looking for an experienced Data Engineer with strong expertise in SQL, DBT, Snowflake, Kafka, and SnapLogic. The ideal candidate will be responsible for designing scalable data models, building reliable data pipelines, optimizing data warehouse performance, and ensuring high-quality data delivery for analytics and business intelligence initiatives.

Key Responsibilities

• Design, develop, and maintain scalable data transformation pipelines using DBT.
• Build reusable, modular SQL models following DBT best practices.
• Develop and optimize data models in Snowflake.
• Design dimensional models and Data Vault architectures (Star/Snowflake Schemas).
• Optimize query performance and manage Snowflake security, roles, and access controls.
• Build and maintain real-time data ingestion pipelines using Kafka or similar event streaming platforms.
• Design, orchestrate, and monitor ETL/ELT workflows using SnapLogic.
• Implement CI/CD pipelines using GitHub Actions or similar automation tools.
• Ensure data quality through validation, testing, lineage tracking, and governance.
• Collaborate with business and technical stakeholders to understand data requirements and deliver analytical solutions.
• Maintain comprehensive documentation for data models, transformations, and metrics.
• Proactively identify and resolve data issues while driving continuous improvements.

Required Skills

Technical Skills

• Strong expertise in SQL
• Hands-on experience with DBT
• Snowflake Data Warehouse
• Data Modeling (Star Schema, Snowflake Schema, Data Vault)
• SQL Query Optimization & Performance Tuning
• Kafka or similar Event Streaming PlatformsSnapLogic ETL/ELT
• Git & GitHub
• GitHub Actions / CI-CD
• Data Quality, Testing & Governance
• DBT Documentation

Soft Skills

• Strong communication and stakeholder management skills
• Excellent analytical and problem-solving abilities
• Self-motivated with a strong sense of ownership
• Ability to work effectively in cross-functional teams

Mandatory Skills

• SQL
• DBT
• Snowflake
• Kafka
• SnapLogic
• Git/GitHub
• CI/CD
• Data Modeling

Preferred Skills

• Experience with enterprise-scale Data Warehouse projects.
• Experience building modern cloud-based analytics platforms.