Data Analytics Intern - KPI & Dashboard Specialist

LOGAN MCDOUGAL

Salt Lake City, UT 208-***-**** ***********@*****.*** www.linkedin.com/in/loganmcdougal555 SUMMARY

Data analyst with multiple internship experiences to support daily reporting, data visualization, and cross-functional projects. Strong background in SQL, Tableau, Power BI, and Excel, along with good communication skills and problem- solving ability.

SKILLS

Tools: SQL, Python, Tableau, Excel, Power BI, Tableau Prep, AWS, Salesforce, Maximo, RStudio Business and Operations: KPI development, dashboard reporting, process improvement, project coordination, cross- functional collaboration

Strengths: Problem Solving, Stakeholder Communication, Organization skills, Project Management, Data Visualization, Leadership

EXPERIENCE

Salt Lake City International Airport — Salt Lake City, UT January 2026 – Present Airport Operations Analyst Intern

- Met with airport division leaders to define top priorities, create practical KPIs, and build a reporting system that improves visibility into projects, progress, and budgeting needs.

- Turned broad strategic goals into Excel and Power BI tools managers can update daily, weekly, and monthly, giving leadership a clearer view of work happening across the airport.

- Used Maximo work order data and division input to build more measurable KPIs and improve how operational results are tracked and communicated.

Blue Cross of Idaho — Boise, ID May 2025 – August 2025 Healthcare Operations Quality Specialist Intern

- Used SQL Servers and Tableau to build monthly reporting that identified gaps in care across Idaho and supported quality improvement work.

- Prepared reporting outputs the Quality team used during audit season and in performance discussions with clinics across the state.

- Cleaned and validated data to improve consistency and strengthen confidence for the team when reporting. EDUCATION

Utah State University, Huntsman School of Business Fall 2022 – Spring 2026 B.S. in Data Analytics Cumulative GPA: 3.60

- Relevant Coursework: Data Wrangling and SQL, Data Visualization with Tableau, Statistical Modeling, Machine Learning and Model Building, Business Communication

- Tableau Certified

LEADERSHIP

Pi Kappa Alpha Fraternity, Utah State University

Treasurer; Philanthropy Chair

- Helped redesign the chapter dues process to improve funding and create a more reliable system for collecting payments.

- Led planning and execution for philanthropy weeks and events

Contact this candidate