data-engineering

Plugin data-engineering from marketplace agent-powerups in yeaight7/agent-powerups. Commands read from the repo's manifest — 1 month ago.

Skills (8)

• bigquery-cost-audit

  Use when reviewing BigQuery spend, query failure patterns, or scan inefficiencies -- identifying which jobs, users, or projects drive cost, or preparing optimization recommendations for a cost review.

• data-quality

  Use when adding or reviewing data quality tests for dbt models in warehouse-backed analytics projects. Covers dbt generic tests, singular tests (assert_*.sql), accepted-values macros, dbt_utils patterns, cross-system consistency tests, and warehouse-oriented validation. Use when writing data tests,

• dbt-incremental-strategy-audit

  Use when reviewing a new or changed dbt incremental model -- the strategy looks over-engineered, rebuild or delete behavior is unclear, or the model deviates from how the rest of the repo handles incrementals.

• dbt-preflight

  Use when a dbt change needs preflight before a PR, review, or merge -- changed models, snapshots, seeds, macros, or semantic YAML whose blast radius and test coverage are not yet known.

• dbt-strategy

  Use when creating or modifying dimensional dbt models in warehouse-backed analytics projects. Covers a four-layer warehouse architecture (sources/staging/core/marts), naming conventions, no-alias SQL rule, surrogate-key and missing-record patterns, incremental strategies, deduplication, and common p

• metric-impact-analyzer

  Use when a change may affect metrics, semantic models, dashboards, reporting, or stakeholder-facing KPIs and you need to know whether business meaning or downstream BI assets change.

• semantic-layer-change-review

  Use when a change touches dbt semantic models, metrics, saved queries, or other semantic-layer YAML -- especially when an existing metric's expression, aggregation, filters, or dimensions are modified.

• sql-business-logic-review

  Use when reviewing SQL that affects reporting, metrics, transformations, financial logic, product logic, or stakeholder-facing outputs -- especially when a query still runs fine but its business meaning may have drifted.

Slash commands (4)

• /data-engineering:bigquery-cost-check

  Audit a BigQuery SQL query or dbt model for potential cost traps before it hits production.

• /data-engineering:data-quality-check

  Review or design a data pipeline architecture based on requirements

• /data-engineering:dbt-model-review

  Build a new analytics feature or dbt model guided by business requirements and data exploration

• /data-engineering:semantic-change-check

  Audit changes to dbt Semantic Layer definitions for breaking changes and aggregation risks.

Subagents (5)

• bigquery-cost-analyst

  Analyzes BigQuery SQL and dbt configurations to predict and reduce query costs. Identifies full table scans, poor partitioning, and inefficient joins.

• data-engineer

  Analytics engineer for warehouse-backed dbt projects on BigQuery. Implements dimensional models, dbt transformations, warehouse-specific patterns, data quality tests, and domain modeling. Use PROACTIVELY for building or modifying dbt models, designing data pipelines, implementing tests, or analyzing

• data-modeling-architect

  Dimensional modeling architect for dbt projects. Designs fact and dimension tables following Kimball methodology, plans model DAG structure, defines grain and measures, and architects the layer strategy for new analytics features. Use PROACTIVELY when designing new data models or planning model depe

• dbt-analytics-engineer

  Analytics engineer specializing in dbt projects on a cloud data warehouse. Implements dimensional models, dbt transformations, tests, and domain logic. Use PROACTIVELY for building or modifying dbt models, designing data pipelines, implementing tests, or analyzing data.

• semantic-layer-reviewer

  Reviews changes to the dbt Semantic Layer, ensuring metrics and dimensions remain mathematically sound and backwards-compatible.

Similar plugins