There's a great scene in "Elite Force II" where your character, who led Voyager's equivalent of the MACO's (the Hazard Team) meets Captain Picard, now commanding the Enterprise E.
PICARD: "I enjoyed watching your holodeck session, lieutenant. Where did you train?"
MUNRO: "The Delta Quadrant."
PICARD: "Beg pardon?"
MUNRO: "I led the Hazard Team on Voyager. The Hazard Team was..."
(before he can describe what the team was, Picard's escort interrupts)
ESCORT: "Completely superfluous. My research has indicated that starship captains do not need Hazard Teams."
(Picard, unsurprisingly, does not take it well when some Starfleet bureaucrat tells him what starship captains do and don't need. And he shows Munro that he knew what the Hazard Team was)
PICARD: "I see. And are you a starship captain?"
ESCORT: "Well... no, but..."
PICARD: "The challenges we face on the edge of Federation space are not that different from what Voyager faced in the Delta Quadrant. I could use an elite team of tactical officers." (to Munro) "Tell me, lieutenant... do you ever think of getting back out into the field?"
MUNRO: "Every second of my life, sir."
PICARD: "I'll talk to your commander, see if I can arrange a transfer..."
Picard understood that a starship, especially the flagship, needs its own elite unit; a SWAT unit of sorts (or the aforementioned HRT, the FBI's equivalent), and establishes one. It doesn't make sense that it didn't happen in canon... maybe if they hadn't killed off Tasha, that would have been Worf's job.