I

Irvin Oliva

About

Detail

Data & AI Engineer
Guatemala, Guatemala

Timeline


work
Job
school
Education
folder
Project

Résumé


Jobs verified_user 0% verified
  • L
    Lead Data & AI Engineer public Remote experience
    Feb 2026 - Current (6 months)
    Designed and shipped an end-to-end data + AI platform to optimize short-term-rental performance in the Guatemala City market: competitive market scraping, a Medallion Data Lakehouse, and a RAG-based AI co-host that answers guest inquiries in the host's own voice. Architected a Medallion Data Lakehouse (Bronze/Silver/Gold) on Delta Lake, refining raw web-scraped JSON into analytics-ready Gold tables with ACID guarantees, schema enforcement, and time travel. Built Dockerized Playwright scrapers to mine competitive Airbnb listings (pricing, occupancy, ratings) into the Bronze layer. Utilized DuckDB and MotherDuck for high-performance OLAP processing, enabling seamless synchronization between local development and cloud-based production enviro
  • Halo
    Data Engineer and Business Analyst
    Halo
    Jul 2025 - Current (1 year 1 month)
    As a Data Engineer and Business Analyst, I built a Lakehouse Architecture & Design with a Medallion-type Architecture (Bronze, Silver, Gold) pipeline within Databricks on AWS to centralize disparate data sources, utilizing Delta Lake for ACID transaction support that supports an AI agent and is governed by Databricks' Unity Catalog. I translated high-level business goals for the MarketInSight initiative into granular technical Epics and User Stories, defining clear Acceptance Criteria for data engineering-focused sprints. Led technical Spikes to investigate enterprise platform constraints, identifying and documenting approved architectural alternatives. Achieved a 34.2% absolute increase in data match rates (from 5.3% to 39.5%) by deploying
  • L
    Web Developer and Sales Engineer Team Lead
    Livebuyers
    Jan 2024 - Jul 2025 (1 year 7 months)
    As a Web Developer and Sales Engineer Team Lead, I built a premium WordPress template customized with HTML, JavaScript, and CSS, specifically designed for Realtors across the US, resulting in an average monthly sales increase of 28%. I constructed and launched 8 to 12 web pages daily for clients, utilizing WordPress, HTML, JavaScript, and CSS. My role involved conducting comprehensive research on clients, including social media profiles, reviews, and work sites, to tailor web page designs to their specific needs and preferences. I developed realtor pages for clients, incorporating essential features and information, while configuring and integrating web pages with Cloudflare, managing DNS records, and ensuring SSL secure server connections.
  • Bantrab
    Data Scientist on Credit Risk Solutions
    Bantrab
    Mar 2023 - Oct 2024 (1 year 8 months)
    As a Data Scientist on Credit Risk Solutions, I conducted a thorough analysis of BANTRAB's micro, small, and medium-sized company portfolio, assessing atrophy, demographic distribution, and customer banking percentages, as well as analyzing transaction processing information within the credit card portfolio. I utilized categorical machine learning techniques to develop a predictive forecasting model that identified critical contributors to credit default risk, pinpointing the top three factors associated with the highest likelihood of default. This enabled the implementation of proactive risk management strategies. Collaborating with various departments, I helped revise policies based on insights from the predictive model. I also developed
  • Allied Global
    Sales Rep - Account Executive
    Allied Global
    Feb 2022 - Mar 2023 (1 year 2 months)
    Resolved escalated customer issues via cold transfers from customer service, troubleshooting technical/service problems to retain client relationships. Managed inbound calls (35+/day) from direct website leads and outbound follow-ups (8 calls/22 emails daily), maintaining an average call duration of 560+ seconds. Consistently doubled bi-weekly sales quotas (100+ sales), closing 200+ sales every two weeks (peaking at 450 monthly sales, 40% above team average). Ranked Top 3 sales performer among 76 agents, driven by 61% KPI efficiency in closing deals (department avg: 51%). Volunteered for overtime shifts to maximize revenue opportunities and exceed personal/team targets. Mastered GDS systems and CRM tools to streamline bookings, upsell trave
  • I
    Data Scientist in Business and Financial solutions
    Ikopedo
    Jan 2021 - Jan 2022 (1 year 1 month)
    As a Data Scientist in Business and Financial Solutions, I led an engineering team to successfully manage major infrastructure projects, ensuring on-time and on-budget execution. I designed and developed the website for the Zona Industrial Uno project, enhancing the project's online presence and showcasing my web design skills. Leveraging data mining and analysis, I saved approximately Q. 46M (about $5.90M) in the Industrial Zone One Project. I introduced SCRUM methodology to the construction area, enhancing project development efficiency, reporting, and fostering collaboration among multidisciplinary teams using CRM software and ERP systems. I supervised machine learning time series regression models with ARIMA to evaluate the viability of
  • M
    Data Engineer
    Mineria Futura
    Dec 2018 - Jan 2021 (2 years 2 months)
    As a Data Engineer, I utilized machine learning techniques to create statistical models for assessing the feasibility of the "Taller Industrial Movimientos Masivos" project, resulting in cost savings of Q.16M. I designed the general website of Mineria Futura in its local domain and applied SEO standards to enhance its marketability. My responsibilities included collecting, cleaning, and visualizing project data using Microsoft Power BI and SQL Server, which facilitated data-driven evaluation and decision-making with the board of directors. I oversaw infrastructure projects, managed assembly, and handled a budget totaling Q. 2.6M for the CGN Mechanical Workshop. Additionally, I developed a Python and SQL Server program for precise materials
Education verified_user 0% verified
  • Universidad Francisco Marroquín
    Master in Finance
    Universidad Francisco Marroquín
    Jul 2024 - Dec 2025 (1 year 6 months)
  • Universidad del Valle de Guatemala
    Bachelor in Science on Mechatronics Engineering
    Universidad del Valle de Guatemala
    Jan 2015 - Dec 2020 (6 years)
Projects (professional or personal) verified_user 0% verified
  • Airbnb
    Personal
    Airbnb Automated Data Pipeline
    Airbnb, Personal
    Jan 2026 - Current (7 months)
    Architected and deployed an automated daily ETL pipeline to extract short-term rental market data across various zones in Guatemala City. Utilized Python and Selenium for dynamic web scraping, handling raw JSON ingestion, and processing the data into optimized "silver-tier" Parquet files for downstream analytics. Managed version control and daily syncs using Git.
  • Mercer
    Market Insight
    Mercer
    Jul 2025 - Current (1 year 1 month)
    As a Market Insight professional, I led the end-to-end architecture and deployment of the "Market Insight" data platform, migrating legacy systems to a Medallion Lakehouse architecture on AWS Databricks. In my dual role as a Data Engineer and Business Analyst, I effectively bridged the gap between business strategy and technical execution. I was responsible for the full data lifecycle—from gathering requirements and defining Agile stories to engineering Bronze/Silver/Gold pipelines, implementing Unity Catalog governance, and optimizing high-volume data processing algorithms. The initiative successfully centralized disparate data sources to support AI agents and BI analytics. Key Achievements: - Match Rate Optimization: Increased data mat
  • Universidad Francisco Marroquín
    Automated Stock Portfolio Valuation
    Universidad Francisco Marroquín
    Apr 2025 - Current (1 year 4 months)
    As an Automated Stock Portfolio Valuation specialist, I designed and implemented a Python-based quantitative workflow that automates the technical analysis of equity options, leveraging historical price and volume data from Yahoo Finance. I integrated a local Large Language Model (LLM) to bridge the gap between hard quantitative signals and qualitative financial reasoning, creating a hybrid analysis tool for institutional-grade evaluation. Key Achievements: - **Quantitative Feature Pipeline**: Engineered a robust pipeline calculating 10+ technical indicators (EMAs, WMAs, MACD, Stochastic Oscillator) and developed signal generation systems with crossover rules for trend detection across 5Y, 1Y, and 6M horizons. - **GenAI Integration**: I
  • Bantrab
    Credit Risk Analysis and Forecasting
    Bantrab
    Mar 2023 - Oct 2024 (1 year 8 months)
    As a Credit Risk Analysis and Forecasting professional, I conducted an in-depth analysis of BANTRAB’s micro, small, and medium enterprise portfolio, evaluating client attrition, demographic distribution, and levels of financial inclusion, as well as transaction processing data within the credit card portfolio. I applied categorical machine learning techniques to develop a predictive forecasting model that identifies key contributors to credit default risk, successfully pinpointing the top three factors most strongly associated with credit default. This enabled the implementation of proactive risk management strategies. Collaborating with multiple departments, I helped implement revised policies based on insights from the predictive model.