# Julio Pradenas

Julio Pradenas is a remote worker on Himalayas, Senior Data Scientist at CSA Ingeniería, based in Chile.

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

```text
Senior Data Scientist at CSA Ingeniería who improved solar project forecast accuracy by 25%.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | Chile |
| Authorized to work in | Chile |
| Salary expectations | 14960k+ CLP |
| Job categories | Business Intelligence Analyst, Business Analyst, Data Analyst |
| Skills | Business Intelligence, Data Science, predictive modeling, SQL, BigQuery, Power BI, Looker, Data Pipelines, ETL, Data Modeling, Star Schemas, Data Quality, Data Governance, KPI Design, DBT |
| Portfolio | https://github.com/JulioPradenas |

## About

```text
At CSA Ingeniería, I built automated Power BI dashboards connected to data pipelines, replacing manual consolidation and giving teams up-to-date operational KPIs. I also developed Python predictive models for solar project resource planning, improving forecast accuracy by 25% and execution timelines by 30%.

For retail post-sale analytics, I built an end-to-end pipeline with BigQuery, dbt and Airflow, then created Power BI and Looker Studio reports for operations and customer service leads. The analysis showed that late orders generated contacts 2.4 times more often than on-time orders.

At BBosch Chile, I automated ETL pipelines and report generation in Python and SQL, reducing data preparation time by 40%. I also led a data governance and documentation framework that passed external audits across more than 300 structures with zero observations.
```

## Experience

### Senior Data Scientist (current)

CSA Ingeniería. Jan 2024 - Present

```text
Built automated Power BI dashboards and integrated LLM-based assistants into workflows. Developed predictive models in Python for solar project resource planning, improving forecast accuracy by 25% and execution timelines by 30%.
```

Skills: Power-BI, Python, LLM, predictive-modeling, Data-Pipelines, Data-Visualization

### Data Scientist

Staff Sizing & Headcount Planning. Jan 2023 - Dec 2024

```text
Designed a layered dimensional model in BigQuery for an international airline. Built executive Looker Studio dashboards and a conversational agent using Claude API for SQL queries.
```

Skills: BigQuery, SQL, Looker, Claude-APIs, Data-Modeling, Conversational-AI

### Data and Analytics Specialist

BBosch Chile. Jan 2019 - Dec 2023

```text
Gathered reporting requirements and consolidated data into a single source of truth with Tableau dashboards. Automated ETL pipelines and report generation, reducing data preparation time by 40%.
```

Skills: SQL, Python, Tableau, ETL, Data-Governance, Data-Validation

### BI Analyst

Meli Fulfillment – Delivery Promise. Jan 2026 - Present

```text
Built a Google Cloud pipeline from raw shipment data to a five-page Looker Studio report. Analyzed 32,000 shipments and computed KPIs with a quarantine layer for data accuracy.
```

Skills: SQL, Google-Cloud-Platform, Looker, Data-Pipelines, Data-Analysis, Data-Quality

### AI Developer

HogarTech – WhatsApp AI Agent. Jan 2026 - Present

```text
Built a customer-service and sales agent using LangGraph, Gemini, and RAG over PostgreSQL and pgvector, integrated with WhatsApp Cloud API.
```

Skills: LangGraph, Gemini, RAG, PostgreSQL, Pgvector, WhatsApp-Cloud-API, AI-Agents

### BI Analyst

Retail Post-Sale Analytics. Jan 2026 - Present

```text
Built an end-to-end analytics pipeline for retail e-commerce post-sale using BigQuery, dbt, and Airflow. Designed Power BI and Looker Studio reports and identified key insights linking delivery performance to contact center cost.
```

Skills: SQL, BigQuery, DBT, Airflow, Power-BI, Looker, Data-Modeling, Data-Validation

### BI Analyst

KORA Deportes – Retail Logistics. Jan 2026 - Present

```text
Ran requirements workshops and modeled ERP and WMS exports into BigQuery layers. Delivered a five-page Looker Studio report and optimized SQL with partitioning and clustering.
```

Skills: SQL, BigQuery, Looker, Data-Modeling, Requirements-Gathering, Query-Optimization

## Education

### Desafío Latam

Bootcamp, Data Science. 2023 - 2023

```text
Data Science Bootcamp completed in 2023.
```

### Instituto Profesional Virginio Gómez

Programming Analyst, Programming. 2019 - 2019

```text
Programming Analyst program completed in 2019.
```

### Universidad Católica de la Santísima Concepción

Bachelor of Science, Biology. Grade: with distinction

```text
B.Sc. in Biology with distinction.
```

## Tech stack

- Snowflake
- Tableau
- Looker
- Metabase
- GitHub Actions
- NumPy
- Pandas
- dbt
- PostgreSQL
- Python
- Gemini
- Google Sheets
- pytest
- Git
- Airflow
- SQL
- pgvector
- LangGraph
- uv
- Power BI
- Looker Studio
- Claude API

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

## People also viewed

- [Pamela Martinez](https://himalayas.app/@pamelamartinez): Data Scientist, Anticipa
- [Tobias Carvajal](https://himalayas.app/@tobiascarvajal): Senior Data Analyst, Entel
- [Francisco Moreira](https://himalayas.app/@franciscomoreira1): Senior BI Analyst, Coca Cola Embonor S.A.
- [Camilo Álvarez Alchagueñin](https://himalayas.app/@camilolvarezalchague): Data Engineer, ADT
- [Francisco Marambio Correa](https://himalayas.app/@franciscomarambiocor): Data Project Lead & BI Engineer, Ecomac Chile
- [Diego Alexis Baeza Herrera](https://himalayas.app/@diegoalexisbaezaherr): Jefe Corporativo de Data & Analytics, Grupo Falabella
- [Javier User](https://himalayas.app/@javieruser5): Analytics Engineer, Clínica Alemana de Santiago
- [Benjamin Santibanez](https://himalayas.app/@benjaminsantibanez): Senior Analyst, Strategy & Growth, Mercado Libre
- [Adrián Sanhueza](https://himalayas.app/@adrinsanhueza): Financial Analyst, Ottimate
- [Diego Cayupil](https://himalayas.app/@diegocayupil): Mid Level Data Analyst, Walmart Chile
