Good SWE can do all 3. The three distinct skill sets are orthogonal to individuals' skills.