Any officer can use any ship type well enough, just depending on what kind of approach to tactics that you're using.
I would say that the MVAM Prometheus is actually a decent option since you can always fall back to one of the different flight controls to use different boosts to either improve upon or to cover for a weakness in one of your power settings based on your configuration/setup.
The thing about science officers is their innate abilities from leveling fit a more supportive role, and don't necessarily offer straight boosters toward ships. (Tactical provide a good offensive booster, engineers provide a lot of hull boosters) So with that in mind, you have to take a look at your limited science and engineering slots and decide how you want to build your build.
You could use all heals, and build your ship more defensively minded, with using only the tactical slots to cover for your offense. Or you could use offensive science abilities to provide defenses, and fall back to your engineer powers to provide heals and support, with the potential for weapons booster instead of shield/hull booster.
There's also the consideration of building a 'supportive' build, which uses heals and abilities that may be defensive or offensive, but flexible to be used on others. (So, for example; Engineering team and Reverse SHield Polarity for engineering, so you can heal/debuff cleanse allies, and have RSP to provide your shield heals, and then using transfer shield strength, hazard emitters and science team as your science powers, which cover for shield and hull heals that you 'lose' from your engineering configuration, that also can be targeted toward others for support) If you do that, you have the option of making your tactical abilities offensively oriented (boosting cannon rapid fire, or beam fire at will as your offensive options, with torpedo or mine support), or supportive, sporting beams primarily for subsystem targeting, and running attack patterns and/or mines.
I'll start by saying I'm not a big escort fan, however some fleetmate's have been running the MVAM on their sci toons for our pvp matches and they have some pretty sweet builds. As far as escorts go, it's Ltcom sci slot makes it the ideal sci escort. You should still expect to play it liek an escort, it won't magically become an awesome healer ship or anything but the versatility of the extra sci abilities is great. Run a CPB to drain an enemies shields before you fire off your alpha strike? Yes please!
Sci/Escorts are a great combo, since you have SNB to strip away any defensive buffs your opponent puts up when you start attacking.
This, as well as Sensor Scan as a potentially potent AOE debuff and the dampening field power to give your glass cannon a little extra survivability.
IMO Sci/Escort is one of the most potentially powerful combinations the game offers, and the MVAE Prommy is a golden ship to use with it. The only trickly bit id getting enough power to Aux to make your Sci skills really shine without draining too much from engines or weapons.
while you sciship only has access to target system 1 ranks, you can focus your build around at least one or even 2 target system rank 3 abilities and specc into sensors, sen array and use a tachyon array.
i would choose target engines3 (making an enemy unable to turn grants much hit andor crit on the enemy) and shields 3.( opening hull dmg windows). you could also go for target weapons3, to reduce dmg income significally. traget aux3 is wasted, cause most aux abilities work wiith the amount of aux when activated, draining aux energy afterwards is nearly pointless.
to to this you should have at least one beamtype weapon fore and aft.
in addition you can use energy syphon2 in the mvam 3rd rank sciability.