50/50 split: What I did later, and what I'd say you should do earlier, is to invest 50% of your learning time into learning data and 50% of the other into business.

But then, I'd also invest 50% of my time coding/ building pipelines and roughly 50% understanding business requirements, discussing them, building paper dummies & getting feedback from others even before building anything.

So our prior setup was PDI all the way.

And we switched to an ELT setup with Pentaho still as ingestion only engine (dockerized and with a deployment process), dbt as transformer and dagster as orchestrator.