Lake Mauer professional headshot

Lake Mauer

Data & Business Analytics professional — turning raw data into decisions for finance teams that value both the numbers and the person behind them.

About Me

I am a senior at the University of Iowa graduating in 2026 with a Bachelor of Business Administration in Business Analytics and Information Systems. Before transferring to Iowa, I earned an Associate of Arts in Business from Hawkeye Community College — Dean's List, 3.5 GPA — which gave me a strong foundation before I went deeper into the technical side of analytics.

Since October 2023 I have been a Business Intelligence Intern at VGM Group in Waterloo, Iowa, where I have built 13 and counting reports and dashboards for departments across the company, grown into fluent SQL, and gotten hands-on with ETL processes, Data Modeling, and Data Vault methodology. I work a 30-hour week across sprint-based projects — the same pace you would expect from a full-time junior data role.

I care about making data useful for the people who rely on it. I ask questions, stay curious, and aim to be the kind of teammate who makes everyone around them a little sharper. I am looking for a Data Engineer, Data Scientist, or Data Analyst role in finance where I can keep growing fast.

Skills

Experience

Business Intelligence Intern

VGM Group — Waterloo, IA

October 2023 – Present

  • Built 13 and counting reports and dashboards across multiple business departments using SQL, Tableau, and Power BI
  • Became fluent in SQL and deepened expertise in data engineering, ETL processes, Data Modeling, and Data Vault terminology
  • Work 30 hours per week across sprint-based projects, contributing independently and as part of a cross-functional team
  • Transitioned from on-site to fully remote while maintaining high output and strong collaboration

Projects

Business Intelligence Dashboard Suite

Designed and delivered a suite of department-facing dashboards at VGM Group, aggregating operational data across multiple business units. Wrote complex SQL queries to pull and transform source data, then built interactive Tableau and Power BI reports that reduced manual reporting time and surfaced trends previously invisible to decision-makers.

  • SQL
  • Tableau
  • Power BI
  • SSIS

Customer Churn Prediction Model

Built a classification model in Python to identify customers at high risk of churning from a financial services dataset. Cleaned and engineered features using Pandas, trained and compared multiple algorithms, and delivered a final model with actionable output — highlighting the behavioral signals most predictive of attrition to support targeted retention efforts.

  • Python
  • Pandas
  • Machine Learning
  • Data Modeling

Investment Portfolio Analysis

Conducted an end-to-end Python analysis on a simulated investment portfolio, pulling historical pricing data, calculating returns and volatility metrics, and producing annotated visualizations to communicate findings clearly. Structured the analysis to mirror the workflow a junior analyst would follow in a real finance team environment.

  • Python
  • Excel
  • Data Visualization

Contact

I am actively looking for Data Engineer, Data Scientist, and Data Analyst roles in finance. If my background looks like a fit, I would love to connect.