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)?

1. 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.

1. 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.

1. 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?

1. 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