New Snowflake survey illustrates how demand for tech jobs is evolving away from basic skills to high-level AI oversight.