← Back to portfolio

Keyrun Mestre Zalabata

Data Engineer

ETL & Data Quality · SQL · Python · Azure

Summary

Data Engineer with 4+ years building and operating production ETL/ELT pipelines and safeguarding data quality for business-critical systems. Hands-on with SQL, Python, SSIS and Azure Data Factory, with a strong focus on data reliability, validation and automation. MSc candidate in Data Science for Business. Professional English (C1), open to remote roles.

Experience

Data Engineer · IKE Aug 2025 – Present

Remote · Colombia

  • Design and ship end-to-end production ETL pipelines in SSIS (10+, one per client), integrating heterogeneous client files into corporate databases consumed company-wide.
  • Engineer data-quality and business-rule validations (header normalization, layout checks) in SQL and C#, improving the reliability and consistency of ingested data.
  • Built automated email alerting that pinpoints layout/validation errors, cutting correction turnaround and reprocessing.
  • Partner cross-functionally with Commercial, DBA and Production teams to deliver trustworthy data.
Data Quality Analyst · UFINET Jun 2022 – Aug 2025

Colombia

  • Designed and operated ETL/ELT pipelines with Python, SSIS and Azure Data Factory.
  • Defined and monitored data-quality KPIs across SQL Server and PostgreSQL, ensuring accuracy and traceability for business decisions.
  • Delivered Power BI dashboards for corporate teams, cutting reporting time by ~30%.
  • Worked in Agile (Scrum/Kanban) with BI, Data Engineering and business stakeholders.

Featured Project

ClimaLab keyrunmz.com/climalab

Self-built ML weather platform for Valledupar — automated data ingestion, a gradient-boosting temperature model with calibrated prediction intervals, and an interactive bilingual dashboard (MAE ≈ 1.14 °C).

Education

MSc in Data Science for Business Utel University · In progress
BSc in Systems Engineering Universidad Popular del Cesar · 2023

Skills

  • Languages: Python, SQL, C#
  • Data & ETL: SSIS, Azure Data Factory, ETL/ELT, data modeling, data quality & validation
  • Databases: SQL Server, PostgreSQL
  • BI & Visualization: Power BI, Tableau
  • Tools & Practices: Git/GitHub, Advanced Excel, Agile (Scrum/Kanban)

Languages

  • Spanish: Native
  • English: Professional (C1)

Certifications

50+ completed courses on Platzi (Data Engineering, Python, SQL, Cloud, BI) and Google Cloud Skills Boost.
platzi.com/keyrunmz