Open to BI roles and freelance projects

Dashboards a team keeps coming back to.

Mostly Power BI and SQL. The real work is deciding what a retail or e-commerce team needs to see, and removing the rest.

Portrait of Juan Pérez
Now
Data Analyst, Publicis Groupe
Based
Cali, Colombia
Languages
Spanish, English

At a glance

+25%reporting adoption after KPI and usability changesGlobant, 2024 to 2026
7client brands across retail, beverages, airline, electronics and consumer goods
4+ yrsbuilding BI and reporting, since August 2022

01About

I have spent most of my career on digital marketing and e-commerce data. I pull ad and site data into one view that a marketing lead can open on a Monday and read without me.

What I like most is turning a messy spreadsheet into a model other people can query. Before building anything I ask which decision the report is for, and I keep asking until someone can say. Dashboards that nobody opens twice usually skipped that step. Every number gets checked against a second source, and anything I had to assume goes into the report in plain words.

Outside of work, I care about products and roles that get people in Latin America moving more and sitting less.

02Experience

Data Analyst, Publicis GroupeCurrent

May 2026 to present

Remote. Client industry: consumer electronics

  • Digital performance and SEO dashboards for campaign and executive reporting.
  • Turns stakeholder requirements into reports people use.
  • Adobe Analytics
  • SEMrush
  • Looker Studio
  • Excel

Data Analytics and Martech Analyst 2, Globant

Sep 2024 to May 2026

Remote. Airline, retail, spirits, hygiene and consumer goods clients

  • Power BI models that merge several sources into shared semantic layers.
  • Reporting adoption up 25%, tracked through the BigQuery billing export where available and Looker Studio usage by dashboard ID.
  • Automated the weekly executive report.
  • Power BI
  • Looker Studio
  • GA4
  • BigQuery
  • Google Sheets
  • Apps Script
Earlier roles and education

Business Intelligence Analyst, Procesalab

Feb 2023 to Sep 2024

Hygiene and consumer goods, direct sales and retail clients

  • Power BI KPI dashboards and optimized SQL for reporting datasets.
  • Power BI
  • DAX
  • Power Query
  • SQL

Data operation

Aug 2022 to Jan 2023
  • Reusable dashboard prototypes in Looker Studio, presented to stakeholders.
  • Looker Studio
  • Miro

Industrial Engineering, Universidad Libre

2014 to 2019

Cali, Colombia

03Projects

Airline client

Multi-platform paid media dashboard

Brought several paid media platforms into one performance dashboard. Dataslayer extracted the data from each platform, and Google Sheets ran the extra calculations.

  • Dataslayer
  • Google Sheets
Beverage industry client

SAP to Databricks migration

Audited a Power BI report that read SAP directly over ODBC. Rebuilt and validated the KPI logic in Databricks and moved the report onto curated star schema views.

  • Power BI
  • Databricks
  • SQL
In testing

Dashboard specification agents

Two Copilot Studio agents. One turns a vague request into a dashboard spec, the other drafts the wireframe. Built for Teams.

  • Copilot Studio
  • Teams
  • SharePoint

04Services

Reports

Automated reporting with KPI logic written down, so every number can be traced.

Dashboards

Power BI and Looker Studio on a clean data model, designed around what the reader asks.

Audits

Review of existing BI solutions and analytics tracking, checked against a second source.

05Contact

Let's talk.

Open to roles and freelance projects. Email is the fastest way.