How to Encrypt PII in Data Pipelines While Keeping It Searchable

At Intuit, my team built a data pipeline that processed TurboTax e-filing data. This data needed to be made available for dashboards, analytics, and other downstream use cases. One of the biggest chal