An even simpler solution is to use WHERE to filter out all NULL from VALUE:

SELECT USER_ID, VALUE, RANK() OVER(ORDER BY VALUE DESC) FROM yourtable
WHERE VALUE IS NOT NULL