Dataford
Dataford
Top 37
Prep plan
Updated weekly · Last refresh Oct 17

Oportun Business Analyst Interview Questions

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

37questions
~5htotal time
Track your progressSign up free to work through all 37 questions and resume where you left off.
Start practicing free →
1
MetricsStart here. 9 questions · ~72 min
Analyze Pricing Impact on ConversionHard

Analyze whether a pricing change is hurting rider conversion and cancellations in the booking funnel.

Conversion RateCancellation RateDiagnosisOportun
Measure Core Feature EngagementMedium

Define the metrics that show whether engagement in a core feature is improving.

RetentionDiagnosisEngagement MetricsOportun
More Metrics questions with a free account
2
Execution15 questions · ~120 min
Roadmap a Data Platform InitiativeEasy

Create a roadmap for a data engineering initiative, aligning stakeholders, sequencing scope, and managing delivery risk.

Success CriteriaRoadmappingScope ManagementOportun
Trade Off Delivery for Team HealthHard

Tell me about a time you chose a team-improving decision that slowed short-term delivery.

Trade-offsRisk AssessmentScope ManagementOportun
More Execution questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
3
Product Sense6 questions · ~48 min
Research Motivation Product LensEasy

Explain what drives strong research work and how that motivation connects to user value and product outcomes.

User NeedsValue PropositionOportun
More Product Sense questions with a free account
4
More topics7 questions · ~56 min
Analyzing Large Behavioral DatasetsEasy

Explain how to analyze a complex dataset in SQL, including cleaning, aggregation, trend analysis, and communicating results.

JoinsData WranglingAggregationsOportun
Strategy Recommendation for SQL and Business CaseMedium

Assesses how you connect data analysis to business decisions and craft a clear recommendation.

sqlOportun
Design a Feature ExperimentMedium

Assesses your experimental design skills and how you would measure feature impact.

ExperimentationHypothesis TestingA/B TestingOportun
More questions with a free account
Hands-on SQL practiceWrite and run real queries in the editor. 3 drills · ~30 min
Handling Missing DataMedium
Practice
Practice drill

Standardize missing observation fields with fallback values, missingness flags, and ordered output.

Window Functionsmissing valuesdata cleaningEversource EnergyCincinnati Children's HospitalAdtalem Global Education
Optimizing a Slow QueryMedium
Practice
Practice drill

Rewrite a slow PostgreSQL reporting query to reduce scanned rows, avoid join multiplication, and return accurate monthly site metrics.

Subqueriesdatabase optimizationJoinsContinental FinanceCapgeminiDISH
Detect Consecutive Losing StreaksMedium
Practice
Practice drill

Identify bet365 users with consecutive losing bets above a risk threshold using ordered streak grouping.

abuse trackingData Manipulationsql querybet365
The finish line: interview-readyComplete all 37 questions plus 3 hands-on drills to finish this plan.