# Oscar Josue Melendez

Oscar Josue Melendez is a remote worker on Himalayas, Business Intelligence Specialist at Liberty Latin America, based in Guatemala.

Source: https://himalayas.app/@oscarjosuemelendez

```text
Analytics Engineer specializing in SQL, Python, and end-to-end data pipelines for decision-ready intelligence.
```

| Detail | Value |
| --- | --- |
| Availability | Open to opportunities |
| Location | Guatemala |
| Authorized to work in | Guatemala |
| Job categories | Analytics Engineer, Data Engineer, Business Intelligence Analyst, Data Analyst, Machine Learning Engineer, Product Owner, Business Intelligence Specialist, Analytics Engineer, Data Engineer Jobs, Data Engineering, Data Engineering Jobs, AI Data Engineer, Enterprise Data Engineer |
| Skills | SQL, Python, ETL, ELT, Data Pipelines, Data Ingestion, Prefect, BigQuery, Power BI, Machine Learning, Data Mining, Statistical Analysis, Monte Carlo Simulations, Price Elasticity, Pricing Strategy, Web Scraping, Star Schemas, Dimensional Models, Microsoft SQL Server, Excel, Azure Machine Learning, Azure DevOps, Firebase, Geospatial, Redshift, Slack, Data, Azure, Tiempo, Monte Carlo, Data Engineering, ETL ELT Data Pipelines, Workflow Orchestration, Data Modeling, Snowflake, Cloud Data Warehousing, REST APIs, JSON, Data Quality, Validation, Anomaly Detection, Query Optimization, Cost Optimization, Amazon Redshift, PySpark, Spark, Tableau, R, predictive modeling, Performance Dashboards, ETL ELT, AWS, ML models, Predictive Analytics |

## What I'm looking for

```text
I’m looking for a role where I can own end-to-end analytics and automation—building dependable data pipelines, ML-powered datasets, and dashboards—so stakeholders can make faster, more accurate pricing and operational decisions.
```

## About

```text
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 (current)

Liberty Latin America. Sep 2025 - Present

```text
• Led end-to-end analytics and reporting on hurricanes impact in several Caribbean Markets, integrating heterogeneous data sources (local file systems, Redshift, enterprise DWH, and geospatial APIs). Automated daily delivery of executive-ready dashboards, reports, and presentations, providing leadership with timely, data-driven visibility into impact severity and recovery progress.
• Built Prefect
```

Skills: SQL, Python, Prefect, ETL-ELT, Redshift, Geospatial, Data-Pipelines, Automation, Data-Validation, Report-Automation, Dashboarding, Data-Standardization, Data-Ingestion, Amazon-Redshift, Dashboard-Automation, Query-Optimization

### Business Intelligence Specialist

Liberty Networks. Sep 2025 - Jun 2026

```text
Built analytics and automated workflows using SQL and Python, including ETL/ELT and API-based data ingestion. Delivered executive dashboards and reports on hurricanes impact by creating reliable analytics datasets and layers.
```

Skills: SQL, Python, ETL-ELT, Data-Pipelines, Data-Ingestion, Redshift, Enterprise-Data-Warehousing, Prefect, BigQuery, Data-Modeling, Dashboarding, Query-Optimization, Workflow-Orchestration

### Sr Pricing Data Analyst

Liberty Networks. Jun 2024 - Aug 2025

```text
Applied advanced analytics to estimate price elasticity, segment customers, and inform pricing and revenue optimization. Built multi-market ML price sensitivity models and delivered insights through automated pipelines and dashboards.
```

Skills: advanced-analytics, Price-Elasticity, Customer-Segmentation, Machine-Learning, predictive-modeling, Data-Engineering, ETL-ELT, Workflow-Orchestration, Prefect, Data-Modeling, Snowflake, Anomaly-Detection, Cost-Optimization, BigQuery, Tableau, Power-BI, SQL, Python

### Senior Pricing Data Analyst - Caribbean

Liberty Latin America. Jun 2024 - Aug 2025

```text
• Applied advanced analytics to estimate price elasticity, segment customers, and generate insights that informed pricing/revenue optimization and customer behavior.
• Built a multi-market ML price sensitivity model for prepaid services, integrating usage, revenue, top-up behavior, and demographic/geospatial data.
• Reduced decision-making time for leadership by building analytical solutions that
```

Skills: Machine-Learning, Data-Mining, Pricing-Strategy, Python, SQL, Power-BI, Customer-Segmentation, Price-Elasticity, Web-Scraping

### Sr Financial Data Engineer

Disagro. Apr 2024 - Jun 2024

```text
Implemented structured ETL pipelines and validation processes to improve data reliability for analytics workflows. Delivered business insights using statistical analysis and reporting tools.
```

Skills: Python, SQL, R, Data-Validation, Data-Quality, PySpark, Tableau, Power-BI, Big-Data, Validation, Anomaly-Detection, BigQuery

### Senior Financial Data Analyst

DISAGRO. Apr 2024 - Jun 2024

```text
• Improved data reliability across analytics workflows by implementingstructured ETL pipelines and validation processes.
• Reduced data inconsistencies by introducing validation checks acrossmultiple datasets used for reporting.
• Delivered insights on key business trends through statistical analysis,supporting operational decision-making.
```

Skills: Data-Engineering, ETL, Data-Validation, Statistical-Analysis, Ingeniería-De-Datos, Power-BI, Financial-Reporting, Anaconda

### Senior Data Intelligence Specialist

Grupo Salinas. Jan 2023 - Aug 2023

```text
• Designed and implemented the end-to-end data platform for the Digital Banking division (Banco Azteca mobile app), establishing a scalable and reliable data foundation from the ground up.
• Led the orchestration of data pipelines to ingest high-volume transactional data from multiple sources, including Telecom APIs and Firebase.
• Architected and deployed a dimensional (star schema) data model
```

Skills: Python, Microsoft-SQL-Server, Trabajo-en-Equipo, Star-Schemas, Data-Pipelines, Firebase

### Sr Data Intelligence Specialist

Grupo Salinas. Jan 2023 - Aug 2023

```text
Designed and implemented an end-to-end data platform for the Digital Banking division, including pipeline orchestration and a dimensional star schema data model. Automated ingestion from multiple sources (including Telecom APIs and Firebase) to support analytics and business intelligence decision-making.
```

Skills: SQL, Query-Optimization, ETL-ELT, Workflow-Orchestration, Data-Platform-Development, Python, Data-Modeling, Star-Schemas, Data-Quality, Data-Validation, Firebase, Data-Pipelines, Data-Ingestion

### Agile Product owner (AI for credit risk)

Bam. Jul 2021 - Sep 2022

```text
• Improved collections strategy effectiveness by leading development anddeployment of predictive machine learning models.
• Delivered end-to-end data products by coordinating cross-functional teamsacross data, engineering, and business units.
• Enabled operational use of ML models by integrating predictions intocollections workflows and decision processes.
```

Skills: Inteligência-Artificial, Azure-DevOps, Gestión-Del-Tiempo, Trabajo-en-Equipo

### Product Owner

Agromercantil Bank (Bancolombia). Jul 2021 - Sep 2022

```text
Led development and deployment of predictive machine learning models to improve collections strategy effectiveness. Coordinated cross-functional teams to deliver data products and integrated ML predictions into collections workflows.
```

Skills: Product-Ownership, predictive-modeling, Cross-functional-Coordination, Data-Products, Collections-Workflow, Machine-Learning

### Strategy Data Analyst III

Bam. Jun 2020 - Jul 2021

```text
• Improved collections performance by developing predictive models forcustomer behavior and repayment likelihood.
• Enabled leadership decision-making through development of managementdashboards and performance reports.
• Identified optimization opportunities in collections strategies through datamining and trend analysis.
```

Skills: Trend-Analysis, Inteligência-Artificial, Microsoft-SQL-Server, Python, Trabajo-en-Equipo, Data-Mining

### Data Analyst III

Agromercantil Bank (Bancolombia). Jun 2020 - Jul 2021

```text
Developed predictive models to improve collections performance by analyzing customer behavior and repayment likelihood. Produced management dashboards and performance reports and identified optimization opportunities through data mining and trend analysis.
```

Skills: predictive-modeling, Spark, Customer-Behavioral-Analysis, Repayment-Likelihood, Data-Mining, Trend-Analysis, Dashboarding, performance-reporting, Machine-Learning, Dashboard-And-Reports

### Customer Support & Data Operations

TradersWay. Oct 2017 - Nov 2019

```text
• Worked remotely with an international team supporting an online trading platform. Started in customer support and gradually took on data-related responsibilities.
• Handled daily support via chat/email (40–60 tickets), mostly account and transaction issues
• Investigated trading inconsistencies by reviewing account activity and logs, escalating when needed.
• Extracted and cleaned data from inte
```

Skills: Log-Review, Reporting, Excel, Trabajo-en-Equipo, Customer-Support, Data-Extraction, Data-Cleaning, Slack

### Career transition

Career Break. Jan 2017 - Sep 2017

```text
Needed to find the right career path.
This professional break also allowed me to deep dive into one of my hobbies: Music.
```

### Self-funded Independent Project

Self Employed. Jun 2015 - Dec 2016

```text
Started and managed a small independent e-commerce business, handling day-to-day operations and end-to-end order and payment/logistics management.
```

### Self-funded Independent Project (E-commerce)

Self Employed. Jun 2015 - Dec 2016

```text
• Started and managed a small independent business outside my main field
• Handled day-to-day operations including sourcing, customer communication, and basic marketing
• Managed orders, tracked performance, and handled payments/logistics
• Gained experience working independently and managing end-to-end processes
```

### Central America Purchasing Executive

Claro Guatemala. Nov 2014 - Mar 2015

```text
As part of my minimum required hours of practice to graduate, I was part of the Regional Purchasing Team with the following acomplishments:
• Managed procurement of mobile devices across Central America for direct sales and postpaid plans.
• Worked directly with brands like BlackBerry, Samsung, and Sony to negotiate pricing, secure supply, and define product mix based on market demand.
• Coordin
```

Skills: Product-Mix, Inventory-Planning, Cross-functional-Coordination, Sales-Support, Procurement, vendor-negotiation, Supply-Planning, Inventory-Management

## Education

### Universidad del Valle de Guatemala

Bachelor of Science, Industrial Engineering. 2010 - 2015

```text
Earned a B.S. in Industrial Engineering from Universidad del Valle de Guatemala from 2010 to 2015.
```

### Universidad del Valle de Guatemala

Bachelor of Science in Industrial Engineering, Industrial Engineering. 2010 - 2015

```text
Earned a B.S. in Industrial Engineering from Universidad del Valle de Guatemala from 2010 to 2015.
```

### Universidad del Valle de Guatemala

Engineer's degree, Industrial engineering. 2010 - 2014

## Tech stack

- DATOS
- Microsoft Azure
- PySpark
- Microsoft SQL Server
- Azure DevOps
- JSON
- Azure Machine Learning
- Firebase
- Microsoft Excel
- Tiempo
- Google BigQuery
- Microsoft Power BI
- SQL
- Monte Carlo

To contact Oscar Josue, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Raul Gomez](https://himalayas.app/@raulgomez): Senior Data Analyst, Revelo – Infillion
- [André Rodas](https://himalayas.app/@andrrodas): Data Scientist, Interbanco Guatemala
- [Oscar Perez](https://himalayas.app/@oscarperez): Data Analyst, Genpact
- [Daniel Velez](https://himalayas.app/@danielvelez): BI & Data Analytics Consultant, Independent
- [Nery Herrarte](https://himalayas.app/@neryherrarte): Data Science Specialist, Bayer
- [Emily User](https://himalayas.app/@emilyuser17): Data Modeling Specialist, G&T Continental Bank
- [ludin castillo](https://himalayas.app/@ludincastillo): Data Analytics Specialist, Business Intelligence, Banco Industrial Guatemala
- [Herbert Rafael Reyes Portillo](https://himalayas.app/@herbertrafaelreyespo): Senior Data Engineer, EY
- [Mario Eduardo R�os Mart�nez](https://himalayas.app/@marioeduardorosmartn): Senior Data Analyst, Coforge
- [Ebber Marroquín](https://himalayas.app/@ebbermarroqun): Sr Territory Specialist, Grupo Industrial Mesoamericano
