Nowhere in the US are atheists explicitly forbidden from holding a government position as that would be a flagrant and obvious violation of the First Amendment. In many places they certainly won't be voted for if they admit their religious position in public.