Can you describe a situation where you had to work with a difficult stakeholder? How did you manage the situation and what was the outcome?

Situation: A VP requested a new dashboard with shifting requirements and an urgent deadline; the required data wasn't in the warehouse, and the source system owner was unresponsive. Task: Deliver value without over-promising or burning out the team. Action: I scheduled a discovery call to understand the underlying business goal (board reporting on customer acquisition). I mapped data gaps (3 sources, 2 not integrated), estimated effort, and proposed a phased approach: (1) One-time manual extract for the upcoming board meeting. (2) Automated pipeline for ongoing use. I set expectations in writing, held weekly demos, and escalated blockers to leadership when the source owner stalled. I also built a reusable pipeline that served other teams. Result: The VP got accurate data for the board meeting. The automated pipeline went live in 6 weeks. We established a request-intake process that reduced ad-hoc requests by 30%. The stakeholder became an advocate for the data team.