About me

Juan Parrado

BI Dev & Data Analyst

I am a data professional with nearly 5 years of experience bridging the gap between complex finance operations and modern analytics pipelines. My expertise spans constructing automated ETL pipelines in Python, optimizing cloud data warehouses like Snowflake, and building strategic dashboards used directly by executive boards.

By combining structural engineering with generative AI integration, I transform unstructured communication and raw data pools into scalable, business-driven tools.

Experience

Lean Solutions Group

Data Analyst

Translated productivity and profitability data into dashboards that improved workload planning, staffing decisions, and account performance.

Lean Solutions Group

Data Analyst

  • Created a workload tool that supported the hiring of three new employees and the promotion of a team member.
  • Managed the data and performance measurement system for a major client account with more than 200 employees.
  • Achieved over 93% in internal audits and exceeded the highest-value performance target by reaching 114%.
+
Feb 2022 – Dec 2022

Finanzauto

BI Developer

Developed SQL databases and near real-time dashboards that supported collections, finance, and board-level decision-making.

Finanzauto

BI Developer

  • Built the database and dashboard used by the board of directors during monthly financial closings.
  • Created a collections dashboard refreshed every 5 minutes to track payments, targets, and portfolio performance.
  • Completed more than 300 assigned deliverables with an average compliance rate of 96%.
+
Dec 2022 – Oct 2024

Globant

BI Analyst

Created BI dashboards, automated data workflows, and an AI support agent that reduced manual work and improved response efficiency.

Globant

BI Analyst

  • Created a year-end performance report used for external requests and manager bonus calculations.
  • Built an AI assistant that reduced questions needing human support by nearly 50%.
  • Improved automated reporting and database processes, including cutting a key query’s runtime by 4 minutes.
+
Oct 2024 – Dec 2025

Importa Group

Senior BI Analyst

Building scalable Snowflake models, automated pipelines, and trusted analytics for finance, commercial, and operations teams.

Importa Group

Senior BI Analyst

  • Cut dashboard refresh time from about 9 minutes to under 2 minutes, while reducing Snowflake costs by approximately 18%.
  • Built the complete reporting and database system for the company’s transportation insurance portfolio.
  • Integrated around 25% of the company’s data sources into one reliable platform used by finance, sales, and operations.
+
Dec 2025 – Present

Ed & Skills

Education & Certifications

Professional in Finance and International Trade

Universidad de La Salle

2015 – 2020

Diploma in Artificial Intelligence Applied to Business

Universidad de La Sabana

2023

Diploma in Programming with Python

Universidad Tecnológica de Pereira

2022

Skills

Technical Stack

SQL Server Snowflake MySQL & PostgreSQL Python (Intermediate) Power BI (DAX) Tableau Advanced Excel ETL Pipelines Enterprise AI Agents Git & GitHub

Professional Competencies

Stakeholder Management Cross-Functional Leadership Predictive Modeling Data Science Frameworks Metric Auditing Performance Strategy