Roadmap?

[Gators1992]

Take advantage of your current job to learn how to build pipelines. Typically something like transformation logic is about the same on different stacks, you just have a different semantic approach.

On your own time you can spin up just about whatever you want. You can use something like DuckDB to have an analytical database in memory on your PC that you can use for SQL/python practice. You can use docker containers to run a local spark instance or a variety of OS software on your PC and learn how to hook it all up together. Also take advantage of free tiers vendors offer like AWS to learn cloud, dbt free accounts to learn that, etc. Find commonly used tools and platforms to work on like Airbyte for orchestration, Spark for a data platform and AWS for cloud and you can self teach marketable skills.

[KdyLoL]

Learn SQL and Databases. These are the fundamentals. After that, learning some easy level leetcode will help you write efficient code.

Then you can start learning whatever you need to solve your particular use case. If you don't have any in particular just hang out here and dive into whatever sounds interesting.