Tell me about a situation where you disagreed with a stakeholder. How did you approach it and convince them?

Situation: During a data pipeline redesign, a product manager insisted on adding a new dimension to the fact table to support a feature. I believed it would create too many partitions and degrade performance. Task: I needed to present a data‑driven argument. Action: I gathered performance metrics from the current pipeline, modeled the impact of the additional dimension using a small test dataset, and prepared a visual comparison of read/write times. I scheduled a short meeting, listened to the manager’s business rationale, and then shared my findings, highlighting the trade‑off between query flexibility and system overhead. I suggested an alternative: using a separate lookup table for the dimension, which would keep the fact table lean. Result: The manager understood the technical constraints, approved the alternative, and we avoided a costly performance regression. This experience reinforced the importance of data‑backed communication and collaborative problem‑solving.