Dreampath Services
Website:
ondreampath.com
Company:
https://www.linkedin.com/company/dreampath-services
Seniority: Mid-Senior level
Industries: IT Services and IT Consulting and Information Services
Job details:
Job Description – Data Engineer (DBT + Snowflake)
Location: Mumbai/ Bengaluru (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 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.
- Exposure to Agile development methodologies.
- Experience building modern cloud-based analytics platforms.
Click on Apply to know more.
