The Relationship Executive is responsible for achieving sales targets, focusing on deposits solely from NTB customers, and cross-selling banking products while ensuring compliance with Shariah guidelines and maintaining high service quality standards.