What you describe is a Program/Project Manager. But the same principles apply to a Business Analyst. In fact in my time in IT I have found that I end up doing more Business Analyst work because I understand the business, know SQL and programming so I can get the data I need, and I can process the data into something employees and managers can make decisions on. Often this is presented either as a web page or in Excel depending on needs.
I think the most important skills for my success in both IT and business roles has been my understanding of data, data sets, basic statistics, and SQL. If there is one language/skill that will make you a valuable employee to any business/department/project... I think it is the ability to query data with SQL. But to do that you need to understand the underlying details of how data is stored and retrieved. That requires database, SQL, software-specific and business-specific knowledge.
See, you can't outsource the last two of those requirements as they are not generic skills (and sometimes very hard to obtain depending on the software and business). If you know data, databases, and SQL; know a specific industry such as marketing or manufacturing; and can quickly learn the specifics of new software systems, you are nearly guaranteed employment.
So what should we be teaching... I think it's all about CRUA. Create, Retrieve, Update, Analyze data. Hard drives are cheap.. don't worry about delete.