
Dan Levi Menchaca
Data Engineer | SQL Server & Azure
Designing reliable data platforms, from enterprise SQL Server and ETL systems to modern Azure Data Engineering architectures.
SQL Server · ETL · Azure Data Factory · Databricks · Delta Lake · Data Reliability
Core Expertise
Enterprise data experience meets modern Azure engineering.
| Expertise | Technologies | Description |
|---|---|---|
| SQL Server & Data Integration | T-SQL · SSIS · ETL · Database Optimization | Enterprise data foundations, integration pipelines, and performance engineering. |
| Azure Data Engineering | Azure Data Factory · Databricks · PySpark · Delta Lake · Synapse | Modern ingestion, orchestration, transformation, and analytical serving. |
| Data Reliability & Operations | Data Quality · Monitoring · Recovery · Governance | Reliable, observable, and maintainable data systems with controlled operational behavior. |
Featured Engineering Projects
Real-World Engineering Challenges
Selected examples of reliability and performance challenges addressed in enterprise data environments.
01 — Pipeline performance degradation.Context: A production transactional system experienced slower data extraction and reporting as workloads increased.
Approach: Analyzed SQL execution plans, indexing strategies, and workload distribution. Restructured ETL processes into modular, scheduled workflows and improved ingestion and transformation sequencing.
Outcome: Restored more predictable performance, reduced blocking, and established a more scalable pipeline structure.
02 — Recurring Database Deadlocks.Context: Data integrations between transactional systems and reporting platforms experienced recurring lock contention.
Approach: Analyzed transaction scope, isolation levels, and execution patterns. Optimized data access ordering, reduced lock duration, and adjusted pipeline scheduling.
Outcome: Reduced recurring deadlocks, improved transactional reliability, and stabilized data delivery to analytical platforms.
Engineering Approach
Building data systems with structure, reliability, and long-term thinking.
Architecture First — Understand sources, dependencies, data flows, and downstream consumers before implementation.
Modular & Maintainable — Design reusable pipelines with clear responsibilities and version-controlled logic.
Data Quality by Design — Validate, reconcile, and preserve trustworthy data throughout the lifecycle.
Observability & Recovery — Make failures visible, operations measurable, and recovery predictable.
Performance & Documentation — Optimize deliberately and document engineering decisions for long-term maintainability.
My goal is to build data platforms that teams can understand, operate, and trust.
Beyond the Architecture
This short video shares how I think about data systems as critical infrastructure that supports decisions, operations and trust.



