Leo Hartmann

Data Analytics Intern

Chicago, IL, United States

Professional Summary

Analytical and curious Data Analytics Intern with hands-on experience turning retail and fintech data into clear recommendations. Skilled in SQL, Python, Excel, and Tableau, with a strong foundation in statistics and data storytelling. Built dashboards that improved weekly reporting and collaborated with cross-functional teams to identify customer and revenue trends. Known for careful validation, crisp communication, and a practical, learning-first mindset.

Employment History

Data Analytics Intern

Lakeshore Ledger Analytics · Chicago, IL

Jun, 2025 · Aug, 2025

• Queried 180K+ transaction records with SQL to identify repeat-purchase patterns and customer segments. • Built a Tableau dashboard that reduced weekly reporting time by 35% and gave account teams a shared view of retention. • Validated campaign and revenue data in Python/pandas, documenting edge cases and improving confidence in monthly metrics.

Business Intelligence Co-op

North Loop Retail Lab · Chicago, IL

Jan, 2024 · May, 2025

• Cleaned and joined store, loyalty, and inventory datasets in Excel and SQL to support quarterly assortment reviews. • Partnered with merchandising to investigate a 9% category variance, tracing the issue to a late data feed and improving reconciliation checks. • Presented concise findings to six stakeholders and maintained a reusable KPI dictionary for analysts and interns.

Research Assistant, Student Insights

Chicago Urban Data Collaborative · Evanston, IL

Sep, 2023 · Dec, 2023

• Analyzed survey responses from 600+ students using R and descriptive statistics to support a campus mobility study. • Designed clear charts and one-page briefs that helped faculty researchers communicate findings to community partners. • Reconciled data dictionaries and logged methodology decisions, strengthening reproducibility for the next research cycle.

Education

B.S. in Statistics & Computer Science

Northwestern University · Evanston, IL

Sep, 2021 · Jun, 2025

GPA: 3.7/4.0 • Dean’s List (2022–2025) • Coursework: Probability & Statistics, Database Systems, Machine Learning, Data Visualization • Capstone: Forecasting neighborhood retail demand with Python and time-series models

Skills

SQL

Python

Tableau

Excel

Courses

Applied Data Analytics with Python

DataCamp Professional Learning · Online

Jan, 2025 · Mar, 2025

Completed a project-based curriculum covering pandas, exploratory analysis, regression, data cleaning, and communicating insights with visual narratives.