How can I open the cargo bay door?

You will need to get to Evan's room first.

Which will require talking to the steward. Once you can get an access panel to work.

And then figuring out Evan's room number.

And tricking the steward into giving you a spare key.

You'll find a useful tool in Evan's room once you access it.