Andrés F.

Business Intelligence Developer

Andrés is a Business Intelligence Developer with over seven years of commercial experience, specializing in SQL, Tableau, Looker, and advanced data modeling. His strong technical foundation in Airflow, GCP, and Python makes him a valuable contributor to complex BI initiatives.

He designs and delivers impactful analytics solutions for the e-commerce industry, building data marts, designing dashboards, and transforming data into actionable insights that empower cross-functional decision-making.

Among his key achievements, Andrés develops a robust DataMart that reduces inventory accounting closing time from five days to one, refactors discount processes in Airflow to reduce load size by 24x, and optimizes data storage, achieving significant cost savings.

Main expertise

  • Tableau
    Tableau 6 years
  • Looker
    Looker 4 years
  • BigQuery
    BigQuery 4 years

Other skills

  • Apache Airflow
    Apache Airflow 2 years
  • Python
    Python 2 years
Andres

Andrés F.

Colombia

Get started

Selected experience

Employment

  • Data Engineer

    Valtech - 7 months

    • Developed and documented BigQuery queries for a U.S. luxury retailer, creating partitioned tables and automated batch jobs; also built and optimized data pipelines powering a Vertex-based website, enabling secure data sharing with partner fashion brands.

    • Scaled a high-value behavior Power BI dashboard for a global automotive manufacturer from a single market to 26 countries by developing Databricks tables, standardizing country-specific logic across heterogeneous sources, and delivering a unified, reliable dataset for consistent reporting.

    • Improved data architecture and quality by redesigning the model into a Power BI-optimized star schema, leading a comprehensive data flow documentation effort (39 tables, 16 views), and implementing a Python reconciliation function that recovered 14% of misclassified or excluded records.

    Technologies:

    • Technologies:
    • Databricks Databricks
    • Microsoft Power BI Microsoft Power BI
    • Data Engineering
    • BigQuery BigQuery
    • Jira Jira

  • Senior Data Analytics Consultant

    Valtech - 5 months

    Technologies:

    • Technologies:
    • Databricks Databricks
    • Jira Jira
    • Data Analytics
    • Tableau Tableau

  • Business Intelligence Developer

    PedidosYa - 2 years

    • Designed, developed, and maintained a DataMart supporting requests from multiple stakeholders across 14 Latin American countries.
    • Built and managed Airflow DAGs and modeled Looker Explores, unifying KPIs across teams for consistent analytics.
    • Created a robust DataMart that reduced inventory accounting closing time from five days to one, resolved critical issues in a global reconciliation tool for LATAM markets, and refactored the discount process in Airflow, reducing load size by 24x and achieving significant storage savings.

    Technologies:

    • Technologies:
    • Python Python
    • SQL SQL
    • Google Cloud Google Cloud
    • BigQuery BigQuery
    • Jira Jira
    • Git Git
    • VSCode VSCode
    • Apache Airflow Apache Airflow
    • Data Analytics
    • Data Modeling
    • Tableau Tableau
    • YAML YAML
    • Looker Looker

  • Senior CX Data Analyst

    PedidosYa - 2 years 3 months

    • Developed and implemented global surveys using Qualtrics and managed NPS campaigns in Braze for both new and existing customers.
    • Collaborated with Partner and Rider Experience teams to improve NPS performance across the ecosystem and built Tableau dashboards for detailed monitoring and analysis by segment.
    • Uncovered a global user experience trend that explained NPS fluctuations and established NPS targets for Managing Directors across multiple countries.
    • Identified key NPS improvement levers through logistic regression analysis, enabling targeted actions to enhance customer and partner satisfaction.

    Technologies:

    • Technologies:
    • SQL SQL
    • BigQuery BigQuery
    • Jira Jira
    • Data Analytics
    • Tableau Tableau
    • Redshift Redshift
    • Looker Looker

  • Business Intelligence Operations & Logistics Leader

    PedidosYa - 8 months

    • Supported operations and logistics teams by creating Tableau reports and deriving actionable insights to address key business challenges.
    • Developed a Unit Economics report that calculated EBITDA per order for logistics operations, enabling targeted cost optimizations and driving progress toward profitability.

    Technologies:

    • Technologies:
    • AWS AWS
    • SQL SQL
    • Data Analytics
    • Team Leading
    • Tableau Tableau
    • Redshift Redshift
    • Trello Trello

  • Business Intelligence Cross Analyst

    PedidosYa - 3 months

    • Analyzed data from various departments, extracting insights from Amazon Redshift and generating Tableau reports to support company-wide decision-making.
    • Created the Fail Rate Monitor, which became the most viewed Tableau report in the company, with over 2,000 employees accessing it regularly.
    • Analyzed over 50 rejection reasons, contributing to a reduction in partner Fail Rate from 13% to 4% regionally.

    Technologies:

    • Technologies:
    • SQL SQL
    • Data Analytics
    • Tableau Tableau
    • Redshift Redshift
    • Trello Trello
    • Looker Looker

  • Business Intelligence Analyst

    Domicilios.com - 2 years 1 month

    • Extracted data using MySQL to generate Tableau reports with insightful visualizations for the marketing, sales, and finance teams.
    • Served as the primary point of contact for global teams visiting the country, providing support through English fluency and a strong understanding of cross-company operations.
    • Prepared the CEO’s monthly presentation for the global CIO, featuring key insights for semiannual visits, and acted as a liaison for the Customer Experience team in Germany to implement NPS surveys.
    • Analyzed and reduced company expenses by 2% through a cost-cutting initiative led by the CEO and reviewed by the CTO.
    • Georeferenced all orders and sessions globally using PostgreSQL, enabling the Sales team to develop targeted lead strategies.
    • Created SQL queries to categorize alcoholic and non-alcoholic beverages, delivering sales insights that strengthened partnerships with Dislicores, Coca-Cola, and Pernod Ricard.

    Technologies:

    • Technologies:
    • MySQL MySQL
    • PostgreSQL PostgreSQL
    • SQL SQL
    • Data Analytics
    • Tableau Tableau
    • Asana Asana

Education

  • BSc.Industrial Engineering

    Universidad de los Andes · 2011 - 2016

Find your next developer within days, not months

In a short 25-minute call, we would like to:

  • Understand your development needs
  • Explain our process to match you with qualified, vetted developers from our network
  • You are presented the right candidates 2 days in average after we talk

Not sure where to start? Let’s have a chat

First developer starts within days. No aggressive sales pitch.