No, your guarantor doesn't have to be employed, but must be aged 19-75, a Canadian resident and not have had any problems paying their bills on time.
They will need to be able to afford to cover the loan repayments if you do not make them, while still being able to live their normal life.