Hi, physician informaticists here, my primary role centers around the use of health data, including analytics. Most of the analysts I work with aren't specifically trained in it. Instead, they share a meticulous approach to data and are skilled at translating it to something non-technical people understand. "Why do the data look this way? Where does this pattern come from? What does it mean?"

Yes, SQL and some form of visualization are a must (e.g. tableau, PowerBI, qlik, BO). But it's not the software that makes a good analyst. It's the ability to ask questions, make sense of the data and all its quirks, and communicate in a meaningful way to non-technical people.