Data Engineer (DBT + Snowflake+ Python+ Tableau) (Mumbai)

Data Engineer (DBT + Snowflake) Location: Mumbai (Hybrid 10 Days/Month Onsite) Experience: 5+ 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. .