Dataford
Top 9
Prep plan
Updated weekly · Last refresh Sep 22
A

ACV Auctions Analytics Engineer Interview Questions

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

9questions
~1htotal time
Track your progressSign up free to work through all 9 questions and resume where you left off.
Start practicing free →
1
Technical FundamentalsStart here. 5 questions · ~47 min
Model Selection for ChurnMedium

Evaluates model selection reasoning for churn prediction problems.

model selectionMachine LearningAACV Auctions
Clean and Prepare Messy DataMedium

Tests data cleaning and preparation approach for reliable analytics.

analyticsdata preparationdata cleaningAACV Auctions
Pandas Data TransformationMedium

Tests practical ability to clean and transform data with Pandas.

pandasdata cleaningpythonAACV Auctions
Pick a Model for the DataMedium

Evaluates ability to match modeling approaches to data characteristics and goals.

analyticsmodel selectionAACV Auctions
More Technical Fundamentals questions with a free account
2
SQL & Data Manipulation3 questions + 2 drills · ~48 min
Complex SQL With Joins and WindowsMedium

Tests ability to write advanced SQL for analytics-style transformations.

Window FunctionsJoinssql queryAACV Auctions
Choosing SQL Join TypesMedium

Assesses practical understanding of SQL joins and production-safe query design.

database conceptsjoin typesAACV Auctions
Optimize a Slow SQL QueryHard
Practice

Rewrite a slow PostgreSQL loan payment query to reduce scanned rows while preserving the required aggregated results.

database optimizationJoinsData WranglingAACV Auctions
Top Assets Over Rolling 30 DaysMedium
Practice
Practice drill

Rank Robinhood assets by completed transaction count and active users over the latest rolling 30-day period.

analyticsDate FunctionsJoinsRobinhood
Rolling 30-Day Behavior PatternsHard
Practice
Practice drill

Identify Kake users with at least three activity days for the same behavior in a rolling 30-day window.

analyticsDate FunctionsJoinsKKake

Sign up to see every question

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

Get my prep plan
3
More topics1 question · ~9 min
Design an A/B TestMedium

Tests ability to design and reason about experiments for product changes at ACV Auctions.

analyticsAACV Auctions
The finish line: interview-readyComplete all 9 questions plus 2 hands-on drills to finish this plan.