In written language it would be best to include the 'that'. In spoken language you could miss it out. You could also make it neater still by omitting the 'who is' 'Bear in mind there's someone waiting for you.'

In my opinion, it is better to write as "Bear in mind there's someone waiting for you.