I am a Director of Data Science and Software Engineering for a mid sized firm (~1000 employees and $150-200MM revenue). I started with a Finance degree then shifted into an analysis position at a FAANG (lots of excel, SQL, learning how to query big data). This eventually led to learning more about tech (python, AWS cloud stack, messaging queues) and after 8 years in the industry giving me enough experience to manage teams of data scientists, software engineers and data analysts.
Although it is so important to know all the software engineering stack, many companies will benefit from simple business intelligence and data analyst roles. I guess my recommendation is to also keep an open mind in looking for these types of roles in the market (data analyst, business intelligence engineer), because given your desire to learn and existing background, its clear you can make a big impact in those companies as well. And it will be much less competitive than traditional CS crowd.
Some food for thought