Top 16
Prep plan
Updated weekly · Last refresh Aug 30
I

Intact Data Analyst Interview Questions

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

16questions
~2htotal time
Track your progressSign up free to work through all 16 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 8 questions + 3 drills · ~94 min
Discuss Data Analysis Tooling ChoicesEasy

Explain how SQL fits with data analysis and visualization tools, and when to use each in an analytics workflow.

JoinsData WranglingAggregationsIIntact
Insurance and Financial Model UnderstandingMedium

Assesses your domain knowledge to interpret model outputs and translate them into actionable insights.

IIntact
Ensuring Data Integrity at ScaleMedium

Tests your practices for data quality, validation, and reliability in large-scale financial analysis.

data validationdata integrityIIntact
Building Reports with Ambiguous RequirementsMedium

Evaluates your ability to clarify requirements, structure analysis, and deliver useful reporting outcomes.

Data AnalysisIIntact
Cross-Referencing Financial FiguresMedium

Assesses your method for reconciling numbers across sources to ensure accuracy and consistency.

data validationIIntact
Standardized Outputs for StakeholdersMedium

Evaluates how you ensure consistency, clarity, and usability of reports for decision-makers.

stakeholder communicationIIntact
Top Customers by Net SalesMedium
Practice
Practice drill

Compute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.

SubqueriesJoinsData WranglingGain DigitalTCSZest AI
Monthly Campaign Performance SummaryEasy
Practice
Practice drill

Aggregate January 2024 campaign data by channel using GROUP BY, filtering, and ordering by total clicks.

JoinsData WranglingAggregationsDNVEversanaDiscord
Employees Per Department QueryEasy
Practice
Practice drill

Use a LEFT JOIN and GROUP BY to count employees in every Auto-Owners Insurance department, including departments with zero employees.

JoinsData WranglingAggregationsAuto-Owners InsuranceSynchrony Financial
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
2
Behavioral & Leadership8 questions · ~64 min
Critical Report Under Tight DeadlineMedium

Tests prioritization under pressure, ownership, and stakeholder communication when delivering a high-stakes report on a compressed timeline.

pressure handlingdeadline managementreportingIIntact
Presenting Analysis to Non-Technical LeadersEasy

Tests whether you can translate complex analysis into a clear, decision-oriented story for non-technical stakeholders.

Stakeholder ManagementCommunicationstarIIntact
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 16 questions plus 3 hands-on drills to finish this plan.