Dataford
Top 11
Prep plan
Updated weekly · Last refresh Sep 9
C

Capital i Data Analyst Interview Questions

The questions to prepare for a Capital i Data Analyst interview. Questions from real interview reports rank first. Updated daily.

11questions
~1htotal time
Track your progressSign up free to work through all 11 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 4 questions + 3 drills · ~62 min
Reconciling Major Data Quality DiscrepanciesHard

Tests investigation, reconciliation strategy, and decision-making when data sources disagree materially.

Data Qualitydata validationdiscrepancy handlingCCapital i
SQL Reconciliation Across SystemsMedium

Tests ability to reconcile inconsistent data sources using SQL and sound data logic.

legacy systemssapCCapital i
SQL Data Cleaning and Root CauseMedium

Tests SQL proficiency for cleaning data and diagnosing underlying causes.

data cleaningsqlCCapital i
Data Governance in DoD EnvironmentsMedium

Tests knowledge of governance, security controls, and compliant data handling in restricted networks.

security complianceCCapital i
SQL Duplicate Record CleanupMedium
Practice
Practice drill

Identify duplicate transaction rows, retain the earliest record, and delete later duplicates safely.

deduplicationdata cleaningtransactionsOracleMicrosoft
Debugging a Timestamp ColumnMedium
Practice
Practice drill

Audit raw timestamp values, identify formatting and timezone issues, and return normalized PostgreSQL timestamps.

data cleaningDate Functionsdata validationKeystone StrategyKeystone
SQL Anomaly Spikes QueryMedium
Practice
Practice drill

Use partitioned ranking to identify the two highest sensor readings per device.

Data Manipulationsqldata anomalyJohnson & Johnson
2
Behavioral & Leadership4 questions · ~32 min
Presenting to Non-Technical LeadersMedium

Tests communication skills and ability to tailor analysis for non-technical decision makers.

presentation skillsStakeholder ManagementCommunicationCCapital i
More Behavioral & Leadership questions with a free account
3
More topics3 questions · ~24 min
Statistical Modeling for ForecastingMedium

Tests practical use of statistical modeling for forecasting or operational improvement.

ForecastingCCapital i
Keeping Dashboards PerformantMedium

Tests performance optimization practices for BI dashboards as datasets scale.

optimizationCCapital i
Power BI From Vague RequestMedium

Tests requirements clarification and dashboard design from ambiguous inputs.

stakeholder communicationdashboard designCCapital i

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
The finish line: interview-readyComplete all 11 questions plus 3 hands-on drills to finish this plan.