Hello! I've recently started playing STO after many years, and was quickly overwhelmed with so many new duty officers and lots of assignments. In order to help myself (and hopefully others), I typed up a small excel table with duty officer specializations and which traits usually benefit them and their assignments. The idea was that since there are so many random officers and a limited amount of space for them -> then if I knew which traits are useful, I could keep/buy useful ones and sell/downgrade less useful ones. I got the traits by checking assignments in-game, what kind of officer they require and which traits increase or lower the success chance.
The table has 4 sheets, each sheet's name tells you which types of officers you'll find in there. Traits are colour-coded, so that green traits = boosts success chance on assignments, red = lowers success chance, and yellow = both positive and negative. Yellow traits are extremely assignment specific, but it's very worthwhile to have a couple of officers with those traits.
Some officers currently don't have any traits, but that just means that I haven't done any assignments which used those officers. The spreadsheet is open to editing so hopefully other players will slowly fill it up. Though in most cases, there's also a short list of general traits which are useful for duty officers in that specializations (such as assignments which just require a tactical or medical type of officer).
Here's the google docs link and feel free to use it:
https://docs.google.com/spreadsheets/d/1Fq3_3zcKItiQGAcNEn9sIGLbXPlXvIHZoc8x9ebXChg/edit?usp=sharing