Citi Business Intelligence Analyst Interview Questions
The questions to prepare for a Citi Business Intelligence Analyst interview. Questions from real interview reports rank first. Updated weekly.
Explain how to clean NULLs, standardize inconsistent values, and validate data before building dashboard-ready datasets.
CitiExplain how INNER JOIN and LEFT JOIN differ, and when to use each for matched-only versus all-left-row analysis.
CitiExplain how to ensure data accuracy in SQL workflows using validation checks, reconciliation, and careful query design.
CitiUse joins, CTEs, and row ranking to resolve conflicting customer profile values across ACME House systems.
Ramsey Solutions
ACME HouseReconcile billing and ERP invoice totals using joins, a CTE for latest snapshots, and CASE-based discrepancy classification.
LiteratiUse joins and CASE WHEN to find CRM records with missing, invalid, or conflicting ownership data by team.
AlphaSenseTests prioritization under pressure, ownership, and stakeholder alignment when leading a high-stakes project on a compressed timeline.
CitiTests influence without authority when a stakeholder resists a data-driven recommendation, including conflict handling and outcome ownership.
CitiTests prioritization under pressure, stakeholder management, and ownership when multiple important initiatives compete for limited time.
CitiTests how you translate raw data into actionable business requirements through structured communication, stakeholder alignment, and data-driven judgment.
CitiApproach for maintaining data quality and integrity across ETL pipelines.
CitiSign up to see every question
Create a free account to unlock this list and practice real interview questions.