One of the questions was about a time I managed a complex data project with tight deadlines. I explained how I prioritized tasks by first breaking down the project into smaller milestones, focusing on high-impact deliverables, and using tools like Trello and Jira to track progress. Then they asked how I dealt with conflicting priorities from stakeholders, especially when the data showed different results than what they expected. I mentioned a situation where I had to present the findings clearly and objectively, showing the rationale behind the data, while also being open to their concerns and adjusting the analysis when valid points were raised. Another tough question was about managing projects with unclear or changing requirements. I shared an example where the project scope kept shifting. I emphasized how I maintained flexibility by continuously communicating with stakeholders, reassessing goals, and adjusting timelines without sacrificing quality. They were also curious about how I coordinated efforts across departments, so I talked about a cross-functional project where I worked closely with the marketing and finance teams to ensure that everyone’s data needs were met. We had regular sync meetings to align our goals and resolve any data discrepancies early on. When they asked about resource allocation, I explained how I prioritize projects based on business impact and resource availability, making sure to engage with team leaders to ensure everyone had a clear understanding of the priorities. In terms of risk management, they were interested in how I identify and mitigate risks in projects. I gave an example of a project where we were dealing with incomplete datasets, and I preemptively raised this issue with the team, implementing backup plans and working closely with the data engineers to ensure data quality before moving forward. They also inquired about how I handle changes mid-project. I told them about a project where halfway through, the key metrics changed because of new business priorities. I described how I quickly adapted by revisiting the project plan and re-aligning the team's focus on the new objectives. To address the project delivery metrics, I explained the KPIs I typically use, such as time-to-completion, accuracy of the analysis, and stakeholder satisfaction, ensuring the project stays within scope and on time. Lastly, they asked how I handled a project that didn’t go as planned. I recounted a situation where unexpected issues with the data pipeline caused delays, but I managed to mitigate the damage by communicating proactively with stakeholders, adjusting timelines, and reallocating resources to stay on track.