I'm not sure 'jobs' as we think of them even exist. Virtually everyone we see is a Starfleet officer or a scientist. Presumably there are engineers, architects, etc. I guess people become architects because they want to be architects. We see Joseph Sisko runs a restaurant but that seems to be just because he loves to cook.
Now, what if someone wants to be an architect but just isn't any use at it? Maybe they just keep plugging away, or maybe they find something new. I do wish they'd have fleshed it out more but it probably wouldn't have made very entertaining viewing.