P2Pool deposits earnings directly to your wallet address, so yes, it needs to be open. This is assuming of course that you only have one miner running, if you have more than one, then all you need to do is put your wallet address you want the coins to be sent to into the miner configuration, you don't need more than one wallet open at a time.