Senior Data Engineer (DBT + Snowflake + SQL)

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.