Open to new opportunities

Hi, I'm Andrés
Restrepo

BI & Data Analyst with 4+ years turning data into decisions across LATAM e-commerce and digital marketing.

SQL BigQuery Power BI Python FastAPI Docker GCP

About

Background & focus areas

I work at the intersection of data engineering, analytics, and business strategy. Over the past four years I've built reporting pipelines in BigQuery, executive dashboards in Power BI, and data quality frameworks for e-commerce operations spanning multiple countries across Latin America.

Before that I spent nearly three years in digital marketing analytics at IPG Mediabrands, where I learned to translate campaign data into investment decisions and to make stakeholders care about the numbers.

I hold a degree in Business Administration from Universidad Nacional de Colombia and I'm currently finishing a Master's in Applied Analytics at Universidad de la Sabana, where my thesis project is a full-stack ML platform for athlete coaching.

Focus areas
  • Advanced SQL on BigQuery at scale
  • Power BI dashboards & KPI consistency
  • Data quality & cross-source reconciliation
  • Business requirements to analytical solutions
  • Python for modeling & automation
4+
Years in analytics
C1
English level

Experience

Where I've worked

May 2024 — Present
Current
Business Intelligence Analyst
InfraCommerce · Bogotá
  • Optimize SQL queries in BigQuery for LATAM regional e-commerce reporting, supporting commercial decisions across multiple clients and markets
  • Build and maintain Power BI dashboards focused on KPI consistency, metric integrity, and report performance for internal and external stakeholders
  • Integrate data from external APIs and heterogeneous sources, standardizing datasets for reliable cross-market analysis
  • Validate and reconcile data between operational sources and the Data Warehouse, resolving discrepancies that affect reporting trust
  • Manage analytical requirements in Jira with agile methodology, coordinating deliverables across teams and clients
BigQuerySQL Power BIAPIs Data QualityJira
Jun 2021 — Mar 2024
BI Analyst / Digital Analyst
IPG Mediabrands Initiative · Bogotá
  • Designed performance dashboards for digital campaigns, enabling real-time KPI tracking for account teams and clients
  • Gathered stakeholder requirements and translated business needs into metrics, reports, and actionable visualizations
  • Extracted, integrated, and cleansed data from multiple digital platforms, reducing preparation time through partial automation
  • Built relational data models and SQL queries to consolidate sources and ensure indicator consistency across campaigns
  • Prepared executive reporting to support digital media investment decisions
DashboardsDigital Marketing SQLKPIs Reporting

Projects

Selected work

Master's Thesis
Running Coaching Analytics Platform

End-to-end ML platform for competitive runners. Ingests real training data from Strava, engineers load metrics, predicts race times across distances, and serves everything through a REST API with an interactive coaching dashboard.

103K+
Boston Marathon records for calibration
18+
REST API endpoints
61
Automated tests
4,800+
Lines of Python
4-Layer Prediction System
Calibrated Riegel + demographic correction via Ridge regression on 429K+ global results
Training Load Analytics
CTL, ATL, ACWR feature engineering with EWMA methodology and risk zone classification
Interactive Dashboard
Load semaphore, KPI grid, trend charts, and personalized weekly training plan
Strava + CI/CD
OAuth sync, GitHub Actions weekly automation, Docker containerized on Railway
PythonFastAPIDuckDBPandas Alpine.jsTailwindChart.jsDocker RailwayGitHub ActionsSupabaseStrava API
E-Commerce BI Framework

Regional reporting architecture for LATAM e-commerce. BigQuery pipelines, Power BI dashboards, and a KPI consistency framework serving multiple clients.

BigQueryPower BI SQLData Quality
Digital Campaign Analytics

Cross-platform performance dashboards for digital marketing. Automated data extraction, KPI tracking, and executive reporting for media investment decisions.

DashboardsKPIs SQLAutomation

Skills & Tools

What I work with

Data & Analysis
  • SQL · BigQuery · PostgreSQL
  • MySQL · DuckDB
  • Applied Statistics
  • KPI Design · Data Quality
Visualization
  • Power BI · DAX · Power Query
  • Looker Studio
  • Chart.js
  • Executive Reporting
Programming
  • Python · Pandas
  • FastAPI · REST APIs
  • ETL Pipelines
Cloud & Infra
  • Google Cloud · BigQuery
  • Supabase · Railway
  • Docker
ML & Analytics
  • Predictive Modeling
  • Feature Engineering
  • Regression · Time Series
  • EDA
DevOps & Process
  • Git · GitHub Actions · CI/CD
  • Jira · Agile
  • Documentation

Education

Academic background

2024 — Present
M.Sc. in Applied Analytics In progress
Universidad de la Sabana · Chía, Colombia
Thesis: Running Coaching Analytics Platform — predictive modeling, API development, and deployment.
2021
Business Intelligence Diploma
Universidad Nacional de Colombia · Bogotá
2015 — 2020
B.A. in Business Administration
Universidad Nacional de Colombia · Bogotá
Let's work
together.
Bogotá, Colombia
Available for BI, Data Analytics,
and Applied Analytics roles.