It depends on the industry and like you said many companies do give on the job training if new software or program is introduced.   About transferable skills or software and programs, many BA job posting I have seen does ask for SQL, SAS and/or Microstrategy experience.