Dataford
Top 28
Prep plan
Updated weekly · Last refresh Sep 23

Roche Data Analyst Interview Questions

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

28questions
~4htotal time
Track your progressSign up free to work through all 28 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 6 questions + 2 drills · ~71 min
SQL Top Products by RegionMedium
Practice
Recently asked

Rank Roche products by revenue within each region for the last completed quarter using CTEs, joins, aggregation, and RANK().

JoinsRankingAggregationsRoche
Read CSV With PandasEasy
Recently asked

Assesses practical SQL-adjacent data ingestion skills with pandas.

pandasRoche
Data Accuracy With Missing ValuesMedium
Recently asked

Evaluates your data quality practices and handling of missing values for leadership reporting.

missing valuesdata accuracyreport preparationRoche
SQL for User Engagement TrendsMedium
Practice
Practice drill

Aggregate user engagement by feature and date, then compare daily activity with the previous available date.

Lag/LeadDate FunctionsGroup Byhhims & hersGGovTechIImpetus Technologies
Top Credit Score Applicants by StateMedium
Practice
Practice drill

Identify the highest-credit-score 5% of applicants within each state using percentiles and window ranking.

Window FunctionsJoinsRankingAmerican Credit Acceptance
More SQL & Data Manipulation questions with a free account
2
Metrics4 questions · ~34 min
Estimate Diagnostic Reporting VolumeMedium
Recently asked

Evaluates your ability to build reasonable data volume estimates using assumptions and decomposition.

Roche
Building a Dashboard From ScratchMedium
Recently asked

Tests end-to-end dashboard design, stakeholder alignment, and decision impact.

KPIsLeading IndicatorsDiagnosisRoche
Choosing a Distribution VisualizationEasy
Recently asked

Tests visualization selection and ability to justify chart choice for time-based distribution insights.

KPIsLeading IndicatorsDiagnosisRoche
More Metrics questions with a free account
3
Behavioral & Leadership16 questions · ~135 min
More Behavioral & Leadership questions with a free account
4
More topics2 questions · ~17 min
Diagnose Dashboard Pipeline FailuresHard
Recently asked

Identify whether a dashboard issue comes from the source data, workbook logic, or Tableau Server.

InfrastructureDependenciesQualityRoche
Measuring Tool Productivity GainsMedium
Recently asked

Tests experimental thinking, metrics selection, and statistical evaluation of productivity changes.

ExperimentationStatistical SignificanceA/B TestingRoche

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