Dataford
Top 21
Prep plan
Updated weekly · Last refresh Sep 18

Aviva Data Analyst Interview Questions

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

21questions
~3htotal time
Track your progressSign up free to work through all 21 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 6 questions + 3 drills · ~78 min
Find Trends in DataMedium

Evaluates your ability to explore data and communicate key trends.

AnalysisAviva
Loss Ratio Analysis for New ProductMedium

Tests SQL and analytical approach to compute and interpret loss ratios for product performance decisions.

Data AnalysisAviva
Handling Missing Policy DataMedium

Tests data quality troubleshooting and practical SQL-based remediation strategies in insurance data.

data cleaningdata integrityAviva
Detect and Resolve Duplicate TransactionsMedium
Practice
Practice drill

Identify duplicate transaction rows and explain a safe resolution process for Zions Bancorporation.

deduplicationdata cleaningdata accuracyZions Bancorporation
Remove Duplicates With Window FunctionsMedium
Practice
Practice drill

Identify duplicate dataset records with ROW_NUMBER and delete all but the earliest record in each duplicate group.

Window Functionsdata cleaningdata accuracyAscendion
SQL Duplicate Record CleanupMedium
Practice
Practice drill

Identify duplicate transaction rows, retain the earliest record, and delete later duplicates safely.

deduplicationdata cleaningtransactionsOracleAmexDiscover
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership10 questions · ~80 min
More Behavioral & Leadership questions with a free account
3
More topics5 questions · ~40 min
Segment Customers From Behavior and FeedbackMedium

Approach for segmenting customers using purchase behavior and feedback data.

User SegmentsUser ResearchUser NeedsAviva
Data Validation in ETL PipelinesMedium

Approach for validating ETL data with schema, business rule, and pipeline-level checks.

strategiesETLdata validationAviva
Customer Satisfaction MetricsMedium

Assesses thinking about customer outcomes and selecting relevant metrics.

Aviva
Fraud Dashboard DesignMedium

Tests dashboard design thinking and translating fraud signals into actionable metrics for claims teams.

dashboard designAviva
Actuarial Reporting Data OrganizationMedium

Tests data modeling and pipeline design choices that enable reliable, repeatable quarterly actuarial reporting.

Aviva

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 21 questions plus 3 hands-on drills to finish this plan.