So it looks like the card is powering up now. The LED light is on and the fans are spinning at full speed but the card is still not detected. Given this info, is there anything else I should try before RMA'ing?

I've tried connecting different risers to the card, connecting it directly into the PCI slot, change the PSU leads to the card, flipping the bios switch back and forth, but none of that has worked.