How would you handle common analyst workplace scenarios?

You are interviewing for an Analyst role. The online assessment (OA) focuses on behavioral/situational judgment and written communication rather than technical SQL.

Answer the following workplace scenarios. Keep responses concise but specific (assume 5–10 sentences each unless an email/presentation is requested). State your assumptions when needed.

Scenarios

1. Project reassignment : Your manager tells you they want to move you from Project A to Project B .
   • What would you say in the moment?
   • What clarifying questions would you ask (scope, priorities, handoff, success metrics)?
2. Prioritization with deadlines : You are given several work items with different due dates and levels of urgency/impact.
   • Describe how you would prioritize what to do over the next few days.
   • Explain how you communicate tradeoffs and risks.
3. Project delay communication (email) : Your project is going to miss the deadline .
   • Write an email to your manager and a partner team explaining the delay.
   • Include: current status, root cause, impact, mitigation plan, revised timeline, and what you need from stakeholders.
4. Communication breakdown in a diverse team : The project team is diverse (different backgrounds/time zones/working styles) and communication is not going smoothly.
   • What steps would you take to improve collaboration and alignment?
   • How do you ensure inclusive communication and prevent misunderstandings?
5. Executive communication/presentation : Given a document (assume it describes a project update or analysis), prepare a short presentation for the CEO .
   • Provide a 5–7 slide outline (titles + 2–4 bullets each).
   • Explain what you would emphasize for an executive audience and what details you would omit.

What is being evaluated

• Prioritization and ownership
• Stakeholder management and clarity
• Professional, actionable written communication
• Executive-level summarization
• Collaboration and inclusive teamwork