Starfleet Design Consultant was a title given to civilian contractors who were consulted by Starfleet on starship design.
After her work on the Galaxy Class Starship Development Project, Starfleet named Dr. Leah Brahms as a Starfleet Design Consultant. This title was mentioned on her biographical data file. (TNG: "Booby Trap", okudagram)