Job Description
Total Exp - 4-8 yrs
Location - Mumbai (The candidate will be needed to work from Client office in Mumbai,1 week in a month
JD:
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.