Top 22
Prep plan
Updated weekly · Last refresh Aug 30

San Diego Gas & Electric Business Analyst Interview Questions

The questions to prepare for a San Diego Gas & Electric Business Analyst interview. Questions from real interview reports rank first. Updated weekly.

22questions
~3htotal time
Track your progressSign up free to work through all 22 questions and resume where you left off.
Start practicing free →
1
ExecutionStart here. 11 questions · ~88 min
Tailor Updates Across AudiencesEasy

Explain how you adapt project communication for executives, partner teams, and engineers without losing alignment or speed.

Trade-offsSuccess CriteriaRoadmappingSan Diego Gas & Electric
Prioritize Across Competing Data ProjectsEasy

Explain how you prioritize across multiple concurrent projects with competing stakeholder demands and limited time.

Trade-offsRoadmappingScope ManagementSan Diego Gas & Electric
More Execution questions with a free account
2
SQL & Data Manipulation5 questions + 3 drills · ~70 min
Handling Ambiguous Data RecommendationsMedium

Tests your approach to making reliable recommendations with imperfect data in a utility context.

SubqueriesData WranglingCase WhenSan Diego Gas & Electric
Identifying Key Data TrendsMedium

Tests your ability to extract meaningful trends from data to inform business decisions.

Window FunctionsData WranglingAggregationsSan Diego Gas & Electric
Deduplicate Out-of-Order Replication EventsMedium
Practice
Practice drill

Use ROW_NUMBER() to keep the earliest created_at 'Repl created' per entity and return out-of-order duplicates to delete.

Window FunctionsSubqueriesJoinsReplitQuantcast
Autonomous vs Manual Drive TimeHard
Practice
Practice drill

Compute per-vehicle daily autonomous vs manual seconds from state-change logs using LEAD and conditional aggregation.

JoinsData WranglingGroup By
Top Customers by Net SalesMedium
Practice
Practice drill

Compute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.

SubqueriesJoinsData WranglingGain DigitalTCSZest AI
More SQL & Data Manipulation questions with a free account
3
Product Sense4 questions · ~32 min
SDG&E Culture FitMedium

Tests your values alignment and motivation for working at a regulated utility.

User ResearchUser NeedsValue PropositionSan Diego Gas & Electric
Framework for Customer Feedback AnalysisMedium

Tests your ability to structure feedback analysis into insights and actionable recommendations.

User ResearchPain PointsUse CasesSan Diego Gas & Electric
More Product Sense questions with a free account
4
More topics2 questions · ~16 min
Analysis That Changed Marketing DirectionEasy

Describe how your analysis of marketing KPIs led to a meaningful decision and how you tied short-term and long-term metrics together.

KPIsLeading IndicatorsDiagnosisSan Diego Gas & Electric
Feasibility Assessment for Energy ProgramsMedium

Tests your process for evaluating feasibility across data, operations, and constraints.

EstimationSWOTMarket SizingSan Diego Gas & Electric

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