Top 50
Prep plan
Updated weekly · Last refresh Aug 30

Sun Life Business Analyst Interview Questions

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

50questions
~7htotal time
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
ExecutionStart here. 12 questions · ~96 min
Managing Critical Cross-Team DependencyMedium
Recently asked

Explain how you would manage a project at risk due to a slipping dependency owned by another team.

Risk AssessmentDependenciesScope ManagementSun Life
Business Case to SolutionsMedium
Recently asked

Tests problem framing, prioritization, and solution development based on business cases.

Trade-offsSuccess CriteriaRisk AssessmentSun Life
More Execution questions with a free account
2
SQL & Data Manipulation5 questions + 3 drills · ~70 min
Explaining Visualization Tool ExperienceEasy

Explain how you use SQL analysis to build dashboards, choose visuals, and communicate insights to stakeholders.

ToolsData WranglingSun Life
Validating Data Before ReportingEasy

Explain how to validate SQL data before reporting, including null checks, duplicates, outliers, and aggregation reconciliation.

JoinsData WranglingQualitySun Life
Analyze Decision Impact by RegionEasy
Practice
Practice drill

Use joins, CASE WHEN, and date filtering to compare outcome rates before and after a decision.

Data WranglingDiagnosisAggregationsHarbourVest Partners
Resolve Conflicting Customer AttributesMedium
Practice
Practice drill

Use joins, CTEs, and row ranking to resolve conflicting customer profile values across ACME House systems.

JoinsData WranglingQualityRamsey SolutionsACME House
Reconcile Conflicting Invoice TotalsMedium
Practice
Practice drill

Reconcile billing and ERP invoice totals using joins, a CTE for latest snapshots, and CASE-based discrepancy classification.

JoinsData WranglingQualityLiterati
More SQL & Data Manipulation questions with a free account
3
Metrics4 questions · ~32 min
Data Analysis Tools ExperienceEasy
Recently asked

Tests practical tool proficiency for analyzing data and supporting business decisions.

Data WranglingLeading IndicatorsDiagnosisSun Life
More Metrics questions with a free account
4
Behavioral & Leadership26 questions · ~208 min
More Behavioral & Leadership questions with a free account
5
More topics3 questions · ~24 min
Tell Me About YourselfEasy
Recently asked

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

Competitive AnalysisGo-to-MarketSun Life
Business Analyst Role at Sun LifeEasy
Recently asked

Tests your understanding of the Business Analyst role and how it supports Sun Life’s benefits business.

User NeedsValue PropositionProduct VisionSun Life
Sizing a New Safety MarketMedium

Framework for sizing the market for a new safety technology product and narrowing from TAM to a realistic entry opportunity.

EstimationGo-to-MarketMarket SizingSun 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 50 questions plus 3 hands-on drills to finish this plan.