First a recruiter chat, then a SQL screen, followed by a random manager chat (not the hiring manager), then the final round (values, DS tech questions, stakeholders), all spread out over many many weeks
I interviewed at Atlassian
Interview
The process includes the following interviews:
1. Recruiter screening
2. SQL screening
3. Interview with the Hiring manager
4. Data Science Craft screening
5. Atlassian Values screening
Overall pretty standard industry questions.
Interview questions [1]
Question 1
SQL: How many people purchased a product within 30 days after viewing the blog?
I applied online. The process took 5 months. I interviewed at Atlassian in Mar 2022
Interview
The interview process consisted of 4 stages:
I. Recruiter Screen
General questions about background and outlining of the interview process.
II. Hiring Manager Behavioral Interview
Questions about why I'm interested in the company, and what I'm looking for in my next role. The manager then went on to talk about his background, team history, and team needs.
III. SQL Assessment
Basic SQL Assessment testing one's ability to query one and multiple tables (using joins)
IV. Virtual On-site comprising of 4 interviews (described below)
A. Values Interview
You will be interviewed by someone not from the team you're interviewing for (nor for any adjacent team your prospective team will be working with).
B. Business Case Study
Hypothetical questions testing your understanding of the business/domain related to the position you're interviewing from.
C. Advanced SQL Assessment
A deeper SQL assessment with questions involving aggregate functions.
D. Stakeholder Interview
This is an interview with mostly behavioral questions on past projects and experiences working with teams.
Interview questions [3]
Question 1
Q: Tell me about a time when you undertook an important initiative.