Dataford
Dataford
Top 50
Prep plan
Updated weekly · Last refresh Oct 17

AIG PC Global Services Business Analyst Interview Questions

The questions to prepare for a AIG PC Global Services Business Analyst interview. Questions from real interview reports rank first. Updated daily.

50questions
~7htotal time
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
ExecutionStart here. 12 questions · ~96 min
Handling a Disorganized Interview LoopEasy

Explain how you would respond professionally when an interview loop is disorganized or a key interviewer misses the session.

Success CriteriaRisk AssessmentScope ManagementAIG PC Global Services
Structure a STAR Execution StoryEasy

Explain how to deliver a clear STAR story that highlights your personal ownership and execution impact.

Trade-offsSuccess CriteriaScope ManagementAIG PC Global Services
More Execution questions with a free account
2
SQL & Data Manipulation8 questions + 3 drills · ~94 min
Pivot Analysis for Relias RevenueEasy

Explain how pivot-style aggregations help analyze large Relias datasets by summarizing metrics across dimensions like month, region, and product.

PivotData WranglingAggregationsAIG PC Global Services
VLOOKUP vs INDEX MATCH in SQLMedium

Explain VLOOKUP vs INDEX/MATCH and how lookup design maps to SQL joins and key matching.

JoinsData WranglingAggregationsAIG PC Global Services
Find Duplicate Policy RecordsMedium
Practice
Practice drill

Identify duplicate insurance policy records using business-key aggregation and policyholder details.

Group ByHavingdata validationAIG PC Global Services
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
Dashboard Design for User SegmentsMedium
Practice
Practice drill

Measure dashboard adoption by Johns Hopkins user segment using joins, aggregation, and reporting-period filters.

User NeedsJoinsData WranglingThe Johns Hopkins University
More SQL & Data Manipulation questions with a free account

Sign up to see every question

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

Get my prep plan
3
Strategy11 questions · ~88 min
Estimate Digital Product Market SizeHard

Estimate the market size for a new digital product opportunity using a structured TAM, SAM, SOM approach.

EstimationTAM/SAM/SOMMarket SizingAIG PC Global Services
More Strategy questions with a free account
4
Metrics11 questions · ~88 min
Assess Claims Process EfficiencyMedium

Evaluates how you measure claims cycle time, quality, and cost drivers to improve operations.

KPIsLeading IndicatorsDiagnosisAIG PC Global Services
Root Cause of Renewal DeclineMedium

Evaluates your diagnostic process for renewal performance issues using data and stakeholder input.

Funnel AnalysisLeading IndicatorsDiagnosisAIG PC Global Services
More Metrics questions with a free account
5
Product Sense5 questions · ~40 min
Explain Business Value of AnalysisEasy

Assesses your ability to translate analytical findings into business impact for decision-makers.

User NeedsValue PropositionAIG PC Global Services
More Product Sense questions with a free account
6
Behavioral & Leadership3 questions · ~24 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 50 questions plus 3 hands-on drills to finish this plan.