Andres Mejia

Andres Mejia

About

Detail

Data Analyst
Honduras

Contact Andres regarding: 
work
Full-time jobs
Starting at USD15/hour
id_card
Internships
Starting at USD1k/month

Timeline


work
Job
school
Education
folder
Project

Résumé


Jobs verified_user 0% verified
  • C
    Data Engineer — Participant
    CDF Energy AI Hackathon
    Apr 2026
    CDF Energy Intelligence System — Python • FastAPI • SQLite • OLS Forecasting • Built a full-stack energy analytics platform in 5 days — Python pipeline ingesting 15,000+ structured monthly records from the EIA v2 REST API into a query-optimized SQLite database, with an OLS forecasting engine computing 36-month rolling projections and 95% confidence bands. • Developed 6 dynamically recalculated business KPIs — projected production, YoY growth, decline rate, revenue potential, volatility score, and relative performance index — exposed via FastAPI endpoints consumed by a Next.js frontend deployed to production on Vercel and Render.
  • Community Dreams Foundation
    Data Analyst
    Community Dreams Foundation
    Jan 2026 - Current (7 months)
    Labor Market Analytics Pipeline — Python • SQL Server • REST API • Power BI • Designed and built a production Python ETL pipeline ingesting structured and semi-structured JSON data from the Adzuna REST API across 5 technology categories — handling authentication, pagination, response parsing, field-level deduplication, and scheduled bulk loading into MS SQL Server. • Developed and maintained a star schema data warehouse with foreign key constraints, optimized indexes, and normalized dimension tables — writing complex SQL including CTEs, window functions, stored procedures, and MERGE statements for reliable upsert logic. • Implemented data validation and quality enforcement at each pipeline stage — routing invalid records to error tables wit
Education verified_user 0% verified
  • O
    MSc in Business Intelligence & Analytics
    OBS Business School — Universidad de Barcelona
    Jan 2024 - Current (2 years 7 months)
    Double Degree • Focus: BI strategy, data architecture, advanced analytics, reporting systems
  • S
    BSc in Business Economics
    Solvay Business School — Vrije Universiteit Brussel (VUB)
    Sep 2020 - Sep 2024 (4 years 1 month)
    Specialization: Business and Information Technology
Projects (professional or personal) verified_user 0% verified
  • Personal Project
    Market Intelligence Platform
    Personal Project
    Jan 2026
    • Built an end-to-end financial data pipeline ingesting structured and semi-structured data from Yahoo Finance and FRED REST APIs through a full medallion architecture (Bronze → Silver → Gold) — Python ingestion scripts handling authentication, pagination, and error handling with daily orchestration via Apache Airflow DAGs on Docker. • Implemented dbt transformation models for the Gold layer producing analysis-ready financial metrics with full lineage documentation, schema tests, and source freshness checks — applying software engineering discipline to SQL transformation code. • Deployed a public Streamlit dashboard with interactive KPIs and macroeconomic overlays — fully self-contained and reproducible from a single docker-compose file.
  • Personal Project
    Retail BI Analytics Project
    Personal Project
    Jan 2026
    • Designed and populated a SQL Server star schema optimized for multidimensional analytical queries — developed DAX measures for Net Sales, Profit Margin, Return Rate, Average Order Value, and YTD analysis. • Generated a realistic synthetic dataset in Python using pandas — simulating customers, products, orders, and returns with realistic distributions and referential integrity to validate the full ETL-to-dashboard pipeline.
  • Personal Project
    GameMax — Video Game Deal Tracker
    Personal Project
    Jan 2026
    • Built a data aggregation pipeline ingesting semi-structured JSON responses from CheapShark, ITAD, and Steam APIs into Supabase/PostgreSQL — Python ingestion with SDK version pinning, structured error handling, and deduplication logic. • Designed dbt Gold layer transformation models and a Streamlit card-grid UI — demonstrating end-to-end ownership across ingestion, transformation, and serving layers.