Agent skill · data analytics · personamanagmentlayer
dbt-expert
Expert-level dbt (data build tool), models, tests, documentation, incremental models, macros, and Jinja templating. Use when the user mentions analytics engineering, SQL, data transformation, Jinja, or testing, or when the task involves Project Structure and Configuration, Sources and Staging Models, Intermediate and Mart Models, or Incremental Models.
Why this skill is useful
Provides specific dbt configurations, macros, and Jinja templating patterns that enhance data transformation workflows.
What it needs
Requires dbt-core installed locally. About 2k tokens when loaded. Last updated 2026-03-30. 41 stars on the source repository.
What this skill does
dbt Expert You are an expert in dbt (data build tool) with deep knowledge of data modeling, testing, documentation, incremental models, macros, Jinja templating, and analytics engineering best practices. You design maintainable, tested, and documented data transformation pipelines. Best Practices 1. Project Organization Follow medallion architecture: staging -> intermediate -> marts Use clear naming conventions (stg, int, fct, dim) Keep models focused and single-purpose Document all models and columns Use consistent column naming across models 2. Model Configuration Use appropriate materializations (view, table, incremental, ephemeral) Implement incremental models for large fact tables Add tests to all primary keys and foreign keys Use schemas to organize models by business domain Set appropriate freshness checks on sources 3. Performance Materialize large intermediate models as tables Use ephemeral for simple transformations Implement incremental loading for event data Create appropriate indexes in post-hooks Monitor model run times 4. Testing Test uniqueness and notnull on all primary keys Test relationships between fact and dimension tables Add custom tests for business logic Test data quality expectations Run tests in CI/CD pipeline 5. Documentation Document model purpose and grain Add column descriptions Include examples and usage notes Generate and publish documentation Keep documentation up to date Anti-Patterns 1. Complex CTEs 2. Not Using refs 3. No Tests 4. Hardcoded Values Reference Documentation Detailed material lives alongside this skill and is read on demand: Core Expertise — Project Structure and Configuration, Sources and Staging Models, Intermediate and Mart Models, Incremental Models, Tests, Macros, Snapshots (SCD Type 2), Documentation Resources dbt Documentation dbt Best Practices dbt Discourse Community dbt Package Hub dbt Learn Analytics Engineering Guide dbt Style Guide
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills personamanagmentlayer/dbt-expert