U.S. stock markets aren’t offering the best opportunity and investors should taking bets against them, a chief information officer at a London-based investment manager has told CNBC.