A leader in the SEC's internal investigations has left the agency after over 38 years in federal service.