engineering-data-engineer

Design and implement ETL/ELT pipelines with Apache Spark and dbt.

Updated Feb 16, 2026
One-click install
npx skills add https://github.com/Adawodu/dynoclaw --skill engineering-data-engineer
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: engineering-data-engineer
Source: https://github.com/Adawodu/dynoclaw/tree/main/skills/engineering-data-engineer
Command: npx skills add https://github.com/Adawodu/dynoclaw --skill engineering-data-engineer

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill addresses the complex challenges of designing, building, and operating robust data infrastructure, ensuring data is reliable, scalable, and accessible for analytics and AI.

Core Features & Use Cases

  • Data Pipeline Engineering: Design and build ETL/ELT pipelines with idempotency, observability, and self-healing capabilities.
  • Data Platform Architecture: Architect cloud-native data lakehouses and implement open table formats.
  • Data Quality & Reliability: Define and enforce data contracts, monitor SLAs, and track data lineage.
  • Streaming & Real-Time Data: Build event-driven pipelines using Kafka and stream processing frameworks.
  • Use Case: A company needs to consolidate customer data from multiple sources into a unified, analytics-ready format. This Skill can design and implement the necessary Bronze, Silver, and Gold data pipelines using Spark and Delta Lake, ensuring data quality and timely delivery.

Quick Start

Use the engineering-data-engineer skill to design a Medallion Architecture data pipeline for customer order data.

Frequently Asked Questions about engineering-data-engineer

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

FAQPage Schema
How do I build data pipelines with Medallion Architecture using Spark and Delta Lake?

To build data pipelines with Medallion Architecture, you design Bronze, Silver, and Gold layers using Apache Spark and Delta Lake to progressively refine raw data into analytics-ready formats. This approach ensures data quality and reliable delivery for downstream consumption.

What is data contract enforcement in data engineering?

Data contract enforcement defines strict schema and quality expectations between data producers and consumers. It prevents pipeline failures by validating data against agreed-upon rules, ensuring reliable downstream analytics and tracking data lineage across the platform.

How do I design ETL pipelines with idempotency and self-healing capabilities?

Designing ETL pipelines with idempotency ensures re-running the same operation yields identical results without duplication. Self-healing pipelines automatically detect and recover from transient failures, maintaining reliable data infrastructure and continuous data flow.

Can I use dbt for ETL pipelines on cloud data platforms like AWS, Azure, and GCP?

Yes, dbt integrates seamlessly with cloud data platforms like AWS, Azure, and GCP to build scalable ELT pipelines. It transforms raw data already loaded into the data lakehouse, enforcing data quality and defining analytical models within the Medallion Architecture.

How do I build event-driven streaming pipelines with Kafka?

Build event-driven streaming pipelines with Kafka by leveraging stream processing frameworks to ingest and transform real-time data. This architecture processes continuous data flows, enabling low-latency analytics and immediate operational insights.

What is the best way to architect a cloud-native data lakehouse?

Architecting a cloud-native data lakehouse involves combining open table formats with scalable cloud infrastructure on platforms like Azure, AWS, or GCP. This design unifies data lake storage flexibility with data warehouse performance, supporting reliable analytics and AI workloads.