
Lyft
Mid
Drive bikeshare and scooter performance decisions across hardware, ops, and finance with SQL-heavy analysis
Lyft's Urban Solutions team is hiring a Data Analyst to improve bikeshare and scooter market performance across the US, partnering with Product, Engineering, Operations, and Finance. The role requires 3+ years of data analytics experience (consulting, ops, or transportation/logistics preferred), strong SQL and quantitative analysis, and comfort translating ambiguous operational problems into clear frameworks and forecasts. Expect questions on SQL-driven deep dives, building scalable reporting, and forecasting operational needs like staffing and asset maintenance.
Step into this interview
Free · a live voice mock calibrated to this exact role
What this interview tests
- SQL-heavy deep-dive analysis on operational performance data
- Forecasting operational requirements (staffing, service levels, contractual targets)
- Translating ambiguous cross-functional asks into scoped analyses
- Building scalable reporting frameworks and dashboards
- Structured thinking and error-reduction in analytical work
- Presenting findings and recommendations to varied stakeholders (Ops, Product, Finance)
Common question themes
Walk through a SQL-based deep dive you did to diagnose an operational performance problem
Describe a forecasting model or approach you built and how you validated it
Tell me about turning an ambiguous cross-functional request into a clear analysis with minimal oversight
How have you built a dashboard or reporting process that scaled beyond a one-off analysis
Tell me about a mistake you caught in your own analysis before presenting it
How do you prioritize competing asks from Operations, Finance, and Product teams
Related interviews

Lyft
Mid
Data Scientist, Algorithms, Optimization - Fulfillment

Lyft
Senior
Data Science Manager, Machine Learning - Lyft Ads

Lyft
Mid
Data Scientist, Decisions - Central Market Management

Roblox
Senior
Data Analyst, Operations (IP & Legal Compliance)

Roblox
Mid
Data Center Asset Management Analyst

Instacart
Senior