# Hector Sanchez

Hector Sanchez is a remote worker on Himalayas, Senior Data Engineer at Lean Solutions Group, based in Colombia.

Source: https://himalayas.app/@hectorsanchez1

```text
Senior Data Engineer at Lean Solutions Group who cut pipeline runs from 3 hours to 25 minutes.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | Colombia |
| Authorized to work in | Colombia |
| Salary expectations | 69k+ USD |
| Job categories | Data Engineer, Data Analyst, Power BI Specialist |
| Skills | Data Engineering, Databricks, Delta Live Tables, Delta Lake, Azure Data Factory, Medallion Architecture, Data Modeling, ETL ELT, Materialized Views, Data Quality Checks, SQL, Python, PySpark, Spark SQL, Power BI |
| LinkedIn | https://linkedin.com/in/hector-sanchez-d |

## About

```text
At Lean Solutions Group, I took part in migrating 240 tables from Azure to Databricks, building three Delta Live Tables pipelines across bronze, silver, and gold. I designed silver-layer data models and worked with BI developers and business analysts on requirements.

I cut pipeline run time from 3 hours to 25 minutes by building and tuning about 240 materialized views, and data quality issues fell by 30% after I added automated checks and monitoring. I also built Azure Data Factory pipelines that saved operations, finance, and BI teams 8 days of manual work per month.

Previously, at Axa Colpatria, I built daily ETL pipelines in Microsoft SSIS and automated Power BI dashboards that saved about USD 300,000 in operating costs over one year. At Urban Science, I wrote SQL checks and delivered client reporting for 11 European countries; at Quenty, I developed Power BI logistics analytics that cut transportation costs by 30%.
```

## Experience

### Senior Data Engineer (current)

Lean Solutions Group. May 2021 - Present

```text
Migrated 240 tables from Azure to Databricks, building Delta Live Tables pipelines and reducing pipeline run time from 3 hours to 25 minutes. Improved data quality and deployment frequency through automation and Databricks Asset Bundles.
```

Skills: Databricks, Delta-Live-Tables, Delta-Lake, Unity-Catalog, Azure-Data-Factory, SQL, Python, PySpark, Spark-SQL, Data-Modeling, ETL, Data-Quality, CI-CD, Databricks-Asset-Bundles, GitHub, Azure-DevOps

### Data Engineer

Axa Colpatria. Jan 2020 - May 2021

```text
Built daily ETL pipelines in SSIS and automated Power BI dashboards, saving approximately USD 300,000 in operating costs. Wrote Python and SQL scripts for data cleaning and quality assessments.
```

Skills: SSIS, ETL, Power-BI, Python, SQL, Data-Quality

### Data Analyst Intern

Urban Science. Jul 2018 - Aug 2019

```text
Wrote SQL stored procedures and queries to check data correctness and completeness. Delivered client reporting for 11 European countries.
```

Skills: SQL, Data-Analysis, Reporting

### Power BI Specialist

Quenty. Jul 2016 - Aug 2017

```text
Developed a Power BI logistics analytics solution that cut client transportation costs by 30% and improved delivery-time accuracy by 20%. Migrated legacy reports to Power BI, reducing reporting errors by 30%.
```

Skills: Power-BI, Data-Analysis, Logistics, Reporting

## Education

### Lambton College

Advanced Project Management in IT, Project Management

```text
Completed an Advanced Project Management in IT program at Lambton College in 2024.
```

### Royal Holloway, University of London

Master of Science, Data Science and Analytics. 2017 - 2019

```text
Completed an MSc in Data Science and Analytics at Royal Holloway, University of London from 2017 to 2019.
```

### Cardiff Metropolitan University

Bachelor of Science (Honours), Computing

```text
Completed a BSc (Hons) in Computing at Cardiff Metropolitan University in 2016.
```

## Tech stack

- GitHub
- PySpark
- dbt
- Databricks
- Azure DevOps
- Python
- Git
- SQL
- XGBoost
- Delta Lake
- Unity Catalog
- Power BI
- Azure Data Factory

To contact Hector, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [juan david angel rubio](https://himalayas.app/@juandavidangelrubio): Data Engineering, Nubiral
- [David Santiago](https://himalayas.app/@davidsantiago1): BI Data Engineer, Txool Evolucion
- [Julieth Patiño Garcia](https://himalayas.app/@juliethpatiogarcia): BI Engineer | Analytics Eng, Picap App
- [Juan Valbuena](https://himalayas.app/@juanvalbuena1): DataOps Analyst, Kin + Carta (Valtech)
- [Luis Alonso Copete Copete](https://himalayas.app/@luisalonsocopetecope): Senior Data Engineer, CI&T
- [Miguel Sierra](https://himalayas.app/@miguelsierra): Automation Lead, Quantum Developers
- [Santiago Valencia Rosero](https://himalayas.app/@santiagovalenciarose): Analytics Engineer, Core Analítica
- [Carlos Mario Hoyos Rios](https://himalayas.app/@carlosmariohoyosrios): BI Developer (Data Engineering), Banco de Occidente
- [Jose Alfredo Rangel Baron](https://himalayas.app/@josealfredorangelbar): Ingeniero de Datos, IData Global
- [Maria Lucia Gaviria Mesa](https://himalayas.app/@marialuciagaviriames): Cloud Solutions Engineer, Sistecrédito
