Canva Data Analyst Interview Guide

Three candidates describe Canva's analyst interviews, and their experiences differ in length. All three began with a recruiter or HR conversation. One candidate says it was the only round and ended without a second stage. That candidate's question was a very basic one about how they use SQL. The same candidate found the call lightweight and not especially technical. A second candidate describes a standard recruiter screen about their current role and scope, followed by a discussion of the open role and the qualities Canva wanted.

The SQL screen is the most concrete technical step in the reports. One candidate describes it as taking place in a Google Sheet, using a table of licenses. They were asked to count and rank licenses, and the round tested group by and window functions but not multi-table joins. The last question asked them to interpret the data to shape product roadmaps. Another candidate says they shared their screen with a hiring manager, wrote queries against a table with named columns, and answered business questions. They found the interviewer collaborative and willing to nudge them when they went down the wrong path.

Only one candidate reports a third round, a case study with a second hiring manager. It tested reasoning through a business problem and communicating that reasoning. Because it comes from one report, treat it as a possibility rather than a given.

To prepare, practice aggregation and ranking queries and explain each step as you write it. Be ready to describe your background and SQL experience in plain language. Practice turning query results into a product recommendation, and rehearse a short business case walkthrough. Outcomes in these reports were no offer for two candidates and a pending reply for one. None of the reports describe a timeline, so confirm next steps with your recruiter.