I'm looking for data on occupations by census tract - that is, not the location of the people who engage in the work, but where the work is taking place (something along the lines of Canadian Business Patterns, but for occupations, not industries). Are there any existing tables that provide this kind of data, or is a custom tab necessary?
For the 2006 Census there was the following cumulative profile available at the CT level:
In the 2011 standard product line we have the National Household Survey profile where you can download the entire profile by Census tract. That being said, depending on the level of detail you want for their Occupation variable, the categories may be too broad.
For more specific information, you would need to do a custom data request.