data-engineering

Original🇺🇸 English
Translated
1 scriptsChecked / no sensitive code detected

Data engineering, machine learning, AI, and MLOps. From data pipelines to production ML systems and LLM applications.

17installs

NPX Install

npx skill4agent add pluginagentmarketplace/custom-plugin-cloudflare data-engineering

Tags

Translated version includes tags in frontmatter

Data Engineering Skill

Quick Reference

RoleFocusTimelineEntry From
Data EngineerPipelines, Infra12-24 moBackend Dev
ML EngineerModels, Features12-24 moData Scientist
AI EngineerLLMs, Agents6-12 moAny Developer

Learning Paths

Data Engineer

[1] SQL Mastery (4-6 wk)
 │  └─ Window functions, CTEs, optimization
[2] Python for Data (4-6 wk)
 │  └─ Pandas, file formats, scripting
[3] ETL/ELT Pipelines (6-8 wk)
 │  └─ Extract, transform, load patterns
[4] Big Data: Spark (8-12 wk)
 │  └─ PySpark, DataFrames, partitioning
[5] Data Warehouse (4-6 wk)
 │  └─ Star schema, dbt, Snowflake/BQ
[6] Orchestration (4-6 wk)
    └─ Airflow/Prefect, scheduling, monitoring
2025 Stack: Python + Spark + Airflow + dbt + Snowflake/BigQuery

ML Engineer

[1] Python + NumPy (4-6 wk)
[2] Math Foundations (6-8 wk)
 │  └─ Linear algebra, calculus, statistics
[3] Classical ML (8-12 wk)
 │  └─ scikit-learn, XGBoost, evaluation
[4] Deep Learning (8-12 wk)
 │  └─ PyTorch, CNNs, Transformers
[5] MLOps (6-8 wk)
    └─ MLflow, model serving, monitoring
2025 Stack: Python + PyTorch + scikit-learn + MLflow + W&B

AI Engineer (2025 Hot Path)

[1] LLM Fundamentals (2-3 wk)
 │  └─ Tokens, embeddings, context windows
[2] Prompt Engineering (2-3 wk)
 │  └─ Few-shot, CoT, structured output
[3] RAG Systems (3-4 wk)
 │  └─ Embeddings, vector DBs, retrieval
[4] AI Agents (4-6 wk)
 │  └─ Tool calling, agent loops, memory
[5] Production Deploy (ongoing)
    └─ Evaluation, guardrails, monitoring
2025 Stack: Python + LangChain/LlamaIndex + OpenAI/Anthropic + ChromaDB

2025 Tool Matrix

Data Processing

ToolScaleUse Case
Pandas<10GBPrototyping, small data
Polars<100GBFast local processing
Spark>100GBDistributed processing
dbtAnyTransformations, testing

ML Frameworks

FrameworkBest ForComplexity
scikit-learnClassical MLLow
XGBoostTabular dataLow
PyTorchResearch, flexibilityMedium
TensorFlowProduction, mobileMedium

LLM/AI Tools

ToolUse Case
LangChainLLM orchestration
LlamaIndexRAG systems
Claude/OpenAILLM APIs
ChromaDBVector storage

Algorithm Reference

Classical ML

TypeAlgorithms
RegressionLinear, Ridge, Lasso, ElasticNet
ClassificationLogistic, SVM, Decision Tree
EnsembleRandom Forest, XGBoost, LightGBM
ClusteringK-Means, DBSCAN, Hierarchical

Deep Learning

ArchitectureUse Case
CNNImages, vision
RNN/LSTMSequences
TransformerNLP, LLMs
DiffusionImage generation

AI Agent Architecture (2025)

┌─────────────────────────────────────────┐
│            AGENTIC LOOP                  │
├─────────────────────────────────────────┤
│  PERCEIVE → REASON → ACT → REFLECT      │
│      │         │       │       │        │
│      │         │       │       └─► Loop │
│      │         │       └─► Execute tools│
│      │         └─► LLM decides action   │
│      └─► Gather context, observations   │
└─────────────────────────────────────────┘

Design Patterns (Anthropic 2025):
• Prompt Chaining - Sequential fixed steps
• Routing - Classify and dispatch
• Parallelization - Concurrent subtasks
• Orchestrator-Workers - Central delegation
• Evaluator-Optimizer - Generate + critique

Troubleshooting

Which path to choose?
├─► Love building infrastructure? → Data Engineer
├─► Love algorithms/math? → ML Engineer
├─► Want fastest AI entry? → AI Engineer
└─► Uncertain? → Start with Python + SQL

Model not performing well?
├─► Data quality issues? → Clean data first
├─► Feature engineering? → Create better features
├─► Wrong algorithm? → Try different models
├─► Overfitting? → More data, regularization
└─► Hyperparameters? → Grid/random search

LLM giving bad answers?
├─► Prompt too vague? → Be more specific
├─► Missing context? → Add relevant info
├─► Hallucinating? → Use RAG, verify facts
└─► Wrong tool? → Improve tool descriptions

Common Failure Modes

SymptomRoot CauseRecovery
Model fails in prodData driftMonitor distributions
Pipeline always lateUnoptimized queriesProfile, partition
RAG finds wrong docsBad chunkingTune chunk size, overlap
Agent loops foreverNo exit conditionAdd max iterations

Portfolio Projects

Data Engineering

  1. ETL Pipeline (Airflow + dbt)
  2. Real-time Streaming (Kafka + Spark)
  3. Data Warehouse Design

ML Engineering

  1. Classification Model (scikit-learn)
  2. Deep Learning Model (PyTorch)
  3. ML Pipeline (MLflow)

AI Engineering

  1. RAG Chatbot (LangChain + ChromaDB)
  2. AI Agent with Tools
  3. Multi-Agent System

Next Actions

Specify your target role for a detailed learning plan.