Top 24
Prep plan
Updated weekly · Last refresh Oct 17

Suntrust Investment Services Data Analyst Interview Questions

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

24questions
~3htotal time
Track your progressSign up free to work through all 24 questions and resume where you left off.
Start practicing free →
1
MetricsStart here. 3 questions · ~24 min
Analysis That Drove Measurable ImpactEasy

Describe a case where your analysis used the right metrics, shaped a decision, and produced a meaningful business result.

KPIsLeading IndicatorsDiagnosisSuntrust Investment Services
Define Success for a ProjectEasy

Define what success means for a project using clear KPIs, a north star, and supporting metrics.

KPIsSuccess CriteriaDiagnosisSuntrust Investment Services
More Metrics questions with a free account
2
SQL & Data Manipulation6 questions + 3 drills · ~78 min
Transforming Data with SQL or SASMedium

Tests your practical skills in SQL or SAS for dataset transformation at scale.

sqlSuntrust Investment Services
Building Dashboards for LeadersMedium

Tests your dashboarding skills and ability to communicate insights to senior stakeholders.

power bidashboardingSuntrust Investment Services
Data Cleaning and PreparationMedium

Tests your approach to preparing data for analysis and ensuring analytic readiness.

data preparationdata cleaningToolsSuntrust Investment Services
SQL for Weekly PerformanceMedium
Practice
Practice drill

Use joins, weekly aggregation, and LAG to measure Clear location performance and week-over-week transaction changes.

Window FunctionsDate FunctionsAggregationsClearApex SystemsCisco Restaurant + Bar
Monthly Sales Trends by CategoryMedium
Practice
Practice drill

Aggregate monthly sales by product category and use LAG to calculate month-over-month changes.

InfrastructureToolsData WranglingTotal Wine & MoreInc.Benjamin Moore
Data Cleaning and PreparationMedium
Practice
Practice drill

Prepare valid YipitData observations by removing missing, blank, negative, and undated records.

data preparationdata cleaningnull handlingYipitData
More SQL & Data Manipulation questions with a free account
3
Behavioral & Leadership12 questions · ~96 min
More Behavioral & Leadership questions with a free account
4
More topics3 questions · ~24 min
Align Analysis to Client GoalsEasy

Framework for keeping marketing analysis tied to client goals, decision needs, and measurable business outcomes.

User NeedsValue PropositionUse CasesSuntrust Investment Services
Automating Manual Financial ReportingMedium

Discuss automating a manual reporting workflow with code, focusing on batch ETL, orchestration, and data quality.

Data WranglingETLAutomationSuntrust Investment Services
ETL Experience in AnalyticsMedium

Tests your understanding of ETL concepts and ability to support reliable data pipelines.

Data AnalysisETLprocessSuntrust Investment Services

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