People who have only logical/analytical skills usually fail because they're blind to the emotional realities of the people they deal with. They may be able to make great decisions - when all of the trade-offs are carefully spelled out for them. But when you're CEO, the vast majority of important information is unstated, in how people feel about a course of action, and developing those social skills is necessary for quickly taking the emotional temperature of a room and understanding what people really desire, how much they desire it, and what you can do to make them happy.
Conversely, people with only social skills get paralyzed by decision-making when thousands of people are involved. They want to make the people closest to them happy, which means pissing off a lot of people who aren't complaining now but soon will be. That's the "difference between the corner store owner and Walmart CEO" that the article is talking about.
The best executives I've seen manage to combine deep emotional intelligence with deep intellectual intelligence. They can both quickly understand how everyone is going to feel about a decision (including, particularly, how the people who are going to be hurt by it will feel), and then select a course of action that minimizes the hurt and maximizes the benefit, understanding all the time that some people (often, many people) will be pissed off at them.
Other than that there aren't any specific job requirements, you could be the CEO of a company like General Motors and not know a lot about cars because you've got plenty of people around you.