– Data Engineer (DBT + Snowflake)

Location: Mumbai (Hybrid – 10 Days/Month Onsite)

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 .
- Manage source code using Git/GitHub .
- 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 Platforms
- SnapLogic 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 robust 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.
- Exposure to Agile development methodologies.
- Experience building modern cloud-based analytics platforms.

📌 Senior Data Engineer (DBT + Snowflake + SQL) 5+ (Mumbai)
🏢 Dreampath Services
📍 Mumbai