Walk me through the most complex data pipeline you have designed and implemented. What were the key bottlenecks, and how did you resolve them?