senior-data-engineer

Architect scalable data pipelines and ETL/ELT workflows across cloud data lakes and warehouses.

9|2|Updated Mar 12, 2026
One-click install
npx skills add https://github.com/hongmaple0820/agent-academy --skill senior-data-engineer-hongmaple0820
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: senior-data-engineer
Source: https://github.com/hongmaple0820/agent-academy/tree/main/skills/others/engineering-team/senior-data-engineer
Command: npx skills add https://github.com/hongmaple0820/agent-academy --skill senior-data-engineer-hongmaple0820

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Data engineers need to design scalable data pipelines and robust data infrastructure to support reliable analytics and data-driven decision-making across the organization.

Core Features & Use Cases

  • Data Architecture Design: create scalable, modular data models and pipelines that support growing data volumes and new data sources.
  • Orchestration & Automation: implement and monitor end-to-end workflows with Airflow, Spark, and dbt to ensure repeatable, auditable data flows.
  • Data Quality & Governance: establish governance practices, data contracts, lineage, and quality checks to protect data trust.
  • Use Case: Build an end-to-end data platform for a retailer enabling real-time analytics, batch reporting, and ML feature pipelines.

Quick Start

Initialize a starter project that sets up a baseline data pipeline with governance scaffolding.

Frequently Asked Questions about senior-data-engineer

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

FAQPage Schema
How do I design scalable data pipelines for both batch and streaming contexts?

To design scalable data pipelines for batch and streaming contexts, architect modular data models and ELT workflows using Airflow, Spark, Kafka, and dbt to ensure repeatable, auditable data flows across cloud data lakes and warehouses.

What's the best way to establish data quality and governance across cloud data warehouses?

Establishing data quality and governance across cloud data warehouses requires implementing data contracts, lineage tracking, and quality checks using Great Expectations alongside modern data stack practices to protect organizational data trust.

Can I use dbt and Airflow together to orchestrate end-to-end ETL workflows?

Yes, you can orchestrate end-to-end ETL workflows by integrating dbt for data transformations with Airflow for scheduling and automation, ensuring repeatable and auditable data flows across your infrastructure.

How do I set up a baseline data pipeline with governance scaffolding?

To set up a baseline data pipeline with governance scaffolding, initialize the starter project to establish foundational ETL workflows, data models, and quality checks for reliable analytics.

Do I need Python and SQL expertise to architect robust data infrastructure?

Yes, architecting robust data infrastructure requires deep expertise in Python and SQL, alongside Spark, Airflow, dbt, and Kafka, to build scalable architectures supporting ETL/ELT workflows and DataOps.

When should I use Kafka over Spark for real-time data pipelines?

Use Kafka for real-time data pipelines to handle streaming data ingestion and event routing, while Spark processes large-scale batch transformations, enabling combined batch and streaming analytics platforms.