I am a data professional and recent UC Irvine graduate (B.S. Applied and Computational Mathematics, Data Science specialization) passionate about building robust, end-to-end data pipelines and uncovering actionable business insights.
I am currently relocating to the Northwest Arkansas area and actively seeking roles as a Data Analyst, BI Analyst, or Junior Data Engineer.
- Howard Tucker Award in Mathematics (UC Irvine)
- Cum Laude & Dean's Honor List (Cumulative GPA: 3.92)
- Datathon Winner: Best Visualization
- Languages: Python, SQL, R, C++, Java
- Data Warehousing & DBs: Snowflake, Google BigQuery, PostgreSQL
- BI & Visualization: Tableau, PowerBI
- DevOps & Infrastructure: Docker, Linux, Git, Tailscale, Syncthing
Engineered an automated Python ETL pipeline designed to handle large-scale time-series data. Sourced and structured over 9 million rows of data from the FRED and Open-Meteo APIs, developing automated data cleaning and deduplication workflows to route high-reliability datasets into PostgreSQL, Snowflake, and BigQuery.
Developed automated reporting models and a Tableau dashboard tracking 9+ core business KPIs using Python and SQL. Uncovered a 69% holiday sales lift and analyzed store-level demand volatility to recommend optimized inventory and supply chain strategies.
Built and currently manage a personal server environment utilizing a Raspberry Pi 5. The architecture features NVMe storage, containerized application deployment via Docker, and secure remote networking utilizing Tailscale and AdGuard Home.
Before diving full-time into data, I spent time studying quantitative finance and trading (Jane Street Summer Program) and worked for years as a Rock Wall Supervisor and Belayer. When I'm not writing SQL or tinkering with my Docker containers, you can usually find me researching personal finance optimization or at the local climbing gym.
- LinkedIn: linkedin.com/in/aaronvillegas1
- Email: akvilleg@uci.edu
