WRT the "knot only a butcher would know," I'm going to assume it was the surgeons knot because it is in a picture in the article and could actually be used correctly by both a butcher and binding a person. Only butchers and surgeons use that knot because it is used in cases when the rope/thread is extremely slippery as it makes it easier to keep the knot tight in those cases. No one else uses it though because it can come undone easier than a basic square knot if unbalanced as it is in the picture. So I believe that it could be an indicator that the perpetrator was the butcher.
Overall, I'd say less good than DNA evidence, better than phrenology.
Most people know an overhand, basic bow, reef/granny, slip knot, and half-hitch. They may cobble together a more advanced knot on accident, but that hardly proves experience. The use of climbing, fishing, or rescue knots could indicate something, but that's about the extent without going into pure guesswork.
In the butcher example, the easiest explanation is that the knot came untied, so they added a couple extra wraps to keep it together and probably had no idea it was a different knot used in a particular field.
Much more useful knowledge could be gained by the kind of rope, rope age, and wear patterns.
http://www.slate.com/articles/news_and_politics/jurisprudenc...
https://www.theguardian.com/us-news/2015/apr/21/fbi-jail-hai...
I hope you're right, that it's just one tool to help direct an investigation, and that the confession was true, but I'm not entirely convinced by this article.
It starts by claiming he can tell "whether the knot-tier was left- or right handed, skilled or novice at knot tying, and in some cases, whether the crime was premeditated", but only a couple specific stories are given, and one was a knot which "people wouldn’t know of outside of the butcher trade", which is much more obvious and grounded than the earlier claims.
Of the first 14 Google Image results for "square knot" (before it starts returning other things), 8 tie it one way, and 6 tie it the other way -- and as I scroll down, this ratio seems pretty consistent. He claims for a right-handed person "the knot will almost certainly be formed right handed", but at first glance it seems much closer to 50/50.
This is rather an argument against a jury of laymen.
I don't live in the USA and am not US citizen - many HN readers don't either :-)