DBT Analyst

Sigma Allied Services; Mumbai; Hybrid; INR 2,500,000 - 4,000,000; Full time

Job summary

Sigma Allied Services in Mumbai is seeking an Analytics Engineer to own data modeling and pipeline design. You will develop scalable DBT models, integrate real-time data via Kafka, and optimize Snowflake performance.

The role requires strong SQL, templating, and data governance, with close collaboration to translate business needs into robust insights. Ideal candidates have 5+ years' experience, hands-on with SnapLogic, Git, and CI/CD practices, and a solid ability to document and communicate

Qualifications

• 5+ years of analytics/data engineering experience.
• Strong SQL, DBT expertise and scalable data modeling.
• Snowflake-based data warehouse experience with optimization.
• Realtime data ingestion with Kafka and ETL/ELT tooling (SnapLogic).
• Version control with Git/GitHub and CI/CD for DBT.
• Data quality, governance, validation, and lineage understanding.
• Stakeholder collaboration and ability to explain complex data clearly.

Responsibilities

• Design and maintain scalable data models and DBT projects.
• Ingest, process, and orchestrate data pipelines using SnapLogic and Kafka.
• Optimize Snowflake queries, security, and performance.
• Ensure data quality, lineage, and governance across pipelines.
• Collaborate with stakeholders to translate data needs into solutions.

Skills

SQL

DBT

Modular SQL

Jinja templating

Data modeling

Data quality governance

Data validation

Testing strategies

Stakeholder management

Documentation

Communication

Problem solving

Ownership

Tools

Snowflake

Kafka

SnapLogic

Git

GitHub

GitHub Actions

dbt tests

Job description

Position: Analytics Engineer

Location: Mumbai- Onsite

Experience; 5+ Years

Job Description

Strong SQL & DBT Expertise
Experience building and maintaining scalable data models in DBT .
Proficient in modular SQL , Jinja templating , testing strategies, and DBT best practices.
Data Warehouse Proficiency
Hands-on experience with Snowflake including:
Dimensional and data vault modeling (star/snowflake schemas)
Performance optimization and query tuning
Role-based access and security management
Data Pipeline & Integration Tools
Experience with Kafka (or similar event streaming tools) for ingesting real-time data.
Familiarity with SnapLogic for ETL/ELT workflow design, orchestration, and monitoring.
Version Control & Automation
Proficient in Git and GitHub for code versioning and collaboration.
Experience with GitHub Actions or other CI/CD tools to automate DBT model testing, deployment, and documentation updates.
Data Quality & Governance
Strong understanding of data validation, testing (e.g., dbt tests), and lineage tracking.
Emphasis on maintaining data trust across pipelines and models.

• Stakeholder Management
  Partner with business and technical stakeholders to define data needs and deliver insights.
  Ability to explain complex data concepts in clear, non-technical terms.
  
• Documentation & Communication
  Maintain clear documentation for models, metrics, and data transformations (using DBT docs or similar).
  Strong verbal and written communication skills; able to work cross-functionally across teams.
  
• Problem-Solving & Ownership
  Proactive in identifying and resolving data gaps or issues.
  Self-starter with a continuous improvement mindset and a focus on delivering business value through data.