Yes. You are liable to pay Singapore tax for the professional services rendered in Singapore. It does not matter where you are paid.
The foreign consulting firm is required to file and pay the withholding tax to IRAS by the 15th of the second month from the date of payment to you.