No, you don’t need to be a resident of Dubai to qualify. Any investor globally that meets the professional investor requirements is qualified to invest with Stake for the Golden Visa.
However, you will need to visit Dubai in order to complete the application process.