Jordan Mercer

Business Analytics Student | Data Visualization | Aspiring Product Manager

I turn messy data into decisions that actually get made.

See My Work

About

I am a senior at the University of Iowa, Tippie College of Business, pursuing a B.B.A. in Business Analytics with a concentration in Data Visualization. I expect to graduate in May 2026 and am actively seeking entry-level roles in product management and business intelligence within healthcare technology and financial services.

Most recently, I interned at MedTrack Solutions, where I built Tableau dashboards used daily by the client success team and presented a data quality audit directly to the VP of Engineering. Outside the classroom, I volunteer as a Data Coach with the Iowa Food Bank Network, using data to help optimize food distribution across 14 Iowa counties.

Skills

Technical

Python (pandas, matplotlib) SQL Tableau Power BI Excel (advanced) R (basic)

Professional

Agile methodology User story writing Stakeholder communication Data storytelling Requirements documentation

Tools

GitHub VS Code Jupyter Notebook Microsoft Office Suite Google Workspace

Experience

Data Analytics Intern

MedTrack Solutions · June–August 2025

Built and maintained Tableau dashboards used daily by a 6-person client success team to monitor product adoption across 40+ rural clinic accounts.
Wrote SQL queries to extract and clean usage data from a PostgreSQL database, reducing manual reporting time by approximately 3 hours per week.
Presented a data quality audit to the VP of Engineering identifying duplicate patient records affecting 12% of active accounts.

Tools: Tableau, SQL (PostgreSQL)

Data Coach (Volunteer)

Iowa Food Bank Network · January 2025–Present

Built a Tableau dashboard to visualize weekly food distribution across 14 Iowa counties, identifying three underserved zip codes and prompting reallocation of two delivery routes.
Trained two nonprofit staff members on basic Tableau navigation and filter usage.

Tools: Tableau, Excel

Projects

Tippie Enrollment Trend Analysis

Led a team of three in analyzing five years of enrollment data for a semester-long analytics project. Wrote all SQL queries and built visualizations in Python; presented findings to a faculty panel as a mock business intelligence briefing.

Received highest mark in a class of 28 students.

Tools: Python (pandas), SQL, PowerPoint

This Landing Page

Designed and built a personal landing page to present professional experience and project work to recruiters. Developed with an AI-assisted workflow in Replit and deployed to Azure Static Web Apps via GitHub.

A single, polished destination for hiring managers to explore my work.

Tools: HTML, CSS, GitHub, Azure

Education

University of Iowa, Tippie College of Business

B.B.A. in Business Analytics, Data Visualization Concentration

Expected Graduation: May 2026 · GPA: 3.7

Dean's List: Fall 2024, Spring 2025

Get in Touch

I am actively recruiting for entry-level business analyst and associate product manager roles. I would love to hear from you.

Email Jordan Connect on LinkedIn View on GitHub