Diagnose a data pipeline's quality and performance problems

Asked in a hiring-manager conversation for a solutions architect role: how do you diagnose a data pipeline whose output has quality problems, or whose runs have become slow? Walk through a real case. A good answer goes from symptom to root cause step by step, says how each guess was confirmed, and ends with the fix and what was put in place to catch the problem earlier next time.