Skip to main content
HS
Looking for a job

Hector Sanchez

@hectorsanchez1

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

Colombia
Message

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

Work history, roles, and key accomplishments

AC

Data Engineer

Axa Colpatria

Jan 2020 - May 2021 (1 year 4 months)

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.

US

Data Analyst Intern

Urban Science

Jul 2018 - Aug 2019 (1 year 1 month)

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

SQL
Data Analysis
Reporting
QU

Power BI Specialist

Quenty

Jul 2016 - Aug 2017 (1 year 1 month)

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%.

Power BI
Data Analysis
Logistics
Reporting

Education

Degrees, certifications, and relevant coursework

Lambton College logoLC

Lambton College

Advanced Project Management in IT, Project Management

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

Royal Holloway, University of London logoRL

Royal Holloway, University of London

Master of Science, Data Science and Analytics

2017 - 2019

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

Cardiff Metropolitan University logoCU

Cardiff Metropolitan University

Bachelor of Science (Honours), Computing

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

Interested in hiring Hector?

You can contact Hector and 600K+ other talented remote workers on Himalayas.

Message Hector

People also viewed

View all talent

Get matched with your dream remote job

Sign up now and join over 1,000,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!

Sign up
Himalayas profile for an example user named Frankie Sullivan