Urban Company logo

Urban Company Data Analyst Interview Questions
& Process

Real candidates share what happened, how many rounds they had,
and how the experience turned out.

Based on 6 interview experiences · FREE TO READ

3 Rounds average
Average Typical difficulty
66.7% Positive experience

Candidate interview experiences

First-hand accounts from people who interviewed at Urban Company.

Showing 3 of 6
Urban Company logo
Urban Company

Data Analyst

Analytics · nearly a year ago

Entry Average Neutral experience No offer 5 rounds
Interview process
Recruiter call Phone screen Technical screen Onsite Background check Offer
Interview formats
Behavioral Technical

it was a great interview and the people were nice. I was declined though and no reason was given. Overall it was a good experience, I was expecting more examination and explanation though. I wasn't able to contact them afterwards. I don't know what else to write.

Confirmed questions1 question
  • Tell me about your experience level and how you approach stressful situations.
Urban Company logo
Urban Company

Data Analyst

Analytics · a year ago

Entry Average Positive experience No offer 2 rounds
Interview process
Take home Technical screen
Interview formats
Technical Coding

First, I had to complete a take-home assignment with an easy SQL question and a medium Python question. Then, I had a technical interview where they asked some medium-level SQL questions, similar to the assignment, focusing on Joins and Window functions.

Confirmed questions1 question
  • Questions about Joins, window functions, and self joins were asked.
Urban Company logo
Urban Company

Data Analyst

Analytics · a year ago

Entry Average Positive experience Accept offer 3 rounds
Interview process
Recruiter call Technical screen Onsite
Interview formats
Behavioral Technical Coding

The interview had three parts: first, a phone chat, then a technical test, and finally a combined technical and HR interview. For prep, make sure you have a good intro ready and can talk about a project you know well. Also, brush up on SQL, both the basics and stuff like Window Functions.

Confirmed questions8 questions
  • Can you tell us about your background, what skills you have, and your experience?
  • Could you explain SQL concepts such as GROUP BY, HAVING, WHERE, ORDER BY, and how to rename columns?
  • We'd like you to solve some practical use cases to show your SQL knowledge.

Urban Company Data Analyst Interview Questions

Quoted word for word from Urban Company interview reports.

Explain PageRank, when it is used, and what kind of data it is most suitable for.

Read reports

Can you explain PageRank, its use cases, and the type of data it works best with?

Read reports

Could you explain SQL concepts such as GROUP BY, HAVING, WHERE, ORDER BY, and how to rename columns?

Read reports

Can you discuss advanced SQL topics, particularly Windows Functions?

Read reports

Could you describe your experience with SQL, specifically regarding joins?

Read report

How would you approach solving some real-time problems?

Read report

Could you share details about your past internship experiences?

Read report

Formats, difficulty and experience

Across all 6 Urban Company interview reports.

Interview formats

Technical 42.9%
Behavioral 35.7%
Coding 21.4%

Interview difficulty

Easy 0%
Average 83.3%
Difficult 16.7%

Candidate experience

Negative 16.7%
Neutral 16.7%
Positive 66.7%