So I‘m a physicist by training, transitioned into IT-Consulting after college, been working there for 4.5 yrs. Mostly done data warehousing from a business analysis POV, so a lot of understanding data from a business perspective, how different data relates to one another, expanding the data model of the data warehouse, specifying ETL-pipelines, managing stakeholders. All on-prem, though, nothing in the cloud. Recently shifted towards the design of a more front-end focused app. Over the course of my career, I started coaching junior colleagues and leading small teams.

I wanna make a career transition away from consulting soon. I could see myself enjoying project management as well as data pipeline stuff and business intelligence.

However, and maybe that‘s impostor syndrome, I feel like I lack specific skills.

Since I didn‘t really work with technologies from this century (all on-prem stuff), I feel like I‘m lacking when it comes to things like cloud and other modern technologies. In terms of data pipelines, I‘m not a data engineer (I never implemented the pipelines myself) although I could probably learn that given a bit of time. In terms of product management, I did do a lot of things related to that, but I‘ve never officially been „the product manager“ because that simply doesn‘t exist on our projects.

My question is plain and simple: On what area(s) should I focus and what courses or certifications could I do to maximize my employability outside of consulting in the north-american job market (PNW)?