It's a definitely a lot more than being confident. There's a ton of important data skills, people management and strategy skills involved, and a lot of times your "clients" are not on your side. It's pretty common for a CEO or department head to hire a consultant to work with a department that's not doing well, so the folks you actually end up working with can resent you (especially when they know how much you're getting paid).