Domain knowledge is always useful. But can also introduce biases in one's analysis.

For these types of professional roles you generally see specialized teams in three broad groups: data engineers, modelers/analysts, domain experts. Unicorns sometimes exist, but usually you see T-type experience with depth in one of the three.