Héctor García Barrado

I’m a Data Engineer Consultant based in Spain, with a Computer Science background and practical experience building data-driven systems. I enjoy designing efficient architectures, improving performance, and learning new technologies to deliver reliable, scalable solutions.

At Deloitte Madrid, I’ve designed enhanced semantic data layers and Power BI dashboards, implementing star schemas and tuning complex DAX queries for low-latency performance on critical business reports. I also introduced Git-based workflows for version control, code reviews, and collaborative script deployment across cross-functional teams under Agile/Scrum.

I led a data migration project transferring over 10 terabytes to a cloud-based platform, achieving a 30% reduction in data retrieval time. In Big Data environments with datasets exceeding 100 million records, I structured robust data models and optimized queries using partitioning and tuning to reduce processing times.

I optimize end-to-end performance by reducing average SQL load times from 30 to 5 seconds, improving data warehouse performance and batch efficiency. I also designed and implemented ETL/ELT pipelines using Python to replicate and extend a Data Lake for scalable data access, while securing data quality and availability for Data Scientists and Analysts.