Dataford
Top 50
Prep plan
Updated weekly · Last refresh Aug 30

AIG Claims Financial Analyst Interview Questions

The questions to prepare for a AIG Claims Financial Analyst interview. Questions from real interview reports rank first. Updated weekly.

50questions
~7htotal time
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
MetricsStart here. 6 questions · ~48 min
Core KPIs for Financial AnalystsEasy

Choose the most important financial KPIs, balancing current performance, future signals, and a clear KPI hierarchy.

KPIsLeading IndicatorsDiagnosisAIG Claims
Build a Financial ForecastMedium

Tests forecasting methodology, assumptions, and how you translate data into actionable projections.

Lagging IndicatorsLeading IndicatorsDiagnosisAIG Claims
More Metrics questions with a free account
2
Finance & Accounting7 questions · ~56 min
Why Finance and AccountingEasy

Evaluates your motivation for finance and accounting as a career path.

career motivationAIG Claims
Inverted Yield Curve ExplanationHard

Evaluates your understanding of interest rate signals and macro-financial concepts.

AIG Claims
More Finance & Accounting questions with a free account
3
Behavioral & Leadership33 questions · ~264 min
More Behavioral & Leadership questions with a free account
4
More topics4 questions · ~32 min
Tell Me About YourselfEasy

Tests your ability to deliver a clear, relevant introduction tailored to the role at Aqr.

Competitive AnalysisGo-to-MarketAIG Claims
SQL and Financial ExperienceMedium

Assesses your ability to use SQL to support analysis and reporting for finance stakeholders.

sqlFinancial AnalysisAIG Claims
Your Long-Term GoalsEasy

Tests your career direction and alignment with growth in Aubay Spain consulting.

Go-to-MarketGrowth StrategyAIG Claims
Excel, Lookups, and VBAMedium

Evaluates practical data manipulation skills used to build and validate financial analysis.

excel skillssqlAIG Claims

Sign up to see every question

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

Get my prep plan
Hands-on SQL practiceWrite and run real queries in the editor. 3 drills · ~30 min
Window Function Ranking ClaimsEasy
Practice
Practice drill

Rank open Hanover claims by amount within each active customer using RANK and a customer join.

Window FunctionsRankingpartitioningAIG ClaimsThe Hanover Insurance Group
Identify Funnel Bottlenecks in OnboardingHard
Practice
Practice drill

Use joins, CTEs, and aggregations to find the weakest step in an onboarding funnel and estimate lost conversions.

Funnel AnalysissqlDiagnosisAtlassianRevolut
Analyze Decision Impact by RegionEasy
Practice
Practice drill

Use joins, CASE WHEN, and date filtering to compare outcome rates before and after a decision.

Data WranglingDiagnosisAggregationsHarbourVest Partners
The finish line: interview-readyComplete all 50 questions plus 3 hands-on drills to finish this plan.