Back to overview

Deloitte Codility Test for Data Analyst Position - What to Expect from OA

Hi everyone!

I have an upcoming Codility assessment at Deloitte for a data analyst position and was hoping to get some insights from anyone who has completed a similar assessment.

The assessment consists of 3 tasks in approximately 120–130 minutes, testing Python and SQL knowledge.

I would especially appreciate any advice on:

  • Question types: Are the questions typically algorithm-focused (similar to LeetCode), or more focused on practical data manipulation and SQL?
  • Difficulty: Are the difficulty of questions similar to LeetCode medium difficulty?
  • Preparation: Are there specific topics or practice resources you would recommend focusing on?
  • Python libraries and data science: Do the assessments also test knowledge of data science concepts or libraries such as pandas, NumPy, and scikit-learn? I have been focusing primarily on pandas and NumPy, but I am unsure whether to prioritize these or general Python problem-solving.

I understand the assessments may vary depending on the role, but I would really appreciate hearing about others' experiences.

Thank you in advance!

3
2
< 100
Be the first to answer!
Nobody has responded to this question yet.
Top answer
Profile picture of Andrzej
Andrzej
Coach
3 days ago
Strategy&, PwC | Middle East, EMEA, CEE

Hey!

A few tips worth considering:

  1. Expect a mix of coding and practical tasks. For a Data Analyst role, SQL and data manipulation are likely to be key, but some LeetCode-style questions might pop up too. The format can vary by team.
  2. Prioritize SQL and Python fundamentals. Focus on JOINs, CTEs, window functions, dictionaries, lists, and basic algorithms. HackerRank, StrataScratch, and LeetCode Easy/Medium are good places to practice.
  3. Don’t overfocus on ML libraries. Pandas and NumPy are worth reviewing, but scikit-learn is probably less relevant unless the role specifically involves ML. Try a few timed Codility exercises as well.
Anonymous A
3 days ago
Thank you very much for your advice and guidance!
Want to learn more about this topic or join the discussion?
Sign up for free with PrepLounge and get access to first-hand insights from consulting experts, practical resources for your consulting interview preparation and an international community of candidates. Join the world’s largest case interview community.
Profile picture of Ashwin
Ashwin
Coach
2 days ago
Ex-Bain | Help 500+ aspirants secure MBB offers

I'd prepare for it as a practical data test first and an algorithms test second. I can't confirm Deloitte's exact format, and it can differ by team and country, so your invitation and any sample tasks it links to are the best guide.

With three tasks in about two hours and Python and SQL both listed, I'd assume at least one SQL or data-manipulation task and at least one general coding task. Joins, grouping, window functions, string and list handling and dictionaries cover a lot of ground. Pandas and NumPy are worth knowing, but I wouldn't rank them above plain Python, because Codility-style platforms usually run your code against hidden test cases and check for correctness and speed. Machine learning libraries like scikit-learn are unlikely to matter unless the job description asks for modelling.

Practise in the same setting. Do Codility's own demo tasks with a timer of around 40 minutes each, and before you submit, test empty inputs, duplicates and large inputs. If a task stalls you, get a simple working solution in first and improve it afterwards.