Top 50
Prep plan
Updated weekly · Last refresh Oct 17

Sunrun Business Analyst Interview Questions

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

50questions
~7htotal time
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
StrategyStart here. 12 questions · ~96 min
2
Execution12 questions · ~96 min
Ensure Analysis Data QualityMedium

Explain how you validate data quality before publishing an analysis that will drive an important business decision.

Data WranglingExecutionSunrun
Adapt Quickly in Ambiguous ProjectsEasy

Explain how you learn quickly and adapt in ambiguous execution settings while aligning stakeholders and reducing delivery risk.

Trade-offsSuccess CriteriaRisk AssessmentSunrun
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
SQL & Data Manipulation11 questions + 3 drills · ~118 min
SQL vs Excel for Large DatasetsEasy

Explain how SQL handles large dataset analysis more efficiently than Excel, including filtering, aggregation, and repeatable workflows.

PivotData WranglingAggregationsSunrun
Pivot Reports in SQLEasy

Explain how Excel-style pivot tables, aggregations, and financial calculations translate into SQL reporting workflows.

Data WranglingCase WhenAggregationsSunrun
Handling Missing DataEasy
Practice
Practice drill

Replace missing sales fields with defined defaults and return a consistently ordered dataset.

missing valuesdata cleaningnull handlingUniversity of MinnesotaThe Home DepotNationwide
MoM Lead Conversion SQLMedium
Practice
Practice drill

Calculate monthly California solar lead conversions and their month-over-month percentage growth.

Window FunctionsDate FunctionsJoinsSunrun
Pivoting Data for ReportingMedium
Practice
Practice drill

Pivot product sales into monthly reporting columns with quarterly totals.

PivotJoinsData WranglingWorld Wide TechnologyNestlé USA
More SQL & Data Manipulation questions with a free account
4
Metrics11 questions · ~88 min
Diagnose Rising Customer Acquisition CostsMedium

Diagnose why CAC doubled over three quarters by separating channel efficiency, funnel changes, customer mix, and measurement effects.

CACLeading IndicatorsDiagnosisSunrun
More Metrics questions with a free account
5
More topics4 questions · ~32 min
Choose Key Business VariablesMedium

Tests your analytical thinking for selecting drivers that explain outcomes at Sunrun.

RegressionCorrelationVarianceSunrun
Commitment to SustainabilityEasy

Tests your personal alignment with sustainability values relevant to Sunrun's mission.

User NeedsValue PropositionProduct VisionSunrun
More questions with a free account
The finish line: interview-readyComplete all 50 questions plus 3 hands-on drills to finish this plan.