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 explicit, 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.

📌 DBT Analyst (Mumbai)
🏢 Sigma Allied Services
📍 Mumbai