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.

Step into this interview

Free · a live voice mock calibrated to this exact role

Practice this 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

Related interviews