data-eng

Design and build ETL/ELT pipelines with Medallion Architecture on cloud platforms.

2|Updated Feb 25, 2026
One-click install
npx skills add https://github.com/elihuvillaraus/skills --skill data-eng
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: data-eng
Source: https://github.com/elihuvillaraus/skills/tree/main/data-eng
Command: npx skills add https://github.com/elihuvillaraus/skills --skill data-eng

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pyspark, dbt-core, great_expectations, kafka-python, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill automates the creation and maintenance of robust, scalable data pipelines and lakehouse architectures, transforming raw data into trusted, analytics-ready assets.

Core Features & Use Cases

  • ETL/ELT Pipeline Development: Design and build idempotent, observable, and self-healing data pipelines.
  • Lakehouse Architecture: Implement Medallion Architecture (Bronze, Silver, Gold) on cloud platforms.
  • Data Quality & Reliability: Enforce data contracts, monitor SLAs, and implement lineage tracking.
  • Streaming Data: Build event-driven pipelines with Kafka and stream processing frameworks.
  • Use Case: Automatically ingest data from multiple sources, cleanse and conform it in the Silver layer, and aggregate it into business-ready metrics in the Gold layer, ensuring data quality and timely delivery.

Quick Start

Use the data-eng skill to build a bronze layer pipeline for ingesting JSON data from '/path/to/source' into 's3://my-bucket/bronze/events'.

Frequently Asked Questions about data-eng

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

FAQPage Schema
What is the Medallion Architecture for building a lakehouse data pipeline?

Medallion Architecture organizes data pipelines into Bronze, Silver, and Gold layers. It transforms raw ingested data into cleansed, conformed assets, then aggregates them into business-ready metrics using open table formats like Delta Lake or Iceberg.

How do I build an ETL pipeline that enforces data quality and tracks lineage?

To build reliable ETL pipelines with enforced data quality, you can use frameworks like Great Expectations alongside dbt-core. This combination enables data contract enforcement, SLA monitoring, and automated lineage tracking across your transformations.

How do I process streaming data using Kafka in an event-driven pipeline?

Processing streaming data with Kafka involves building event-driven pipelines using the kafka-python client. This allows you to ingest real-time events and process them through stream processing frameworks into your lakehouse storage.

Can I use PySpark and dbt-core together for ELT transformations?

Yes, PySpark and dbt-core work together for ELT transformations. PySpark handles distributed data processing, while dbt-core manages the SQL-based data modeling and transformation logic within your lakehouse architecture.

What is the best way to ingest raw JSON data into a lakehouse bronze layer?

The best way to ingest raw JSON into a bronze layer is to build an automated data pipeline that reads from your source path and writes to cloud storage like S3, ensuring the pipeline is idempotent and observable for reliable raw data landing.

How does Great Expectations enforce data contracts in an ETL pipeline?

Great Expectations enforces data contracts in ETL pipelines by defining explicit data quality rules and validation checks. This ensures raw data conforms to expected schemas and standards before moving to downstream Silver or Gold layers.