senior-data-engineer

Design and orchestrate data pipelines with Python, SQL, Spark, Airflow, and dbt.

Updated Apr 9, 2026
One-click install
npx skills add https://github.com/Patasse97/claude-skills --skill senior-data-engineer-patasse97
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: senior-data-engineer
Source: https://github.com/Patasse97/claude-skills/tree/main/engineering-team/senior-data-engineer
Command: npx skills add https://github.com/Patasse97/claude-skills --skill senior-data-engineer-patasse97

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Data engineering complexity is a bottleneck for building scalable data infrastructure; this skill provides a production-grade framework to design, orchestrate, and govern robust data pipelines across modern tech stacks.

Core Features & Use Cases

  • Data modeling and pipeline orchestration with Python, SQL, Spark, Airflow, and dbt.
  • Batch ETL/ELT design, real-time streaming, and DataOps governance for enterprise data platforms.
  • Architecture decision frameworks, quality checks, and troubleshooting patterns for large-scale data pipelines in data-driven organizations.

Quick Start

Describe how to design and implement a scalable data pipeline from source ingestion to a data warehouse for analytics.

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 and orchestrate scalable data pipelines with Airflow and Spark?

Design scalable data pipelines using Airflow for orchestration and Spark for distributed processing to manage batch ETL and real-time streaming workflows. This combination provides a production-grade architecture for ingesting, transforming, and loading data into analytics platforms.

What is the best way to implement DataOps governance and data quality checks in Python?

Implement DataOps governance and data quality checks in Python by embedding validation rules, monitoring, and automated testing within your pipeline orchestration. This approach ensures reliable, enterprise-grade data infrastructure with consistent quality across ingestion and transformation stages.

Can I use dbt and SQL for data modeling and ELT transformations in a data warehouse?

You can use dbt and SQL to perform data modeling and ELT transformations directly within your data warehouse. This enables structured analytics engineering, allowing you to define, test, and document data models while maintaining governance across large-scale data platforms.

How do I build a real-time streaming data architecture with Kafka?

Build a real-time streaming data architecture with Kafka by configuring topics, producers, and consumers to ingest continuous event streams. This enables low-latency data processing and integrates with Airflow and Spark for end-to-end pipeline orchestration and analytics.

Does this data engineering framework support architecture decision frameworks for enterprise data platforms?

This data engineering framework supports architecture decision frameworks for enterprise data platforms by providing structured patterns for batch ETL, real-time streaming, and governance. It helps evaluate trade-offs across Python, SQL, Spark, and Airflow stacks to design robust infrastructure.

What are common troubleshooting patterns for large-scale data pipelines?

Common troubleshooting patterns for large-scale data pipelines include monitoring job failures in Airflow, debugging Spark memory issues, and validating SQL transformations in dbt. These patterns resolve data quality, orchestration, and performance bottlenecks in production environments.