Build and maintain modular dbt models (staging, intermediate, and marts) using software engineering best practices (e.g., DRY principle, version control).
Implement robust dbt tests (schema tests, custom data tests) and packages to ensure data quality, consistency, and reliability.
Manage dbt documentation and DAGs (Directed Acyclic Graphs) to provide clear data lineage and business definitions for downstream users.
Snowflake Architecture & Pipelines
Design and optimize Snowflake schemas, including data ingestion strategies using Snowpipe, Streams, and Tasks.
Manage and optimize Snowflake compute resources (Virtual Warehouses) for cost efficiency and high-performance query execution.
Implement data access controls (RBAC), security masking policies, and secure data sharing within Snowflake.
DataOps & Collaboration
Maintain CI/CD pipelines for automating dbt deployments and Snowflake schema changes (using tools like GitHub Actions, GitLab C...