All interviews
Lyft logo

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.

Practice this interview

Free · a live voice mock calibrated to this exact role

Start the mock interview

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

View the original posting

All Lyft Data Analyst interviews

All Lyft interviews

Related interviews