Few hundred CAD, how did you come up with that number?
Please don’t spread misinformation like this. It’s an extremely bad idea to not understand the tax liability.
If you did get paid in USD by your employer, then they will not withold any state tax, you will need to keep making quarterly payments towards the provincial tax due based on the province of your residence. You’d also need to file federal taxes in Canada though you’d get credit for the taxes that you paid in the US.
In general, this is an extremely bad idea because you won’t be paying into CPP and EI. If you lose your job, you won’t be eligible for EI.
You have two options, you work for the company as a contractor, in which case do factor in the CPP and EI contributions as you will be responsible for both the employer and employee portions in deciding your hourly rate. One thing to note is that if you work full time only for this one company, then you’re not a contractor and will be classified as an employee and should that happen your employer is liable for fines and paying their portion of EI and CPP.
Another option is for your company to work with a payroll provider with operations in Canada, you will be an employer of this Canadian company and be contracted out to the American company. There’s an overhead of between 10 - 15% of your base salary that the intermediate company will charge for their services. In my opinion, this is the most hassle free way. The previous option involves a bit more work, the advantage there is that you will end up with more money in your pocket as there is no middle man, but talk to an accountant and determine your hourly rate, otherwise you’ll end up with much less money when the government has taken their cut.