Is "is" an auxiliary verb in the sentence "John is working now"?

Yes, as described in Wikipedia

The auxiliary verb be is used with a present participle to form the progressive aspect; for example, "I am riding my bicycle"


An auxiliary verb is a verb used in forming the tenses, moods, and voices of other verbs.
In English, such verbs are be, do, and have.