I recommend you get in touch with Scott Railton or Greg Boos in Bellingham. Their website is www.cascadiaimmigrationlaw.com. They are highly experienced in Canada -> US immigration and some of the top lawyers in the country on those issues.
He could get a temporary one like a TN or an H-1B depending on his qualifications, the company for which he works, and the length of his stay, among many other factors. There's really not a lot of info here. If you're just asking about how to find a lawyer, you can go to a referral service like ailalawyer.com or just google something like "business immigration attorney" and maybe refine by geography a bit, but immigration is federal law, so in cases like this, a lawyer anywhere in the US (or even a US-licensed lawyer outside the US) could probably get the job done for him.
Suggest you talk with an attorney. Depending on his qualifications and the employer's requirements, he may qualify for TN, H1 or a number of other visas.
TN or H1b are the likely candidates. An experienced immigration lawyer will be able to sort through his qualifications, job, and visa categories during an initial consultation without a problem.