Avison Young Analytics Engineer Interview Questions
The questions to prepare for a Avison Young Analytics Engineer interview. Questions from real interview reports rank first. Updated daily.
Explain a structured PostgreSQL query tuning approach using execution plans, indexes, joins, and CTE evaluation choices.
Compare star and snowflake schemas for warehouse design, including trade-offs in normalization, query simplicity, and analytics performance.
Assesses your approach to SCD strategies and maintaining historical accuracy.
Aggregate monthly sales by product category and use LAG to calculate month-over-month changes.
Total Wine & More
Inc.
Benjamin MooreApply Type 2 SCD logic to preserve customer history while inserting changed and new warehouse dimension records.
Deloitte
CapgeminiIdentify Revolut merchants with high payment failure rates and report related support-resolution metrics.
RevolutExplain the architecture of a complex ETL pipeline built from scratch, including orchestration, data quality, idempotency, and backfill strategy.
Practical approach for maintaining data quality across ML ETL pipelines, orchestration, and repeatable data processing.
Evaluates your ability to structure dbt models and manage build order and coupling.
Tests your strategy for normalizing, validating, and loading messy inputs into analytics-ready datasets.
Sign up to see every question
Create a free account to unlock this list and practice real interview questions.
Tests prioritization under pressure, stakeholder management, and keeping a team focused when urgent requests compete for attention.