Atlassian·Data Scientist·Technical Phone Screen
Jun 2026
SQL heavy technical screen for a Data Scientist role at Atlassian. One question, but it had a lot of layers: bidirectional game data, window functions, deterministic tie-breaking. The kind of problem where you think you have it and then realize you forgot to union the opponent's perspective.
- Given a games table where each row represents one team's perspective in a matchup, write a SQL query that treats every game from both teams' viewpoints, then returns each team's top 3 highest-scoring games for the 2024 season. Include team name, opponent name, team score, and a rank column. Break ties by score descending, then date descending, then game_id ascending.
“The union step is where I almost tripped up.” The rest of the author's notes on Data Scientist interview at Atlassian, Technical Phone Screen round, covers how they worked through the question, what the panel pushed back on, and what they would do differently.
View Post