Top 39
Prep plan
Updated weekly · Last refresh Oct 17

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 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
ExecutionStart here. 3 questions · ~24 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
NLP Techniques UsedHard
Recently asked

Assesses your experience with NLP methods and how you apply them to real problems.

experienceSun Life Financial
More Execution questions with a free account
2
SQL & Data Manipulation5 questions + 3 drills · ~70 min
SQL and Excel Tool FamiliarityMedium
Recently asked

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

work historysqlExcelSun Life Financial
SQL Left Join FilteringHard
Recently asked

Tests your SQL understanding of join semantics and how filters affect result sets.

JoinsData AnalysissqlSun Life Financial
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
DBMS and Data ManipulationMedium
Practice
Recently asked
Practice drill

Model related policy and claim data, then summarize approved claims while preserving policyholders without claims.

Joinssqldatabase designSun 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 FinancialAApteanSun Life
SQL ExperienceMedium
Practice
Practice drill

Aggregate approved employee hours by department, including departments without qualifying records.

experienceJoinsCase WhenNational IndemnityDayforceAvalara
More SQL & Data Manipulation questions with a free account
3
Behavioral & Leadership28 questions · ~224 min
More Behavioral & Leadership questions with a free account
4
More topics3 questions · ~24 min
Tell Me About YourselfEasy
Recently asked

Craft a concise self-introduction that highlights fit, communication style, and relevance for an Account Executive role.

brand cultureBusiness AcumenCompetitive AnalysisSun 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
Recently asked

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