Citi Data Analyst Interview Questions
Citi's Data Analyst interview centers on SQL fluency, Excel modeling, and the ability to translate raw banking data into decisions for stakeholders across risk, operations, or consumer banking. Expect a recruiter/HR screen, a technical assessment covering SQL and Excel and sometimes a short case study, a technical interview digging into your SQL and statistical reasoning, and a behavioral/fit interview with the hiring manager, occasionally including a case presentation to stakeholders.
Interview Process at a Glance
| Stage | Typical Format | What's Assessed |
|---|---|---|
| Recruiter/HR screen | 20-30 min call | Background, motivation, fit |
| Technical assessment | SQL + Excel, sometimes case study | Query writing, spreadsheet modeling |
| Technical interview | 45-60 min | SQL depth, statistical reasoning |
| Case presentation (some teams) | 30-45 min | Communication, business framing |
| Behavioral/fit interview | 45 min | Stakeholder management, resilience |
| Hiring manager review | 30 min | Team fit, final sign-off |
Sample Citi Data Analyst Interview Questions
- Write a SQL query to find customers whose transaction volume dropped more than 30% month-over-month.
- How would you identify which customer segment is driving a rise in loan delinquency?
- Write a query using window functions to rank branches by monthly deposit growth.
- How would you clean a dataset with inconsistent date formats and missing values before analysis?
- Explain how you'd measure the effectiveness of a new fraud alert threshold.
- Given a large transactions table, how would you find duplicate entries without a unique key?
- How would you build a dashboard to track daily credit card application approval rates?
- Walk me through how you'd explain a complex statistical finding to a non-technical banking executive.
- Tell me about a time your analysis was challenged by a stakeholder — how did you respond?
- Describe a project where you had to work with messy, real-world banking data.
- How do you prioritize when given multiple ad hoc data requests from different teams?
FAQs
How much SQL should I expect? A significant amount — most Citi Data Analyst loops include at least one dedicated live SQL round.
Is Excel tested directly? Yes, often through a timed exercise or by walking through a model you built previously.
Do I need banking/finance background? Helpful but not required — strong analytical rigor and communication matter more than prior finance experience.
Is there a case study presentation? Some teams ask candidates to present findings from a take-home dataset to a small panel.
How long does Citi's hiring process take? Typically three to five weeks from application to offer.
Related Interview Guides
- JPMorgan Data Analyst Interview Questions
- Wells Fargo Business Analyst Interview Questions
- Goldman Sachs Financial Analyst Interview Questions
- Deloitte Data Analyst Interview Questions
- Amazon Data Analyst Interview Questions
Practice With InterviewBoost.ai
Sharpen your SQL and stakeholder-communication answers for Citi's Data Analyst loop with InterviewBoost.ai's AI mock interviews, and use Live Interview Assist for real-time coaching during your actual interview. Start a free mock interview at InterviewBoost.ai.