Logan Spencer
Data engineer building production dbt models on Snowflake and the reporting layer on top of them, with four years across warehousing, backend systems, and analytics automation. Validates every metric against both the warehouse and the source system. MISM candidate 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
Expected Apr 2027
Minor: Healthcare Leadership · GPA 3.75 · 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 Engineering: dbt, ETL/ELT Modeling, Fivetran, Data Validation, Data Cleaning, API Integration, Star Schema Design
Data & Analytics: Advanced SQL, Snowflake, PostgreSQL, Oracle, Tableau, Power BI, RStudio, Regression Modeling
Programming: Python (Pandas), SQL, R, JavaScript, C#, .NET, Swift
Cloud & Tooling: AWS (EC2, RDS, S3), Azure DevOps, Git/GitHub, Claude Code, Docker
Methodologies: Agile / Scrum, Cross-Functional Collaboration, Stakeholder Reporting, Metric Definition
Projects
- Time Series Demand Forecasting, BYU IS 555:
Forecasting pipeline in R comparing Auto ARIMA, Boosted ARIMA, and Prophet over 2.5 years of weekly shipment data; winner deployed as a Dockerized vetiver REST API.
2026
- DSA Portfolio:
26 documented Python solutions across 8 topics at an 86.8% acceptance rate, each with complexity analysis and technique rationale.
2025
- 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
Other Achievements
- First place, Vibe-A-Thon competition with BYU's AI Association
- Ambassador, BYU Healthcare Leadership Club; Regents Scholar; Highland City Youth Council member
- Eagle Scout; LDS Church volunteer in Germany, managing $100K+ monthly expenses