Job Summary:
Avison Young is a global commercial real estate brokerage and advisory firm, seeking a Senior Analytics Engineer to join their Data Architecture team. In this hands-on leadership role, you will own and scale the analytics layer in Snowflake, focusing on building high-quality data models that enable better decision-making across the organization.
Responsibilities:
• Design, develop, and maintain scalable, business-aligned data models in Snowflake using dbt (staging, intermediate, marts layers)
• Define and enforce semantic consistency, including metrics, dimensions, and KPIs across the organization
• Build and manage dbt projects, including models, tests, documentation, and lineage
• Design, deploy, and maintain Snowflake Cortex Search and semantic models to provide high-quality, governed data structures for LLM-powered applications and AI initiatives
• Oversee development operations and deployments of the data platform
• Translate business requirements into well-structured, reusable data models
• Implement data quality testing, validation, and documentation to ensure trusted data
• Optimize query performance and transformation efficiency in Snowflake
• Establish and enforce data modeling standards, best practices, and design patterns
• Develop reusable analytics components to accelerate data product development
• Partner with business stakeholders to define metrics, KPIs, and data definitions
• Ensure alignment between business needs and technical implementations
• Contribute to the development of data products and semantic layers that support analytics and reporting
• Drive adoption and usability of data models across analytics and business teams
• Lead and mentor a small team of analytics/data engineers
• Set standards for dbt development, code reviews, testing, and documentation
• Contribute hands-on to development (60-70%) while guiding team delivery
• Drive team productivity, technical direction, and project execution
• Support Agile processes, including backlog prioritization and sprint planning
• Gather and refine business requirements for data initiatives
• Translate business needs into clear technical requirements and user stories
• Support deployment, environment management, and release processes
• Ensure high-quality delivery through testing, validation, and stakeholder alignment
Qualifications:
Required:
• 5+ years of experience in analytics engineering, data engineering, or related roles
• Strong expertise in SQL and data warehousing concepts
• Proven experience with dbt and Snowflake (required)
• Strong experience in dimensional data modeling (star schema, marts, semantic layers)
• Experience building and maintaining analytics-ready data models and transformations
• Demonstrated ability to lead projects or mentor team members in a player-coach capacity
• Experience with data quality, testing frameworks, and documentation practices
• Familiarity with Airflow / Astronomer or similar orchestration tools
• Experience working with data pipelines, ETL/ELT processes, and cloud data platforms
• Strong analytical thinking and ability to connect data solutions to business outcomes
• Bachelor’s degree in Information Technology, Business, or a related field, or equivalent experience
Preferred:
• Experience in commercial real estate, geospatial data, or location-based analytics
• Experience building data products or semantic layers for BI tools
Company:
Avison Young is a commercial real estate services firm. Founded in 1978, the company is headquartered in Toronto, CAN, with a team of 1001-5000 employees. The company is currently Late Stage.