A former special adviser to DUP leader Arlene Foster has said he "should have dug deeper" into the details of the ill-fated renewable heat incentive (RHI) scheme.