dbt

Understands dbt project structure, models, and ref/source functions. Follows established patterns for writing SQL transformations and schema tests. Uses dbt run and dbt test commands following team CI/CD workflows.

Understands dbt basics and how it transforms raw data into BI-ready datasets. Follows team conventions for writing simple dbt models that feed dashboards. Uses dbt docs to understand data lineage and model dependencies.

Understands dbt fundamentals: models, tests, and documentation. Follows team patterns for building analytical transformations from staging to mart layers. Uses dbt-generated documentation to discover available datasets for analysis.

Independently builds dbt transformation pipelines with incremental models, snapshots, and custom macros. Implements data quality tests with dbt-expectations and dbt-utils packages. Configures materializations and optimizes model performance.

Independently writes dbt models for BI reporting layer: metric definitions, aggregate tables, and dimensional models. Implements schema tests and data freshness checks. Configures dbt exposures to document downstream dashboard dependencies.

Independently builds dbt models for analytical datasets with proper testing and documentation. Implements Jinja macros for reusable transformation logic. Configures model materializations appropriate for analytical query patterns and data volume.

Architects data systems with dbt. Optimizes for big data. Implements data governance and quality frameworks.

Designs dbt project architecture for enterprise BI platform with semantic layer integration. Implements dbt Mesh patterns for cross-project model references. Architects multi-environment deployment strategies with slim CI and state-based builds.

Designs dbt transformation architecture for complex analytical domains. Implements advanced patterns: unit testing, contract enforcement, and version-controlled schema evolution. Mentors analysts on dbt best practices and efficient SQL transformation design.

Defines the organization's dbt project architecture: modular package structure, cross-project references, shared macros library. Implements standards for incremental models, snapshot strategies, and dbt environment management (dev/staging/prod).

Defines dbt development standards for BI organization. Establishes model naming conventions, testing requirements, and code review processes. Coordinates dbt governance across teams with shared macro libraries and package management strategies.

Defines dbt transformation standards across analytical teams. Establishes modeling layer conventions, testing coverage requirements, and deployment workflows. Drives adoption of self-service dbt development among analyst teams with proper guardrails.

Architects the enterprise dbt platform evolution strategy: multi-project mono-repo vs multi-repo, dbt mesh for cross-team dependencies, migration to dbt Cloud. Defines the roadmap for MetricFlow/Semantic Layer adoption to unify business metrics.

Defines enterprise dbt strategy and transformation platform architecture. Evaluates dbt Cloud vs Core trade-offs, Mesh adoption, and semantic layer integration paths. Shapes organizational data transformation governance aligned with data mesh principles.

Shapes enterprise dbt transformation strategy and analytical platform evolution. Drives organizational adoption of modern transformation patterns and tooling. Defines long-term dbt architecture roadmap with versioning, contracts, and cross-team collaboration models.