No "near consensus" about it. The consensus is overwhelming. No atheists! That said, we do have in federal office one open atheist, Rep. Pete Stark, of California, and one undeclared nonbeliever, Senator Bernie Sanders, of my own state of Vermont.
Bottom line, there will be no "finding out" that Obama is a nonbeliever. He has come too far to betray himself at this point--assuming there is something for him to betray, which, sadly, I doubt.
Here is where I got the question from:
I doubt he would ever admit it especially while in office since it would be political suicide.
Plus his personal life would be invaded even more so with added mud slingers and religious linchmobs.
But this question did make me look at POTUS differently.