As a DE, I'd also add that you'd need to know Lead, Lag and recursive functions. If you know recursion with CTE that's even better.
Lead and Lag are especially crucial because we need to keep track of running totals that are later used by downstream users.