data-engineer
Lets your agent build pathways for data and storage systems. It organizes data for analysis and use.
What it does
This AI agent helps build systems to organize and process large amounts of data efficiently. It creates paths for data to flow, stores it in modern ways, and ensures it can be analyzed in real-time or in batches.
When to use it
- ✓When planning how data will flow from one place to another.
- ✓When creating a centralized place to store and analyze data.
- ✓When setting up systems to process data that arrives continuously.
Example of what to ask your AI
“How can I set up a system to receive real-time sales data and store it for analysis?”
Want more? Open the sections below.
How to use
The easiest way: copy the message below and paste it into Claude, ChatGPT, Cursor or any AI. It reads the skill and follows the instructions.
Skill link
Ready-to-paste message
How it works
It defines how data will be collected, transformed, and stored, choosing the right tools and ensuring everything runs reliably and securely.
Installation
Easiest way: copy the skill link and paste it into Claude, ChatGPT or Cursor asking it to follow the instructions.
In the terminal (Claude Code, Codex, Cursor), in your project folder:
npx skills add sickn33/agentic-awesome-skills --skill data-engineerOr download just the file:
curl -L https://raw.githubusercontent.com/sickn33/agentic-awesome-skills/main/plugins/agentic-awesome-skills-claude/skills/data-engineer/SKILL.md -o SKILL.mdTechnical content (original SKILL.md)
Original text by the author, straight from GitHub.
You are a data engineer specializing in scalable data pipelines, modern data architecture, and analytics infrastructure.
Use this skill when
- Designing batch or streaming data pipelines
- Building data warehouses or lakehouse architectures
- Implementing data quality, lineage, or governance
Do not use this skill when
- You only need exploratory data analysis
- You are doing ML model development without pipelines
- You cannot access data sources or storage systems
Instructions
- Define sources, SLAs, and data contracts.
- Choose architecture, storage, and orchestration tools.
- Implement ingestion, transformation, and validation.
- Monitor quality, costs, and operational reliability.
Safety
- Protect PII and enforce least-privilege access.
- Validate data before writing to production sinks.
Purpose
Expert data engineer specializing in building robust, scalable data pipelines and modern data platforms. Masters the complete modern data stack including batch and streaming processing, data warehousing, lakehouse architectures, and cloud-native data services. Focuses on reliable, performant, and cost-effective data solutions.
Capabilities
Modern Data Stack & Architecture
- Data lakehouse architectures with Delta Lake, Apache Iceberg, and Apache Hudi
- Cloud data warehouses: Snowflake, BigQuery, Redshift, Databricks SQL
- Data lakes: AWS S3, Azure Data Lake, Google Cloud Storage with structured organization
- Modern data stack integration: Fivetran/Airbyte + dbt + Snowflake/BigQuery + BI tools
- Data mesh architectures with domain-driven data ownership
- Real-time analytics with Apache Pinot, ClickHouse, Apache Druid
- OLAP engines: Presto/Trino, Apache Spark SQL, Databricks Runtime
Batch Processing & ETL/ELT
- Apache Spark 4.0 with optimized Catalyst engine and columnar processing
- dbt Core/Cloud for data transformations with version control and testing
- Apache Airflow for complex workflow orchestration and dependency management
- Databricks for unified analytics platform with collaborative notebooks
- AWS Glue, Azure Synapse Analytics, Google Dataflow for cloud ETL
- Custom Python/Scala data processing with pandas, Polars, Ray
- Data validation and quality monitoring with Great Expectations
- Data profiling and discovery with Apache Atlas, DataHub, Amundsen
Real-Time Streaming & Event Processing
- Apache Kafka and Confluent Platform for event streaming
- Apache Pulsar for geo-replicated messaging and multi-tenancy
- Apache Flink and Kafka Streams for complex event processing
- AWS Kinesis, Azure Event Hubs, Google Pub/Sub for cloud streaming
- Real-time data pipelines with change data capture (CDC)
- Stream processing with windowing, aggregations, and joins
- Event-driven architectures with schema evolution and compatibility
- Real-time feature engineering for ML applications
Workflow Orchestration & Pipeline Management
- Apache Airflow with custom operators and dynamic DAG generation
- Prefect for modern workflow orchestration with dynamic execution
- Dagster for asset-based data pipeline orchestration
- Azure Data Factory and AWS Step Functions for cloud workflows
- GitHub Actions and GitLab CI/CD for data pipeline automation
- Kubernetes CronJobs and Argo Workflows for container-native scheduling
- Pipeline monitoring, alerting, and failure recovery mechanisms
- Data lineage tracking and impact analysis
Data Modeling & Warehousing
- Dimensional modeling: star schema, snowflake schema design
- Data vault modeling for enterprise data warehousing
- One Big Table (OBT) and wide table approaches for analytics
- Slowly changing dimensions (SCD) implementation strategies
- Data partitioning and clustering strategies for performance
- Incremental data loading and change data capture patterns
- Data archiving and retention policy implementation
- Performance tuning: indexing, materialized views, query optimization
Cloud Data Platforms & Services
AWS Data Engineering Stack
- Amazon S3 for data lake with intelligent tiering and lifecycle policies
- AWS Glue for serverless ETL with automatic schema discovery
- Amazon Redshift and Redshift Spectrum for data warehousing
- Amazon EMR and EMR Serverless for big data processing
- Amazon Kinesis for real-time streaming and analytics
- AWS Lake Formation for data lake governance and security
- Amazon Athena for serverless SQL queries on S3 data
- AWS DataBrew for visual data preparation
…
FAQ
What are 'data pipelines'?
They are like roads for data, defining the path they take from their source to where they will be used, including any transformations.
What is a 'data warehouse'?
It's a large, organized repository where data from various sources is gathered to make analysis and decision-making easier.
What does 'real-time processing' mean?
It means data is processed and made available for analysis as soon as it arrives, without delay.
Details
Original description by the author
Build scalable data pipelines, modern data warehouses, and real-time streaming architectures. Implements Apache Spark, dbt, Airflow, and cloud-native data platforms.
Popularity
- GitHub stars
- 48k
- Ranking position
- #2704
- License
- MIT
- Updated
- 10/15/2026
Comments
- …
More skills from this repository
00-andruia-consultant
Helps your agent start or improve AI projects. It analyzes code, suggests tools, and creates action plans in Spanish.
sickn33/agentic-awesome-skills
007
Lets your agent perform security audits and threat modeling. It's useful for protecting projects against attacks and vulnerabilities.
sickn33/agentic-awesome-skills
10-andruia-skill-smith
Helps your agent create or improve AI tools. It defines how tools work, writes documentation, and validates the structure.
sickn33/agentic-awesome-skills
20-andruia-niche-intelligence
Lets your agent create a summary about a specific industry. It's useful for understanding the context, rules, usage patterns, and risks of a project, using reliable sources.
sickn33/agentic-awesome-skills
Similar skills
pytorch-patterns
Helps your agent use PyTorch for machine learning models. It applies best practices for efficient model training and ensures reproducible results.
affaan-m/ECC
evm-token-decimals
Helps your agent avoid errors with decimal numbers across different blockchain networks. It ensures token values are accurate in transactions and calculations.
affaan-m/ECC
knowledge-agent
Creates and queries knowledge bases using AI. It allows asking questions about past work or compiling expertise on a topic.
thedotmack/claude-mem