Senior Analytics Engineer

Join Avison Young’s Data Architecture team as a Senior Analytics Engineer, where you will own and scale our analytics layer in Snowflake using dbt. This is a hands‑on leadership role focused on building high‑quality, business‑aligned data models that power reporting, analytics, and data products across the organization. You will act as a player‑coach, balancing hands‑on development with leadership of other engineers, while partnering closely with business stakeholders to define metrics, data models, and semantic consistency across the company. Your work will directly enable better decision‑making by ensuring data is not just available, but trusted, well‑structured, and meaningful. What we value in a business analys t:Customer-focused: You prioritize building data products and models that are intuitive, trusted, and drive real business outcome s.Attention to detail: You ensure data accuracy, consistency, and quality across complex transformations and model s.Diverse thoughts: You collaborate effectively, incorporate feedback, and value multiple perspectives in shaping data solution s.Team player & leade r: You lead by example—mentoring others, setting standards, and contributing hands‑on alongside your team m.Pragmatic: You balance speed and quality, making smart trade‑offs without compromising long‑term maintainabilit y.Data product mindset: You treat datasets as products, with clear ownership, definitions, and accountabilit y.Global team mate: Comfortable working in a collaborative, distributed team environmen t.The base salary is aligned with market data and is estimated between $93,000 to $120,000 with the ability to achieve additional compensation through bonus. This salary range reflects base compensation for the position across all US locations. Within this range, individual pay is determined by work location and other factors, including relevant education/training, experience, and internal equit y. Responsibilit iesAnalytics Engineering & Data Modeling (Core Focu s):Design, develop, and maintain scalable, business‑aligned data models in Snowflake using dbt (staging, intermediate, marts laye rs)Define and enforce semantic consistency, including metrics, dimensions, and KPIs across the organizat ionBuild and manage dbt projects, including models, tests, documentation, and line ageDesign, deploy, and maintain Snowflake Cortex Search and semantic models to provide high‑quality, governed data structures for LLM‑powered applications and AI initiati vesOversee development operations and deployments of the data platf ormTranslate business requirements into well‑structured, reusable data mod elsImplement data quality testing, validation, and documentation to ensure trusted d ataOptimize query performance and transformation efficiency in Snowfl akeEstablish and enforce data modeling standards, best practices, and design patte rnsDevelop reusable analytics components to accelerate data product developm entData Product & Stakeholder Engageme nt:Partner with business stakeholders to define metrics, KPIs, and data definiti onsEnsure alignment between business needs and technical implementati onsContribute to the development of data products and semantic layers that support analytics and report ingDrive adoption and usability of data models across analytics and business te amsLeadership & Team Responsibilities (Player-Coac h):Lead and mentor a small team of analytics/data engine ersSet standards for dbt development, code reviews, testing, and documentat ionContribute hands‑on to development (~60–70%) while guiding team deliv eryDrive team productivity, technical direction, and project execut ionSupport Agile processes, including backlog prioritization and sprint plann ingCoordination & Delive ry:Gather and refine business requirements for data initiati vesTranslate business needs into clear technical requirements and user stor iesSupport deployment, environment management, and release proces sesEnsure high‑quality delivery through testing, validation, and stakeholder alignm entQualificati ons5+ years of experience in analytics engineering, data engineering, or related ro lesStrong expertise in SQL and data warehousing conce ptsProven experience with dbt and Snowflake (requir rs)Experience building and maintaining analytics‑ready data models and transformati onsDemonstrated ability to lead projects or mentor team members in a player‑coach capac ityExperience with data quality, testing frameworks, and documentation practi cesFamiliarity with Airflow / Astronomer or similar orchestration to olsExperience working with data pipelines, ETL/ELT processes, and cloud data platfo rmsStrong analytical thinking and ability to connect data solutions to business outco mesBachelor’s degree in Information Technology, Business, or a related field, or equivalent experie nceNice to ha ve:Experience in commercial real estate, geospatial data, or location‑based analyt icsExperience building data products or semantic layers for BI to #J-18808-Ljbffr