Citi Data Analyst Interview Questions
The questions to prepare for a Citi Data Analyst interview. Questions from real interview reports rank first. Updated weekly.
Explain how SQL replaces Excel for trend analysis on 100,000+ rows using aggregation, date grouping, and filtering.
CitiExplain how to identify, assess, and handle missing values in SQL using NULL checks, COALESCE, and validation logic.
CitiAggregate monthly sales by product category and use LAG to calculate month-over-month changes.
Total Wine & More
Inc.
Benjamin MooreUse GROUP BY and conditional aggregation to count data quality issues in a single NVIDIA dashboard source table.
NVIDIADeduplicate transactions and impute null costs before reporting customer spend.
ApptioTests your ability to design rigorous experiments and evaluate strategy performance using statistics.
CitiTests your practical judgment about which statistical methods to apply to real data problems.
CitiAssesses understanding of trade processing flows and how data moves across front-to-back systems.
CitiDefine what success means for a project using clear KPIs, a north star, and supporting metrics.
CitiAssesses ability to apply quantitative methods to portfolio optimization and communicate results to clients.
CitiTests your ability to translate transaction data into actionable metrics and business-relevant findings.
CitiSign up to see every question
Create a free account to unlock this list and practice real interview questions.