← All projects
Snowflake Platform — dbt, RBAC & Data Quality
Built the transformation, access-control and quality layers of a Snowflake data platform — dbt models, hierarchical RBAC, and test coverage from 20% to 100%.
Lead Data Engineer · NDA, Marketing domain
SnowflakedbtAWSPythonRBAC
A Snowflake-based platform where trust in the data was the real bottleneck. I owned the transformation, governance and quality layers that made it dependable.
What I did
- Migrated Snowflake tasks to dbt models — modular, version-controlled and maintainable; pipeline execution ~40% faster.
- Built a data-quality framework, lifting test coverage from 20% → 100%.
- Designed a hierarchical RBAC model for Snowflake users — clear, auditable access control.
- Redesigned extraction pipelines from ClickHouse, MongoDB and PostgreSQL into AWS S3.
- Designed scalable DWH architecture and data products for diverse analytics use cases.
- Optimized storage & compute on AWS + Snowflake via incremental models (~35% lower cost).
- Added Snowflake failure alerting to cut downtime and speed up incident response.
Impact
A Snowflake platform stakeholders actually trust — fully tested, access-controlled and cheaper to run.