
Senior Data Engineer
FreeBuild scalable data pipelines and optimize workflows.
Free · Opens the source repo
What Senior Data Engineer does
The Senior Data Engineer skill offers a comprehensive suite of tools and best practices for building and managing scalable data pipelines and ETL/ELT systems. This skill is designed for data professionals who are looking to enhance their capabilities in data architecture, pipeline orchestration, and data quality management. With a focus on production-grade AI/ML systems, it leverages a robust tech stack including Python, SQL, Spark, and Airflow, among others, to facilitate the development of efficient data workflows.
Included within this skill are scripts for pipeline orchestration, data quality validation, and ETL performance optimization, allowing users to automate and streamline their data processes. The references provided cover essential topics such as data pipeline architecture, data modeling patterns, and DataOps best practices, ensuring that users have access to the knowledge required for effective implementation and management of data systems. This skill is particularly beneficial for those involved in designing data architectures, optimizing workflows, and implementing governance practices in data engineering.
In addition to the technical capabilities, the skill emphasizes best practices for development and production environments, including test-driven development, continuous integration, and proactive monitoring. It also addresses security and compliance considerations, making it suitable for organizations that handle sensitive data. The Senior Data Engineer skill is an essential resource for data engineers, data scientists, and technical leads looking to build robust data infrastructures and drive data-driven decision-making within their organizations.
When to use it
Use this skill when designing data architectures, building data pipelines, or optimizing data workflows in production environments.
When not to use it
This skill may not be suitable for simple data tasks or for teams without a focus on scalable data solutions.
What you can build with it
Building a Scalable Data Pipeline
Leverage the pipeline orchestrator script to automate data ingestion and processing, ensuring efficient data flow.
Validating Data Quality
Utilize the data quality validator to analyze and ensure the integrity of your data before it enters production.
Optimizing ETL Performance
Apply the ETL performance optimizer to enhance the efficiency of your data transformation processes.
How to install Senior Data Engineer
View source1. Install with the skills CLI
npx skills add davila7/claude-code-templates/senior-data-engineer --agent claude-code2. Or install it manually
Download the skill folder and drop it into ~/.claude/skills/ for all projects, or .claude/skills/ to scope it to one repo. Restart Claude Code so it picks up the new skill.
Anthropic's agentic coding CLI, and the reference implementation of Agent Skills. Drop a skill folder into ~/.claude/skills and Claude Code loads it automatically whenever a task matches the skill's description. Claude Code docs
Inside SKILL.md
Written by davila7Senior Data Engineer
World-class senior data engineer skill for production-grade AI/ML/Data systems.
Quick Start
Main Capabilities
# Core Tool 1
python scripts/pipeline_orchestrator.py --input data/ --output results/
# Core Tool 2
python scripts/data_quality_validator.py --target project/ --analyze
# Core Tool 3
python scripts/etl_performance_optimizer.py --config config.yaml --deploy
Core Expertise
This skill covers world-class capabilities in:
- Advanced production patterns and architectures
- Scalable system design and implementation
- Performance optimization at scale
- MLOps and DataOps best practices
- Real-time processing and inference
- Distributed computing frameworks
- Model deployment and monitoring
- Security and compliance
- Cost optimization
- Team leadership and mentoring
Tech Stack
Languages: Python, SQL, R, Scala, Go ML Frameworks: PyTorch, TensorFlow, Scikit-learn, XGBoost Data Tools: Spark, Airflow, dbt, Kafka, Databricks LLM Frameworks: LangChain, LlamaIndex, DSPy Deployment: Docker, Kubernetes, AWS/GCP/Azure Monitoring: MLflow, Weights & Biases, Prometheus Databases: PostgreSQL, BigQuery, Snowflake, Pinecone
Reference Documentation
1. Data Pipeline Architecture
Comprehensive guide available in references/data_pipeline_architecture.md covering:
- Advanced patterns and best practices
- Production implementation strategies
- Performance optimization techniques
- Scalability considerations
- Security and compliance
- Real-world case studies
2. Data Modeling Patterns
Complete workflow documentation in references/data_modeling_patterns.md including:
- Step-by-step processes
- Architecture design patterns
- Tool integration guides
- Performance tuning strategies
- Troubleshooting procedures
3. Dataops Best Practices
Technical reference guide in references/dataops_best_practices.md with:
- System design principles
- Implementation examples
- Configuration best practices
- Deployment strategies
- Monitoring and observability
Production Patterns
Pattern 1: Scalable Data Processing
Enterprise-scale data processing with distributed computing:
- Horizontal scaling architecture
- Fault-tolerant design
- Real-time and batch processing
- Data quality validation
- Performance monitoring
Pattern 2: ML Model Deployment
Production ML system with high availability:
- Model serving with low latency
- A/B testing infrastructure
- Feature store integration
- Model monitoring and drift detection
- Automated retraining pipelines
Pattern 3: Real-Time Inference
High-throughput inference system:
- Batching and caching strategies
- Load balancing
- Auto-scaling
- Latency optimization
- Cost optimization
Best Practices
Development
- Test-driven development
- Code reviews and pair programming
- Documentation as code
- Version control everything
- Continuous integration
Production
- Monitor everything critical
- Automate deployments
- Feature flags for releases
- Canary deployments
- Comprehensive logging
Team Leadership
- Mentor junior engineers
- Drive technical decisions
- Establish coding standards
- Foster learning culture
- Cross-functional collaboration
Performance Targets
Latency:
- P50: < 50ms
- P95: < 100ms
- P99: < 200ms
Throughput:
- Requests/second: > 1000
- Concurrent users: > 10,000
Availability:
- Uptime: 99.9%
- Error rate: < 0.1%
Security & Compliance
- Authentication & authorization
- Data encryption (at rest & in transit)
- PII handling and anonymization
- GDPR/CCPA compliance
- Regular security audits
- Vulnerability management
Common Commands
# Development
python -m pytest tests/ -v --cov
python -m black src/
python -m pylint src/
# Training
python scripts/train.py --config prod.yaml
python scripts/evaluate.py --model best.pth
# Deployment
docker build -t service:v1 .
kubectl apply -f k8s/
helm upgrade service ./charts/
# Monitoring
kubectl logs -f deployment/service
python scripts/health_check.py
Resources
- Advanced Patterns:
references/data_pipeline_architecture.md - Implementation Guide:
references/data_modeling_patterns.md - Technical Reference:
references/dataops_best_practices.md - Automation Scripts:
scripts/directory
Senior-Level Responsibilities
As a world-class senior professional:
-
Technical Leadership
- Drive architectural decisions
- Mentor team members
- Establish best practices
- Ensure code quality
-
Strategic Thinking
- Align with business goals
- Evaluate trade-offs
- Plan for scale
- Manage technical debt
-
Collaboration
- Work across teams
- Communicate effectively
- Build consensus
- Share knowledge
-
Innovation
- Stay current with research
- Experiment with new approaches
- Contribute to community
- Drive continuous improvement
-
Production Excellence
- Ensure high availability
- Monitor proactively
- Optimize performance
- Respond to incidents
Frequently asked questions about Senior Data Engineer
Similar skills
Single-Cell RNA-seq QC
Automate quality control for single-cell RNA-seq data.
Instrument Data to Allotrope Converter
Standardize lab data for seamless integration.
SQL Server Table Reconciliation
Efficiently compare SQL Server tables across instances.
Data Cleaning and Variable Screening
Streamline credit risk data preprocessing for modeling.
Arize Dataset
Manage and query Arize datasets efficiently.
Spreadsheet Management
Efficiently create, edit, and analyze spreadsheet files.
