The outcome of the US election matters to Northern Ireland, the leader of the official Opposition at Stormont has said.