data-engineering

Apply governance rules to standardize AI data pipelines.

3|Updated Sep 27, 2025
One-click install
npx skills add https://github.com/Sheldon-92/TAD --skill data-engineering-sheldon-92
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: data-engineering
Source: https://github.com/Sheldon-92/TAD/tree/main/.agents/skills/data-engineering
Command: npx skills add https://github.com/Sheldon-92/TAD --skill data-engineering-sheldon-92

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires duckdb, and includes scripts (resource) and references (resource) components.

What problem does it solve?

The data-engineering skill provides a comprehensive, rules-based framework to govern AI data pipelines, aligning ingestion, transformation, orchestration, quality checks, and storage patterns to prevent train-serve divergence and data drift.

Core Features & Use Cases

  • Enforces single-source-of-truth for feature transformations (e.g., dbt/Feature Views) to close the train-serve gap.
  • Defines governance templates across ETL/ELT, ingestion (dlt), orchestration (Airflow, Dagster, Prefect), data quality (Great Expectations, Soda), SCD modeling, and vector+streaming retrieval.
  • Useful for AI data pipelines in feature engineering, warehouse modeling, RAG context lakes, and real-time inference architectures.

Quick Start

Review and apply the data-engineering judgment rules to your AI data pipelines for consistent governance.

Frequently Asked Questions about data-engineering

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I prevent train-serve skew in AI data pipelines?

To prevent train-serve skew in AI data pipelines, enforce a single-source-of-truth for feature transformations using dbt or Feature Views, ensuring identical logic across training and serving. This governance rule eliminates data drift and divergence.

What is the best way to handle SCD Type 2 modeling in dbt?

SCD Type 2 modeling in dbt requires deterministic practices like is_current filtering to isolate active records. Applying these governance rules ensures accurate historical tracking and prevents accidental data overwrites in your warehouse.

Does this data engineering framework work with DuckDB and dlt for ELT ingestion?

Yes, this data engineering framework works with DuckDB and dlt for ELT ingestion. It enforces explicit incremental loading and cursor-based changes, providing governed templates that standardize ingestion logic across your data pipelines.

How do I ensure data quality contracts in Airflow or Dagster pipelines?

Data quality contracts in Airflow or Dagster are enforced by integrating tools like Great Expectations and Soda. This framework standardizes quality checks across orchestration platforms to prevent invalid records from reaching serving layers.

Can I use RRF-based hybrid retrieval for RAG context lakes?

Yes, you can use RRF-based hybrid retrieval for RAG context lakes. This framework governs vector and streaming retrieval patterns, ensuring deterministic retrieval practices across real-time inference architectures.

How do I enforce tenant isolation in ELT data pipelines?

To enforce tenant isolation in ELT data pipelines, apply pre-filtering rules before transformation. This governance practice ensures deterministic data segregation, preventing cross-tenant data leakage during dbt processing.