>> where to look for "unique" programming jobs
I could be wrong but I don't think people actively hire for those. It seems most companies want generalists but knowledge of specific frameworks (ie. backend engineer with Snowflake experience). You may be able to connect with a software contract company and chat with someone there to see what roles they have placed recently.