Loading profile…
Oscar Josue Melendez
Open to opportunitiesBusiness Intelligence Specialist
Analytics Engineer specializing in SQL, Python, and end-to-end data pipelines for decision-ready intelligence.
GuatemalaBusiness Intelligence Specialist at Liberty Latin America
About
I’m an Analytics Engineer with 6+ years building data pipelines, analytics datasets, ML models, and automated workflows across telecommunications and banking. I turn raw data into reliable analytics layers that leadership can trust for pricing, automation, and business decisions.
At Liberty Latin America, I led end-to-end analytics and reporting on hurricanes impact across several Caribbean markets by integrating heterogeneous sources (local file systems, Redshift, enterprise DWH, and geospatial APIs). I automated daily executive-ready dashboards and used Prefect ingestion pipelines to keep 10+ reporting tables up to date, reducing manual reporting effort by ~40%.
Across my roles, I’ve built practical models and data products that move decisions forward—estimating price elasticity, segmenting customers, and delivering a multi-market ML price sensitivity model. I also designed and deployed a dimensional (star schema) data model and orchestrated high-volume ingestion from Telecom APIs and Firebase for the Digital Banking division.
I’m at my best bridging data engineering, analytics, and business stakeholders—standardizing core KPIs, eliminating discrepancies, and enabling consistent performance tracking across teams. I enjoy building automation that creates measurable impact while keeping pipelines dependable and scalable.
Experience
Business Intelligence Specialist
SQLPythonPrefectETL ELTRedshiftGeospatialData Pipelines