Do you know you can change your bridge officer's skills to whatever (almost) you want? So if you want an engineering officer that can create a turret AND shield, you can. Just look for the skill trainer in Earth Space Dock. Granted, he is a little hard to find since his office is tucked away under Admiral Quinn's office.
On the ground, science kits are either focused on healing or buffs and offensive. For an offensive science kit, try slotting Electro-Gravitic Field and Exothermic Induction Field. The first roots and slows all opponents in an area, the second sets them on fire. They'll try to run but becuase they are rooted and slowed, they can't easily escape. Its a nasty combo.
In space, the staple skill that just about everyone uses is Tactical Team (TT). I usually keep two copies of TT running. Be sure to have some shield heals (Science Team, Emergency Power to Shields and Transfer Shield Strength) as well as some hull heals (Engineering Team, Auxiliary to SIF and Hazard Emitters). And as you approach level 50, you will find that you are often facing multiple opponents at once. That is when area attacks like Beam Fire At Will, Torpedo Spread and Cannon Scatter Volley become very useful.
Yeah, I think I retrained one of my bridge officers (for shipboard duties) for hull repair and emergency shields, since I lost one of the engineering stations after settling on the Intrepid
-class vessel. I'll see if I can do that for my away team as well.
I've just now been promoted to Rear-Admiral, so I'm looking at the Sovereign
-class and Luna
-class. And, judging from the needs of the science station - one more shield heal in addition to my engineering shield heal and shield batteries, as well as my tractor beam suppressant and sensor scramble - I may just go with the Luna
I'm going to try out some of your suggestions, specifically the Tactical Team. (And, now that I think about it, I've rarely used tactical skills in space up until now - the only ones I have used infrequently are 'Beam Overload' and 'High Yield Torpedo').
As probably aforementioned, I have the Nimbus III frigate add-on that I use every now and then. I've also recently got some scorpion fighters which helped somewhat in space battles; the Remans or Hirogen I used them on stopped them with cloaked tractor beams. However, I also have another addition I really
like using: Photonic Starships. (Which is interesting since they're 'holograms' and they do actual damage, but as long as they're on my side I'm going with it!