Canva Analytics Engineer Interview Questions

The questions to prepare for a Canva Analytics Engineer interview. Questions from real interview reports rank first. Updated daily.

16questions

~3htotal time

Track your progressSign up free to work through all 16 questions and resume where you left off.

SQL & Data ManipulationStart here. 8 questions + 1 drill · ~88 min

Rank marketing channels for active Canva campaigns using joins, aggregation, metrics, and a window function.

Rolling Metrics with Window FunctionsMedium

Practice

Calculate rolling three-session energy averages and totals for Tesla vehicles using window functions.

Window FunctionsDate FunctionsRunning Totals

Canva

Optimizing Queries for Changing Business NeedsMedium

Evaluates your ability to optimize SQL and adapt it to evolving business requirements.

business requirementsquery optimization

Canva

Calculate a rolling 7-day average of system error counts using window functions and date-based aggregation.

More SQL & Data Manipulation questions with a free account

Coding3 questions · ~29 min

Assesses your ability to implement reliable data cleaning and validation in Python.

Debugging Failing Data PipelinesMedium

Tests your systematic debugging process for production data pipelines.

data pipelineDebuggingTroubleshooting

Canva

Warehouse API Integration with PythonMedium

Assesses your ability to integrate Python jobs with a data warehouse API.

apidata warehousepython

Canva

Create a free account to unlock this list and practice real interview questions.

Behavioral & Leadership3 questions · ~29 min

More Behavioral & Leadership questions with a free account