Need genuine suggestions for my career

I have been feeling quite stuck lately. I am currently in a BIE profile at amazon with 8 years experience. But I am not sure where I am going in my career. I don't typically work solely on SQL. My work involves use of spark, AWS, python etc etc. but all the interviews are entirely SQL focused. Idk I don't fit in the data science profiles completely as I have not had the complete exposure and also don't fit in development profiles most definitely. I find analytics at most places too basic and i feel really stuck at this point of time. Overworked and underserved.

A lot of interviews I give, it's difficult to explain the complexity of my work which extends beyond just the tools. Other places, the expectations are different. Typically people working in start ups have a lot of horizontal exposure but we solve a lot of problems and go very deep. Idk if it is a mistake to join amazon in an analytics profile.

Also because that is not a typical analytics profile. I feel stupid answering SQL questions. I don't know what I am doing at this point.

Not sure what I can do next?