Top 14
Prep plan
Updated weekly · Last refresh Aug 30

Aubay Spain Data Analyst Interview Questions

The questions to prepare for a Aubay Spain Data Analyst interview. Questions from real interview reports rank first. Updated weekly.

14questions
~2htotal time
Track your progressSign up free to work through all 14 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 5 questions + 1 drill · ~59 min
SQL Top Products by RegionMedium
Practice

Rank Roche products by revenue within each region for the last completed quarter using CTEs, joins, aggregation, and RANK().

JoinsRankingAggregationsAubay Spain
Second Highest Trader SalaryEasy
Practice

Find the second highest distinct salary from a single table using basic PostgreSQL ordering and limiting.

SubqueriesRankingSortingAubay Spain
Handling Missing Data in SQLEasy

Explain how to identify, assess, and handle missing values in SQL using NULL checks, COALESCE, and validation logic.

Data WranglingCase WhenQualityAubay Spain
Window Ranking in Ticket QueuesMedium

Explain SQL window functions and when to use ROW_NUMBER() versus DENSE_RANK() for ranked ticket analysis.

Window FunctionsRankingrow_numberAubay Spain
Handling Missing and Inconsistent DataMedium

Tests practical data cleaning strategies and robustness of your analysis pipeline.

Data WranglingCase WhenQualityAubay Spain
Top Paid Per DepartmentEasy
Practice
Practice drill

Find the top 3 highest-paid employees in each department using window functions.

Window FunctionsRankingBrillioAubay SpainSabre Systems

Sign up to see every question

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

Get my prep plan
2
Behavioral & Leadership9 questions · ~87 min
Delivering Under Severe Time PressureMedium

Tests prioritization under pressure, ownership, and stakeholder management when a deadline is fixed and the work is at risk.

stress managementConflict Resolutiontime managementAubay Spain
Responding to Model FeedbackEasy

Tests how you handle direct feedback on analytical work, especially your openness, rigor, and ability to improve the model and your process.

resiliencefeedbackanalytical modelsAubay Spain
Executing Through Ambiguous RequirementsMedium

Tests how you handle ambiguity while maintaining accuracy, documentation discipline, and ownership of the final output.

AccuracystarDealing With AmbiguityAubay Spain
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 14 questions plus 1 hands-on drill to finish this plan.