Open to work · San José, Costa Rica

Emanuel
Vaglio

Data analyst building skills in PowerBI, SQL, Excel and Python. I approach data the same way I approach complex problems: find the pattern, understand the why, then act on it.

0+
Portfolio Projects
0mo
Self-directed learning
0+
Tools & languages
0
Languages (ES/EN)
Skill Overview
78%
avg skill
📊
Excel
85%
🗄️
SQL
88%
🐍
Python
65%
📈
Power BI
72%
Experience

Work History

01
Freelance Data Analyst
2025 – Present

Focused on data analysis and reporting using SQL, Excel, and Power BI. Work includes building queries, cleaning datasets, creating dashboards, and delivering insights from raw data.

PowerBI SQL Excel Python
02
Chess Coach
2020 – Present

Coached students of all levels individually and in group settings. Coordinated with MM Chess Academy in Chicago. FIDE-rated player with structured curriculum design experience.

Curriculum Design 1-on-1 Coaching Remote
About

Freelance Data Analyst focused on building real skills

I've also built technical projects beyond pure analytics — including Simployee, an AI-powered job simulation platform (FastAPI, Supabase, Claude API) — giving me context to collaborate with developers and understand data in the full product stack.

My background in competitive chess and coaching gave me a structured way of thinking — holding multiple variables, finding patterns, and communicating complex ideas clearly. These skills transfer directly to data work.

Based in Costa Rica, bilingual in Spanish and English, open to remote roles.

profile.py
# Emanuel Vaglio — Data Analyst
 
name = "Emanuel Vaglio"
role = "Data Analyst"
location = "San José, CR"
 
stack = [
  "SQL", "Excel",
  "Power BI", "Python"
]
 
languages = [
  "Spanish", "English"
]
 
open_to_work = True
Skills

Technical Toolkit

Tools I've used in real projects — not just listed on a course syllabus.

🐍
Python
pandas
NumPy
Matplotlib
Jupyter Notebooks
🗄️
Databases & SQL
SQLite
PostgreSQL
DuckDB
Supabase
📊
Reporting & BI
Excel (advanced)
Pivot Tables
Power BI
Data visualization
⚙️
Dev & Tools
FastAPI
REST APIs
Git & GitHub
VS Code
Projects

Selected Work

Built to demonstrate real analytical thinking — from raw data to business insight.

01
Obesity & Dietary Habits Analysis — Latin American Population
Complete

Analyzed a dataset of 2,111 records from Mexico, Peru, and Colombia to explore the relationship between dietary habits, physical activity, age, and obesity levels. Full analyst workflow: data cleaning in Excel, pivot table analysis, interactive Power BI dashboard with cross-filtering slicers, and a structured findings report.

Excel Power BI Data Cleaning EDA UCI Dataset
02
Credit Risk Analysis — Loan Default Prediction
Complete

Analyzed 32,581 real-world loan records to identify key default risk factors. Full analyst workflow: data cleaning and validation in Excel, 7 SQL queries for risk segmentation and borrower profiling, and an interactive Power BI dashboard with DAX measures, slicers, and a traffic-light color scheme. Key finding: Grade G loans default at 98.44%; renters default 4x more than homeowners.

SQL Excel Power BI DAX SQLite
03
Chess Performance ETL Analyzer
Complete

Pulls game data from the Lichess API, transforms it using Python and pandas, and loads it into SQLite for performance analysis. A full ETL pipeline from scratch — demonstrates API consumption, data wrangling, and relational storage.

Python pandas SQLite REST API ETL
04
Simployee — AI Job Simulation Platform
Full-Stack

Web app where candidates practice real work tasks at a fictional company, evaluated by an AI manager. Built with FastAPI, Supabase, DuckDB, JWT auth, and the Anthropic Claude API. Deployed on Railway and GitHub Pages.

FastAPI PostgreSQL DuckDB Claude API Railway
05
NovaRetail Q1 2024 — Sales & Inventory Analysis
In Progress

End-to-end analysis of a fictional retail company's Q1 performance. Covers data cleaning, SQL aggregations, Python/pandas exploration, and a Power BI dashboard. Designed to showcase a complete analyst workflow from raw data to business recommendation.

SQL Python pandas Excel Power BI SQLite
Certifications

Completed Courses

Verified credentials from Microsoft and IBM. · 4 certifications

Harnessing the Power of Data with Power BI
✓ Completed
Microsoft · DAX measures, interactive dashboards, slicers, KPI cards
Python Programming Fundamentals
✓ Completed
Microsoft · Variables, functions, control flow, OOP basics
Databases and SQL for Data Science
✓ Completed
IBM · SELECT, JOINs, GROUP BY, subqueries, SQLite
Excel Basics for Data Analysis
✓ Completed
IBM · Pivot tables, VLOOKUP, SUMIF, COUNTIFS, IF logic
Contact

Let's Talk

Looking for data analyst roles or junior developer positions. Open to remote work. Bilingual — comfortable in English or Spanish.