The Wall Street executive told CNBC's Leslie Picker on Monday that artificial intelligence is not just a passing fad and will "be used in almost every job."