There are some trades on the recruiting website that are published, but that you don't generally enter from the street (like Intelligence Operator or Clearance Diver), but for the truely unpublished trades there are really only four:
JTF2
"The Joint Task Force 2 is the unit responsible for Federal level counter-terrorist/hostage rescue operations. Its mandate demands personnel who possesses very specific personal attributes and capabilities and who can be trained to perform a diverse range of unique tactics, techniques and skills."
CSOR
"The creation of the Canadian Special Operations Forces Command (CANSOFCOM) provides the Canadian Government and CDS with an agile, high readiness special operations force (SOF) capable of conducting special operations across the spectrum of conflict at home and abroad. The CSOR will be an integral component of CANSOFCOM, and will provide a rapid response capability for special operation missions throughout Canada and the world. The CSOR will compliment JTF 2 and will be capable of independent high-readiness combat operations. CSOR roles include support to counter-terrorism, direct action, special reconnaissance, non-combatant evacuation operations, as well as defence diplomacy and military assistant. Potential candidates can expect challenging and dynamic employment in small teams as a part of an operationally focused unit. "
CACI
"The CF has a critical need to train a small cadre of Conduct After Capture Instructors (CACI). CAC Instructors provide code of conduct after capture level C training, which includes academic instruction and practical resistance to interrogation."
And Close Protection Operator, who are the bodyguards for (Very)VIPs.
There are also some sub-trades, like HUMINT OP (Human Intelligence Operator - Basically a field interrogator), or CBRN Op that aren't published outside the Forces, but you just do that job for a year or two and then back to your old trade. Most, if not all, of these trades and sub-trades, though, pretty much require you to be in your trade for four years (though there are exceptions), so don't go thinking you can walk out of basic and into JTF2 (unless you really ARE that awesome...).
