After reading about the Delta Rising Operations Pack, I now understand why Cryptic chose to add a new bridge officer type - Intelligence. Over the past 3-4 years, Cryptic's main source of income in STO has been starships. And they have had increasing difficulty coming out with newer and better starships that did not step on the toes of the current ships.
The recent Galaxy class revamp is the perfect example. Players have been clamoring for a souped up Galaxy class. Cryptic wants to give players a souped up Galaxy class to increase sales. Instead, Cryptic could only give minor upgrades to the Galaxy because any big changes to the BOFF seatings would end up being too similar with another cruiser's BOFF seating - a big no-no as far as Cryptic is concerned.
Hence the Intelligence class. And with the new BOFF type, it looks like Cryptic has added a new starship design rule for T6 ships: The Cmdr. station can either follow the ship type (Cmdr Tac for escorts, Cmdr Eng for cruisers, Cmdr Sci for science vessels) OR the Cmdr. station can now be Intelligence (possibly with the condition that the Lt. Cmdr seat having to obey the ship type).
For example, we can have a T6 Galaxy cruiser that has a Cmdr Intel, Lt Cmdr Eng, Lt Sci, Lt Universal, Ensign Tac. With the simple addition of a new bridge officer type and this new design rule, it opens up so many new combinations of possible T6 starships. This is very cost effective from a game design perspective, even a brilliant stroke of genius.