dbt core for transformation (I use dbt cloud but have never successfully used dbt core)
python api requests to grab the data (maybe? i did API stuff a bit in bootcamp but have never used it since)
maybe meltano? It has an open source tool that I'm curious about, but I don't know if it really makes sense for this project.
metabase or lightdash for visualization--both have open source versions I believe. I've messed around with metabase but not lightdash and am curious about both.
duckdb, if it makes sense to use it. I'm super curious about how it works and would love to understand it better by actually working with it.