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.

ExpertiseTechnologiesDescription
SQL Server & Data IntegrationT-SQL · SSIS · ETL · Database OptimizationEnterprise data foundations, integration pipelines, and performance engineering.
Azure Data EngineeringAzure Data Factory · Databricks · PySpark · Delta Lake · SynapseModern ingestion, orchestration, transformation, and analytical serving.
Data Reliability & OperationsData Quality · Monitoring · Recovery · GovernanceReliable, 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.

Let's Connect

Interested in fully remote Data Engineering opportunities where SQL Server, ETL, Azure, and data reliability come together.If your team is building reliable data pipelines, modernizing data platforms, or scaling Azure-based solutions, I'd be glad to connect.