City National Bank Data Analyst Interview Questions
The questions to prepare for a City National Bank Data Analyst interview. Questions from real interview reports rank first. Updated weekly.
Use a CTE, join, and dense ranking to return each client's second-highest distinct transaction amount.
City National BankExplain how to rate SQL capability on a 1-10 scale using concrete skills like filtering, joins, aggregations, and window functions.
City National BankExplain how clustered and non-clustered indexes differ in storage, lookup behavior, and query performance.
City National BankFind the top 3 customers in each region by transaction volume using joins, aggregation, and window ranking.
JPMorganChase
Silicon Valley Bank
NaviAggregate monthly sales by product category and use LAG to calculate month-over-month changes.
Total Wine & More
Inc.
Benjamin MooreExplain how you replaced a manual Excel workflow with an automated ETL or Python pipeline, including quality checks and scheduling.
City National BankPractical approach for maintaining data quality across ML ETL pipelines, orchestration, and repeatable data processing.
City National BankDesign a repeatable dashboard refresh pipeline that handles late corrections, reruns, and backfills while keeping visualization outputs deterministic.
City National BankSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Tests your skills in KPI design, measurement, and alignment to business goals in banking contexts.
City National BankTests your approach to measuring product outcomes and translating data into business insights.
City National Bank