Yes, you will normally use a singular noun adjectively but there are always exceptions as you've come to realize. He's a car mechanic. (He's a mechanic for cars; the plural is inappropriate here ) He's a system/systems analyst.
New words, one handy idiom, and a 2-minute quiz — delivered to your inbox to keep your streak alive.