Lex Ortega

Data Analytics Intern

Chicago, IL, United States

Professional Summary

Analytics intern with hands-on experience using SQL, Python, and Tableau to turn operational and research data into clear decisions. Statistics and Data Science coursework supports practical work in experimentation, regression, and data quality. Brings internship experience, campus research, and part-time operations data work, with a track record of automating reporting and communicating insights to stakeholders.

Employment History

Data Analytics Intern

Midwest Retail Collective · Chicago, IL

Jun, 2025 · Present

Built weekly KPI dashboards in Tableau for e-commerce conversion and fulfillment SLAs. Wrote SQL for cohort retention and cart-abandon analyses used by merchandising. Automated a Python ETL script that cut manual reporting by approximately 6 hours per week.

Research Assistant (Data)

University of Illinois Chicago · Chicago, IL

Jan, 2024 · May, 2025

Cleaned survey datasets (n≈2,400) and ran regression models in R/Python for a faculty paper. Produced charts and methods notes for a conference poster on urban mobility access.

Operations Associate (part-time)

Lakeview Market Co-op · Chicago, IL

Sep, 2023 · Dec, 2024

Tracked inventory shrinkage and vendor fill rates in Sheets; flagged weekly outliers. Supported POS export reconciliation for month-end close.

Education

B.S. Statistics & Data Science

University of Illinois Chicago · Chicago, IL

2022 · May, 2026

Expected May 2026. GPA: 3.7. Coursework: Statistics, Regression Analysis, Data Management, Experimental Design, and Data Visualization.

Skills

SQL

Python

Tableau

Excel

A/B

Data storytelling