Logan Spencer
Data analyst turning warehouse and reporting data into decisions leadership can act on. Built the Tableau dashboards and dbt models behind Pennant's executive reporting, then caught and corrected an attribution error that had understated one team's volume sixfold. Backed by SQL, statistical modeling, and backend systems experience. MISM student at BYU Marriott.
Education
Master of Information Systems Management, Brigham Young University, Marriott School of Business
Expected Dec 2027
B.S. Information Systems, Brigham Young University, Marriott School of Business
Minor: Healthcare Leadership
GPA 3.77 · BYU Academic Scholarship
Experience
Data Engineering & Analytics Intern
Jun to Aug 2026
Pennant Services
Provo, UT
- Built three production dbt models on Snowflake transforming 11M+ support events into reporting tables covering 1.19M tickets across 93 teams serving home health, hospice, and senior living affiliates.
- Shipped four Tableau dashboards giving operations leaders team, staff, and ticket-level visibility, validating every metric against both Snowflake and the source system.
- Rebuilt team-attribution logic to capture sub-day handoffs the prior model missed, correcting the routing team's volume from 76K to 518K tickets handled.
- Presented the revised model and metric definitions to department leadership, securing new attribution standards.
Data Analyst (Backend Systems)
May 2025 to May 2026
BYU Housing Department
Provo, UT
- Analyzed backend enrollment data for 10,000+ students, optimizing Oracle SQL queries to maintain 99% uptime.
- Resolved 20+ production database and API issues using SQL and ASP.NET logs.
Machine Learning Researcher
Sep 2025 to Present
BYU Marriott School of Business
Provo, UT
- Built a dataset of 2,000+ mobile app privacy policies in Python and Pandas for ed-tech privacy research.
- Developed regression models to quantify privacy risk across applications.
Accounting Analyst
Oct 2024 to Aug 2025
BYU Continuing Education
Provo, UT
- Automated multi-million-dollar financial reporting workflows in Python and SQL for executive stakeholders.
- Produced and reconciled 15+ monthly Workday reports; transformed data via SQL and Power Query.
Co-Owner
Apr 2024 to Apr 2025
Perfection Reflection Window Washing
Provo, UT
Technical Skills
Data & Analytics: Advanced SQL, Snowflake, PostgreSQL, Oracle, Tableau, Power BI, RStudio, Statistical Modeling, Machine Learning
Data Engineering: dbt, ETL/ELT Modeling, Fivetran, Data Validation, Data Cleaning, Star Schema Design
Programming: Python (Pandas), SQL, R, JavaScript, C#, .NET
Cloud & Tooling: AWS (EC2, RDS, S3), Git/GitHub, Claude Code
Methodologies: Agile / Scrum, Stakeholder Reporting, Metric Definition
Projects
- Ed-Tech Privacy Research, BYU Marriott School:
Built a dataset of 2,000+ mobile app privacy policies in Python with regression models quantifying risk; findings informed Utah HB55 (2026), covered by KSL.
2025 to 2026
- News Aggregator:
ML pipeline classifying articles from multiple news APIs by topic and sentiment with Hugging Face models.
2025
- Turtle Shelter Dashboard, Nonprofit client:
Full-stack analytics app for a homeless services nonprofit; relational schema with ERD docs, JavaScript frontend, deployed on AWS EC2.
2025
- DSA Portfolio:
26 documented Python solutions across 8 topics at an 86.8% acceptance rate, each with complexity analysis and technique rationale.
2025
Other Achievements
- First place, Vibe-A-Thon competition with BYU's AI Association
- Ambassador, BYU Healthcare Leadership Club; competing in the Wasatch Healthcare Leadership Competition; Regents Scholar; Highland City Youth Council member
- Eagle Scout; LDS Church volunteer in Germany, managing $100K+ monthly expenses