The Religious Test Clause states that there be no religious test ever be required for any office or public trust in the US.
One would assume, in normal times, that includes all government offices as well.
https://constitution.congress.gov/browse/article-6/clause-3/
In fact several states refused to vote in favor of the original constitution unless there was a Freedom of Religion amendment. Freedom of religion has been interpreted as including non religious beliefs.