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.
Tests investigation, reconciliation strategy, and decision-making when data sources disagree materially.
Tests ability to reconcile inconsistent data sources using SQL and sound data logic.
Tests SQL proficiency for cleaning data and diagnosing underlying causes.
Tests knowledge of governance, security controls, and compliant data handling in restricted networks.
Transform Roblox event records by validating fields, imputing missing creators, and reporting quality metrics per experience.
RobloxClean staged customer events and return valid records with invalid-row reasons using joins and CASE logic.
Snowflake ComputingUse SQL to rapidly summarize transaction failures and identify accounts requiring review.
IntuitTests communication skills and ability to tailor analysis for non-technical decision makers.
Tests practical use of statistical modeling for forecasting or operational improvement.
Tests performance optimization practices for BI dashboards as datasets scale.
Tests requirements clarification and dashboard design from ambiguous inputs.
Sign up to see every question
Create a free account to unlock this list and practice real interview questions.