RealSelf logo

RealSelf Business Intelligence Engineer Interview Questions
& Process

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

Based on 7 interview experiences · FREE TO READ

4.4 Rounds average
Easy Typical difficulty
71.4% Positive experience

Candidate interview experiences

First-hand accounts from people who interviewed at RealSelf.

Showing 3 of 7
RealSelf logo
RealSelf

Business Intelligence Engineer

Analytics · more than a year ago

Senior Average Positive experience No offer 4 rounds
Interview process
Take home Recruiter call Phone screen Technical screen Onsite
Interview formats
Technical Coding Behavioral Other

I sent in my application online and then got a take-home task that I had to finish in 2 days. The assignment covered SQL, data mining, and database design. About a week later, I had a call with a senior recruiter who told me about the company's benefits and what they do. They also asked some basic questions about my previous work and relevant experience. After that, I had a video chat with the hiring manager. They asked a lot of behavioral questions and then gave me a Python coding problem to solve while they watched. I was also asked a few SQL questions. The hiring manager, senior recruiter, and coordinator were all really great people. The coordinator, in particular, was on top of things and communicated really well. I actually enjoyed their interview process quite a bit, though I did get flustered during the video call. So, if you tend to get nervous or doubt yourself during interviews, make sure you prepare thoroughly.

Confirmed questions2 questions
  • Could you describe your approach to a data mining problem?
  • I have a data mining question for you that was part of the take-home assignment. I can't share the specifics, unfortunately.
RealSelf logo
RealSelf

Business Intelligence Engineer

Analytics · more than a year ago

Entry Easy Negative experience No offer 2 rounds
Interview process
Recruiter call Take home Offer
Interview formats
Technical Coding

I had a recruiter call, they were really happy with me. Then I got a take-home assignment. Unfortunately, I didn't get the job because they extended an offer to someone else who was further along.

Confirmed questions1 question
  • Using Python or another scripting language, build a tool that extracts data from MySQL and outputs it as JSON files. Given the provided table schema, identify which columns could be used for a join.
RealSelf logo
RealSelf

Business Intelligence Engineer

Engineering

Mid Easy Negative experience No offer 1 round
Interview process
Take home
Interview formats
Coding

The interview process was terrible. I had to do a take-home test that was due in 12 hours. I finished and submitted it, but only got an automated email saying they needed someone with more experience. This is the second time in two years this has happened with the same automated response. Their interview process is really bad. They either don't know what they're looking for or are really negligent in how they evaluate tests. I'm confident I completed the test correctly with the right Python scripts and SQL. It's super frustrating to have put in so much time and get no feedback, especially twice.

Confirmed questions1 question
  • Could you write a Python script to fetch output from the Twitter API and display tweets from a specific user profile?

RealSelf Business Intelligence Engineer Interview Questions

Quoted word for word from RealSelf interview reports.

Could you write a Python script to fetch output from the Twitter API and display tweets from a specific user profile?

Read reports

How would you go about optimizing a SQL query that is running slowly?

Read reports

Describe a situation where you decided to take a risk. What was the consequence?

Read reports

Can you share an instance where you made a decision that wasn't well-received by others? What happened as a result?

Read report

Describe a Python project you were involved in, including the technologies used.

Read report

Could you describe your approach to a data mining problem?

Read report

Formats, difficulty and experience

Across all 7 RealSelf interview reports.

Interview formats

Coding 30.4%
Technical 26.1%
Behavioral 21.7%
Presentation 8.7%
System Design 4.3%

Interview difficulty

Easy 42.9%
Average 42.9%
Difficult 14.3%

Candidate experience

Positive 71.4%
Negative 28.6%