ON On-site Full-time USD 100,000 – 105,000 / year

Avison Young is hiring a Senior Analytics Engineer

Responsibilities

  • Design, develop, and maintain scalable data models in Snowflake using dbt, including staging, intermediate, and marts layers, aligned with business needs.
  • Define and enforce semantic consistency across the organization, covering metrics, dimensions, and KPIs.
  • 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 or data engineers.
  • Set standards for dbt development, code reviews, testing, and documentation.
  • Contribute hands-on to development, approximately 60 to 70 percent of time, 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.

Benefits

  • Ability to achieve additional compensation through a bonus
Job Details
Location ON
Work mode On-site
Employment Full-time
Salary USD 100,000 – 105,000 / year
Department Information Technology
Category Data & ML
Posted 6 months ago
or drop your CV first
About company
Avison Young logo
Avison Young is a global commercial real estate services firm specializing in property valuation, brokerage, and consulting.
All jobs at Avison Young Visit website