I work with a bunch of data scientists who don't know T-SQL at all. It's not a core skill. Beneficial, yes. Core skills are more like Python or R (with a good couple years experience at the least) or other specific languages, a comprehensive grasp of statistics, knowledge of advanced maths (matrix mathematics, linear algebra) and some knowledge of the business domain to know what questions to ask