Aydan Koyles
Noblesville
Summary
Lead Data Scientist with expertise in designing and maintaining ETL pipelines, managing SQL databases, and delivering actionable insights through BI tools such as Metabase. Skilled in data engineering workflows, including data transformations, feature engineering, and integration of client databases, with proven experience building predictive models that support decision-making in sports and business operations. Proficient in SQL, Python, and data visualization, with a passion for leveraging data engineering and analytics to drive innovation and performance in the sports industry.
Overview
7
7
years of professional experience
Work History
Lead Data Scientist
Upper Hand
01.2023 - Current
- Designed and maintained ETL pipelines for client databases, ensuring accuracy and scalability.
- Built and optimized SQL workflows and Python scripts for automation, feature engineering, and transformations.
- Developed predictive models that informed decision-making and enhanced client retention.
- Delivered actionable insights via Metabase dashboards, improving client and internal decision-making.
- Contributed to the company’s transition to profitability, collaborating across sales, marketing, and product.
Data Science Intern
Upper Hand
06.2022 - 01.2023
- Assisted with dataset cleaning and integration into client systems.
- Supported ETL pipeline development and performed exploratory analysis in SQL and Python.
- Built dashboards and visualizations to demonstrate insights.
- Collaborated on prototype predictive models for future analytics solutions.
Outside Yard Team Member
Menards
05.2018 - 06.2022
Supported operations through inventory management, customer assistance, and logistics coordination.
Education
Master of Science - Applied Data Science
Indiana University, Purdue University Indianapolis
Indianapolis, IN12-2022
Statistics
Purdue University
West Lafayette, IN05-2021
Skills
- Programming & Data Analysis: SQL (advanced), Python (pandas, NumPy, scikit-learn), R
- Data Engineering: ETL pipelines, transformations, feature engineering, database design
- Business Intelligence: Metabase, Mode, Tableau
- Machine Learning: Predictive modeling, exploratory analysis, statistical modeling
- Collaboration & Tools: Git/GitHub, Jupyter, Google Colab, Deepnote
Timeline
Lead Data Scientist
Upper Hand
01.2023 - Current
Data Science Intern
Upper Hand
06.2022 - 01.2023
Outside Yard Team Member
Menards
05.2018 - 06.2022
Master of Science - Applied Data Science
Indiana University, Purdue University Indianapolis
Statistics
Purdue University
Similar Profiles
Jonthon PriceJonthon Price
Roofing Salesperson at Upper Hand RoofingRoofing Salesperson at Upper Hand Roofing
Sydnie CallahanSydnie Callahan
Receptionist at Upper Hand OrthopedicsReceptionist at Upper Hand Orthopedics
Sidney TrotterSidney Trotter
Medical Assistant/Clinic Surgery Scheduler at The hand and upper extremity center of GeorgiaMedical Assistant/Clinic Surgery Scheduler at The hand and upper extremity center of Georgia
BILLY COXBILLY COX
Summer Camp Supervisor at Brightwood - Forest Manor Community CenterSummer Camp Supervisor at Brightwood - Forest Manor Community Center
Rachelle MullisRachelle Mullis
General Manager at Caliber CollisionGeneral Manager at Caliber Collision