Dataford
Dataford
Top 29
Prep plan
Updated weekly · Last refresh Oct 16

Sun Life Data Analyst Interview Questions

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

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

Explain how to identify, assess, and handle missing values in SQL using NULL checks, COALESCE, and validation logic.

Data WranglingCase WhenQualitySun Life
SQL Insights for Dashboard ReportingEasy

Explain how SQL prepares clean, aggregated data for dashboards and how to describe business impact from visualization work.

JoinsData WranglingAggregationsSun Life
Using Data to Solve BusinessMedium

Assesses problem-solving approach, tooling choices, and measurable impact from data analysis.

Data Analysisbusiness problemSun Life
Running 30-Day Average in SQLMedium
Practice
Practice drill

Calculate GDIT's 30-day average completed transaction volume using daily aggregation and a PostgreSQL window frame.

Window FunctionssqlGeneral Dynamics Information Technologyiinternational BankingNinja Analytics
SQL Query for Third LargestMedium
Practice
Practice drill

Use a CTE, join, and RANK window function to find employees earning the third-highest distinct salary.

aggregationsqlSun Life FinancialAApteanSun Life
Using Data to Solve ProblemsMedium
Practice
Practice drill

Use campaign data to compare conversion performance and demonstrate a data-driven answer with PostgreSQL.

JoinsData Analysisbusiness problemMicrosoft
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership19 questions · ~152 min
Analyzing With Sparse DataMedium

Tests leading through ambiguity with limited data, including structured analysis, assumption-setting, and ownership of a recommendation.

Data AnalysisProblem SolvingDealing With AmbiguitySun Life
More Behavioral & Leadership questions with a free account
3
More topics4 questions · ~32 min
Key Data Warehouse ConsiderationsHard

Explain the architectural, modeling, governance, performance, and operational considerations for designing a data warehouse.

Data QualityInfrastructureETLSun Life
Revenue Forecasting Thought ProcessHard

Tests statistical reasoning and forecasting approach using historical data.

RegressionTime SeriesSun Life
Improving Customer Retention AnalysisMedium

Tests ability to translate transactional data into retention-focused metrics and actions.

Funnel AnalysisMetricsRetentionSun Life
Implementing an ETL PipelineMedium

Tests ability to design and implement ETL workflows that support reliable analytics.

ETLOrchestrationPipelinesSun Life

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