“Jew” is a noun. “Jewish” is an adjective. When “Jew” is used as an adjective or occasionally a verb, it is almost always meant as a negative epithet. Therefore:
How many Jews live in this town? Not offensive sounding.
That new place is a Jew bakery. Offensive sounding.
Other than that, whether it sounds offensive or not depends on the context.