You're thinking too narrowly about what "schema design" could mean. No, data scientists do not typically design back-end, production database systems. But defining and organizing a multi-sheet spreadsheet for manual data collection is what many data scientists spend much of their time doing (i.e., in the biomedical space). Doing that well definitely requires some understanding of concepts such as functional dependency, normal forms, and data types.