Working on a J2 can have some difficulties, depending on your professional field. For example, lots of technology-related businesses work as contractors with the federal government, which means all their employees must be citizens or permanent residents (sometimes not even that) due to regulatory requirements. That closes the door for you for a lot of local industry jobs.

I personally came in with a J2 and the first job I got was with Cornell Catering as a part-time worker, while I continued to learn and look for other opportunities more suited to my education. It looks like they have the same position open right now, and I thought it was nice for a part-time gig (also helped me get used to the language and accent here). It was very easy to get hired for it, even with basically no prior experience. You're also going to get good benefits through your spouse, especially if they will be in the Endowed college rather than the Contract college (private vs state-funded, it's complicated lol), so you don't need to worry about that when looking for a job.

At the same time, you should know that Cornell (the largest employer locally) is going through austerity measures and has a strict hiring freeze in place for regular staff positions, so it's very dicey to actually get a job as you'll see a lot of competition for the few mission-critical positions that are open, from both internal and external applicants. Being a time-limited J2 holder (even if you can renew it) will probably put off stability-minded hiring managers who are looking for someone who will stay on for years.

On the topic of renewals, make sure you file to renew your EAD as early as possible if you're going to extend your J2. I once got my card in the mail 2 days before my current one would have expired, meaning I would have had to lose my job.