How would you design a data pipeline that supports downstream clinical analysis while maintaining compliance and auditability?