Avison Young Interview Questions
The questions to prepare for Avison Young interviews, across all roles. Questions from real interview reports rank first. Updated weekly.
Tests structured self-introduction, career narrative, motivation, and ability to connect past experience to the role.
Tests domain motivation, market understanding, and whether the candidate can connect their research interests to commercial real estate.
Explain how you align stakeholders with competing priorities, make trade-offs explicit, and keep execution on track.
Practical approach for maintaining data quality across ML ETL pipelines, orchestration, and repeatable data processing.
Compare star and snowflake schemas for warehouse design, including trade-offs in normalization, query simplicity, and analytics performance.
Explain how you prioritize competing research tasks with different deadlines, business impact, and stakeholder needs.
Explain the architecture of a complex ETL pipeline built from scratch, including orchestration, data quality, idempotency, and backfill strategy.
Explain a structured PostgreSQL query tuning approach using execution plans, indexes, joins, and CTE evaluation choices.
Sign up to see every question
Create a free account to unlock this list and practice real interview questions.
Aggregate monthly sales by product category and use LAG to calculate month-over-month changes.
Total Wine & More
Inc.
Benjamin MooreCompute daily agent call KPIs and SLA using joins, aggregations, and window ranking in a contact center model.
ADPCompute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.
Gain Digital
TCS
Zest AI