Before a breach in Aphren's wall. Screenshot
There's a lake north-northeast of Dro'dara plantation wayshrine. You will see steps that lead up to Aphren's Hold ruins (steps are left on the screenshot above). Skyshard is actually on the top of the waterfall you see on the picture above.