Avison Young Interview Questions
The questions to prepare for Avison Young interviews, across all roles. Questions from real interview reports rank first. Updated daily.
Explain how you align stakeholders with competing priorities, make trade-offs explicit, and keep execution on track.
Explain how you prioritize competing research tasks with different deadlines, business impact, and stakeholder needs.
Practical approach for maintaining data quality across ML ETL pipelines, orchestration, and repeatable data processing.
Explain the architecture of a complex ETL pipeline built from scratch, including orchestration, data quality, idempotency, and backfill strategy.
Sign up to see every question
Create a free account to unlock this list and practice real interview questions.
Compare star and snowflake schemas for warehouse design, including trade-offs in normalization, query simplicity, and analytics performance.
Explain a structured PostgreSQL query tuning approach using execution plans, indexes, joins, and CTE evaluation choices.
Summarize project scope, milestone progress, and final presentation outcomes with PostgreSQL joins and aggregations.
GartnerDemonstrate professional SQL skills by combining modeled tables and summarizing completed activity for active entities.
MedpaceAggregate monthly sales by product category and use LAG to calculate month-over-month changes.
Total Wine & More
Inc.
Benjamin MooreBuild an unlevered DCF, calculate implied equity value per share, and test sensitivity to WACC and terminal growth.
Calculate WACC from CAPM, after-tax debt cost, and capital structure weights for use in a DCF.