Olivia Wait
I solve business problems with technology. Right now that means building websites for small businesses, developing data pipelines for a nonprofit, and finishing my master's degree in Information Systems.
Experience
- Data ArchitectSep 2026 to presentHumanitarian Experience, Inc.
- Risk Oversight & AI Implementation InternMay 2026 to Aug 2026Wells Fargo
Built an AI chat agent over 400+ daily reports, cutting time to insight for 8 executives from hours to minutes.
- Data Process and Governance InternJun 2025 to Aug 2025Wells Fargo
Led six threshold reviews in Excel and SQL; five recommendations implemented.
- Research AssistantAug 2023 to Jun 2025BYU Marriott School of Business
- Product Management InternMay 2023 to Aug 2024ProfitOptics
- Quality Assurance TesterApr 2023 to Aug 2023Missionary Training Center
Education
Brigham Young University · finishing a master's degree in Information Systems
Projects
- PyTorchPracticePractice for PyTorch
- adventure works data platformEnd-to-end data platform ingesting sales, marketing, and customer support data into Snowflake via dbt + Prefect, with an MCP server for AI agentsPython
- dbt cloudDataOps with dbt Cloud — CI/CD for data pipelines, environments, jobs, and data quality at scale
- dbtAnalytics engineering with dbt Core — layered SQL transformations, tests, and documentation on Snowflake
- environment setupData engineering environment configuration with Docker, Python, and cloud tooling (Snowflake, dbt, Prefect)Python
- prefectPrefect 3 pipeline tracking live crypto prices, storing history in Postgres, and alerting on price changes via SlackPython
- modern data warehousesSnowflake MERGE, Streams for CDC, SCD Type 2, and semi-structured JSON queries on real Steam game data
- traditional data warehousesStar schema data warehouse built in Snowflake with SCD Type 1 and Type 2 dimensional modeling
- snowflake startupTwelve progressive SQL exercises in Snowflake covering joins, aggregation, and multi-step CTEs
- data lakesTwo-layer data lake (MinIO + Trino) with ETL from raw JSON/CSV to partitioned Parquet and SQL query layerPython
- docker masteryContainerized 5-service pipeline that cleans loan CSVs, loads them into Postgres, and predicts default risk via an ML CLIPython
- nosqlMongoDB social media backend with dual-schema documents, embedded comments, full-text search, and analytics Parquet exportPython
- movie predictionsFull-stack web app with a Netflix-style UI and ML-powered movie recommendation engine — built as a team capstone projectTypeScript
- BYU SpeechesGroup project built using Agile/Scrum methodology to practice product management workflowsTypeScript
- TurtleShelterWebsite built for a local nonprofit that provides warm jackets to the homeless community in Salt Lake CityEJS