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 MooreCompute daily agent call KPIs and SLA using joins, aggregations, and window ranking in a contact center model.
ADPDesign a relational streaming-event model and return each actor's latest processed event using a CTE and window function.
RobloxExplain 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.