Top 39
Prep plan
Updated weekly · Last refresh Sep 18

Verisk Analytics Data Analyst Interview Questions

The questions to prepare for a Verisk Analytics Data Analyst interview. Questions from real interview reports rank first. Updated daily.

39questions
~5htotal time
Track your progressSign up free to work through all 39 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 6 questions + 3 drills · ~78 min
Top-N in SQLMedium
Recently asked

Assesses your SQL proficiency with ranking and limiting results.

sqlVerisk Analytics
Null Handling Before SQL ImportMedium
Recently asked

Tests data cleaning decisions and SQL-ready preparation for policyholder datasets at Verisk Analytics.

null handlingData WranglingExcelVerisk Analytics
Reconcile Client ID Lists in ExcelEasy
Recently asked

Tests practical Excel skills for data reconciliation tasks common in Verisk Analytics workflows.

Data WranglingReconciliationExcelVerisk Analytics
Join Choice and Risk ImpactMedium
Recently asked

Tests SQL join correctness and data integrity thinking for risk assessment workflows at Verisk Analytics.

Joinsdata integrityVerisk Analytics
Second-Highest Claim AmountMedium
Recently asked

Tests SQL windowing or ranking skills for insurance-claims data manipulation at Verisk Analytics.

SubqueriesRankingtransactionsVerisk Analytics
Second Highest Without AggregatesHard
Practice
Practice drill

Find the second highest salary in each department without using aggregate functions.

SubqueriesRankingSelf-JoinsCredit GenieCisco Restaurant + BarDevoteam
SQL Joins and AggregationsMedium
Practice
Practice drill

Join policy and ISO ClaimSearch claim data to aggregate claim counts and incurred losses by state and policy type.

JoinsGroup ByAggregationsVerisk AnalyticsMarshBroadridge Financial Solutions
SQL Duplicate RemovalMedium
Practice
Recently asked
Practice drill

Identify duplicate risk records, retain the lowest record ID, and remove the remaining rows safely.

data cleaningData ManipulationsqlVerisk Analytics
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership31 questions · ~248 min
Handling Silence After an AssessmentEasy
Recently asked

Tests resilience, professionalism, and ownership when effort isn't reciprocated with feedback or closure.

resilienceCommunicationfeedbackVerisk Analytics
More Behavioral & Leadership questions with a free account
3
More topics2 questions · ~16 min
Consolidating Multiple Data SourcesMedium
Recently asked

Assesses your approach to data integration and building a reliable dataset for analytics.

Verisk Analytics
Assess A/B Test SignificanceMedium
Recently asked

Tests experiment design and statistical reasoning for evaluating changes at Verisk Analytics.

experiment designStatistical Significanceprimary metricsVerisk Analytics

Sign up to see every question

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

Get my prep plan
The finish line: interview-readyComplete all 39 questions plus 3 hands-on drills to finish this plan.