# Estefania Ballesteros

Estefania Ballesteros is a remote worker on Himalayas, Data Analyst at Outrix Intelligence, based in Colombia.

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

```text
Data Analyst at Outrix Intelligence building recurring datasets and Power BI reports from transactional and consumer data.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | Colombia |
| Authorized to work in | Colombia |
| Salary expectations | 30k+ USD |
| Job categories | Data Analyst, Business Intelligence Analyst |
| Skills | SQL, MySQL, Data Analysis, data transformation, Data Modeling, Business Intelligence, Power BI, DAX, Power Query, Python, Pandas, NumPy, Excel, Data Visualization |
| Portfolio | https://github.com/Nia1004/Margen-de-ganancia-OFFICE-DEPOT |

## About

```text
At Outrix Intelligence, I extract and transform transactional and consumer data with SQL, then build and maintain datasets for recurring reports. I document metric definitions, business rules, and data structures.

I calculate metrics such as household penetration, market share, purchasing behavior, and category trends. I also clean and categorize raw and semi-structured data with Python and Power Query, and validate results through business rules and cross-source reconciliation.

At Wiwa Tours | Adventure Travel OP SAS, I analyzed reservation, occupancy, rate, and revenue data using Excel, Power Query, and Python. I presented sales and purchasing-behavior metrics in reports and dashboards to support decision-making.

In my projects, I analyzed retail sales and profitability data in an interactive Power BI dashboard, examined low-season reservation patterns, and compared WTI crude oil volatility. I hold a Diploma in Data Analytics for Decision-Making and a Bachelor's Degree in Business Administration from Universidad del Magdalena.
```

## Experience

### Data Analyst (current)

Outrix Intelligence. Jun 2026 - Present

```text
Wrote and executed SQL queries to extract, join, and transform transactional and consumer data. Built and maintained datasets for recurring reports, calculated business metrics, and developed Power BI dashboards.
```

Skills: SQL, MySQL, Join, Subqueries, CTEs, Window-Functions, CASE, Group-By, Python, Pandas, Power-Query, Power-BI, Data-Validation, Data-Auditing, Business-metrics, Data-Visualization

### Sales Advisor

Wiwa Tours. Nov 2025 - May 2026

```text
Analyzed 4,300+ reservations and occupancy, rate, and revenue data using Excel, Power Query, and Python. Calculated sales and purchasing-behavior metrics and managed availability and rates on OTA extranets.
```

Skills: Excel, Power-Query, Python, Data-Analysis, Sales-Metrics, OTA-Management, Booking, Expedia, Reporting, Dashboarding

### Intern - Billing, Credit & Collections

Universidad del Magdalena. Apr 2025 - Oct 2025

```text
Performed reconciliations and validated billing and receivables records. Developed tabulation and visualization of satisfaction surveys, generating reports and indicators for decision-making.
```

Skills: Reconciliations, Data-Validation, Survey-Analysis, Reporting, Data-Visualization

### Intern - Accounts Receivable Assistant

Clínica Avidanti. Jun 2020 - Nov 2020

```text
Recorded and controlled claim denials and refunds, and supported account reconciliation and review of billing inconsistencies.
```

Skills: Accounts-Receivable, Claims-Management, Reconciliations, Billing

## Education

### Universidad del Magdalena

Diploma in Data Analytics for Decision-Making, Data Analytics. 2026 - 2026

```text
Completed a diploma in Data Analytics for Decision-Making from February to June 2026.
```

### Edutyn Academy

SCRUM Fundamentals, Project Management. 2025 - 2025

```text
Completed SCRUM Fundamentals in 2025.
```

### MINTIC / AvanzaTIC

Technical English for the IT Sector (English for IT 2), English. 2025 - 2025

```text
Completed Technical English for the IT Sector (English for IT 2) in 2025.
```

### Universidad del Magdalena

Bachelor's Degree in Business Administration, Business Administration. 2020 - 2025

```text
Pursued a Bachelor's Degree in Business Administration from August 2020 to December 2025.
```

### CECAP COOTRASENA

Computerized Accounting Assistant, Accounting. 2019 - 2019

```text
Completed a Computerized Accounting Assistant program from February to September 2019.
```

## Tech stack

- Snowflake
- NumPy
- Pandas
- MySQL
- Python
- JSON
- SQL
- Seaborn
- Matplotlib
- Power BI
- Power Query

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

## People also viewed

- [Juan Sebastian Hernandez](https://himalayas.app/@juansebastianhernand): Capacity Optimization Analyst, Avianca
- [Juan Sebastian F](https://himalayas.app/@juansebastianf): Data Engineer, Whiparound
- [Adrien Latil](https://himalayas.app/@AdrienLatil): BI Specialist, Servier
- [Daniela Leguizamon](https://himalayas.app/@danielaleguizamon): Data Analyst, Dirección de Impuestos y Aduanas Nacionales (DIAN)
- [Daniel Ceron Ramirez](https://himalayas.app/@danielceronramirez): Data Analyst, Lean Tech
- [Jose Valbuena](https://himalayas.app/@josevalbuena): Junior Data Analyst, Tracts
- [Valentina Urquijo](https://himalayas.app/@valentinaurquijo): Practicante/Análisis de datos, Takeda Colombia
- [sebastian acosta rojas](https://himalayas.app/@sebastianacostarojas): Co Creator, Innovation Lab, United Way Colombia
- [JAVIER RIVERA](https://himalayas.app/@javierrivera3): ADSI Technologist Intern, SENA Centro de Comercio y Servicios
- [Gabriela Melissa Matallana Bernal](https://himalayas.app/@gabrielamelissamatal): Analista de Datos, Institución de educación superior pública
