Dataford
Top 47
Prep plan
Updated weekly · Last refresh Aug 30

Aurora Energy Research Business Analyst Interview Questions

The questions to prepare for a Aurora Energy Research Business Analyst interview. Questions from real interview reports rank first. Updated weekly.

47questions
~6htotal time
Track your progressSign up free to work through all 47 questions and resume where you left off.
Start practicing free →
1
Product SenseStart here. 5 questions · ~40 min
Assessing Climate Change ImpactMedium

Tests structured thinking about climate risk, data needs, and implications for energy decisions.

Aurora Energy Research
Renewables Grid Integration ChallengesMedium

Tests understanding of grid integration challenges and ability to reason about energy system impacts.

challengesAurora Energy Research
More Product Sense questions with a free account
2
Strategy12 questions · ~96 min
China Births in 10 YearsHard

Assesses estimation skills and ability to structure assumptions for a quantitative planning problem.

Market SizingAurora Energy Research
EV Station and Charging FactorsHard

Tests market estimation skills and ability to incorporate real-world constraints for EV infrastructure.

Market SizingAurora Energy Research
More Strategy questions with a free account
3
Execution3 questions · ~24 min
How Would You Organize a Tennis TournamentMedium

Tests structured planning and ability to translate requirements into an execution plan.

organizationAurora Energy Research
More Execution questions with a free account
4
Behavioral & Leadership21 questions · ~168 min
More Behavioral & Leadership questions with a free account
5
More topics6 questions · ~48 min
Back-of-Envelope Modeling and Energy CostHard

Evaluates practical modeling skills and ability to derive insights from data.

modelingAurora Energy Research
Energy Economics: Option PricingMedium

Tests finance fundamentals and ability to translate a payoff into an option pricing approach.

Aurora Energy Research
Manipulate Data for InsightsMedium

Assesses data manipulation skills and ability to turn analysis into decisions.

AnalysisAurora Energy Research
More 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
Hands-on SQL practiceWrite and run real queries in the editor. 3 drills · ~30 min
SQL for Sales and LogsHard
Practice
Practice drill

Aggregate completed Shopify sales and admin logins by merchant and month using CTEs, LEFT JOIN, and conditional logic.

case studysqlShopify
Top Users by Recent Transaction VolumeMedium
Practice
Practice drill

Find the top 3 users by completed transaction volume in the last 30 days using joins and aggregation.

Data Analysisquery optimizationsqlTTier 1 BankRevolutChime
Monthly Retention Cohort AnalysisHard
Practice
Practice drill

Build monthly signup cohorts with CTEs and joins to calculate month 0-2 retention for a self-serve product.

Data Analysisuser retentionCohort AnalysisRed VenturesBILLOpenAI
The finish line: interview-readyComplete all 47 questions plus 3 hands-on drills to finish this plan.