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

AIG Data Analyst Interview Questions

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

17questions
~2htotal time
Track your progressSign up free to work through all 17 questions and resume where you left off.
Start practicing free →
1
PipelinesStart here. 6 questions · ~48 min
Data Governance in PipelinesMedium

Describe a practical approach to data governance across shared data pipelines, including quality, ownership, lineage, and controlled data access.

InfrastructureQualityAIG
Reporting Solution Through SDLCMedium

Evaluates your end-to-end delivery approach from requirements to deployed reporting.

business requirementssdlcAIG
Scalability vs Immediate ReportingMedium

Assesses how you prioritize tradeoffs between scalable design and urgent stakeholder needs.

scalabilityarchitectureAIG
Dimensional Modeling and WarehousingMedium

Assesses your knowledge of data modeling approaches for analytics and warehousing design.

data architectureAIG
Profiling and Data Mart IntegrationMedium

Tests your approach to dataset profiling, data preparation, and integration into a modern analytics platform.

data integrationAIG
More Pipelines questions with a free account
2
Behavioral & Leadership9 questions · ~72 min
Role Fit and BackgroundEasy

Assesses how your experience aligns with the Data Analyst responsibilities at AIG.

Communicationcareer growthtechnical experienceAIG
More Behavioral & Leadership questions with a free account
3
More topics2 questions · ~16 min
SQL, Python, and BI StorytellingMedium

Tests your practical data analysis and visualization skills to communicate insights clearly.

sqldata visualizationpythonAIG
Reconciling Underwriting vs Regulatory ErrorsMedium

Assesses your ability to reconcile cross-system data and fix issues impacting regulatory reporting.

regulatory complianceProblem SolvingAIG

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
Monthly Sales Trends by CategoryMedium
Practice
Practice drill

Aggregate monthly sales by product category and use LAG to calculate month-over-month changes.

InfrastructureToolsData WranglingTotal Wine & MoreInc.Benjamin Moore
SQL Duplicate Record DetectionEasy
Practice
Practice drill

Find duplicate American Institutes for Research assessment submissions using a CTE, GROUP BY, HAVING, and joins.

deduplicationsqldata integrityAmerican Institutes for ResearchMacy's
Contact Center Agent Performance MetricsHard
Practice
Practice drill

Compute daily agent call KPIs and SLA using joins, aggregations, and window ranking in a contact center model.

ETLAggregationsData ModelingADP
The finish line: interview-readyComplete all 17 questions plus 3 hands-on drills to finish this plan.