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.

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