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

Sun Life Financial Business Analyst Interview Questions

The questions to prepare for a Sun Life Financial Business Analyst interview. Questions from real interview reports rank first. Updated weekly.

48questions
~6htotal time
Track your progressSign up free to work through all 48 questions and resume where you left off.
Start practicing free →
1
ExecutionStart here. 5 questions · ~40 min
Handle Scope Changes Mid-DevelopmentMedium
Recently asked

Explain how you manage scope changes during development without losing delivery control, stakeholder alignment, or product quality.

AgileScope ManagementProject ManagementSun Life Financial
Execution ScenariosMedium

Tests your approach to structured problem solving and execution under interview scenario prompts.

Problem SolvingSun Life Financial
More Execution questions with a free account
2
SQL & Data Manipulation5 questions + 3 drills · ~70 min
Detect and Clean Duplicate RecordsMedium
Recently asked

Tests SQL skills for deduplication and your approach to maintaining data quality for analysis.

data cleaningReconciliationSun Life Financial
Choose Correct Join TypeEasy
Recently asked

Tests your understanding of join semantics and ability to avoid analysis errors.

Joinsdata integritySun Life Financial
SQL and Excel Tool FamiliarityMedium

Assesses hands-on proficiency with SQL and Excel for analysis and reporting tasks.

work historysqlExcelSun Life Financial
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 FinancialCollabera
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
Top Earners via Table JoinMedium
Practice
Practice drill

Rank Motorola Solutions employees by total earnings using a LEFT JOIN, aggregation, COALESCE, and ROW_NUMBER.

JoinssqlMotorola SolutionsMotorola
More SQL & Data Manipulation questions with a free account
3
Behavioral & Leadership35 questions · ~280 min
More Behavioral & Leadership questions with a free account
4
More topics3 questions · ~24 min
Tell Me About YourselfEasy

Tests your ability to deliver a clear, relevant introduction tailored to the role at Aqr.

Competitive AnalysisGo-to-MarketSun Life Financial
Build Tableau Project Performance DashboardMedium
Recently asked

Tests dashboard design thinking and communication of metrics to non-technical stakeholders.

project healthdashboardingSun Life Financial
Explain Journal EntriesMedium

Evaluates your understanding of accounting concepts and how you apply them in analysis contexts.

AccountingSun Life Financial

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