Keystone Pipeline jobs in the US totaled over 11,000 on a seasonal basis. "Downstream" from those workers staying at hotels, restaurants, diners, etc. raised that total effect to 30,000 jobs.
And the point that is conveniently missed here is that the oil that is transported is SOLD and USED by the customer--regardless of where and who.
Buying that oil would have had an effect of global oil prices. Supply--Demand. You heard of that before. More supply means lower prices.
Very simplistic (and jingoistic) to focus that is was just a Canadian firm.