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
Robust 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.