Senior Analytics Engineer — Snowflake & dbt Lead

Avison Young; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading commercial real estate firm in Toronto is seeking a Business Analyst to join their Data Architecture team. This role involves bridging business stakeholders and developers, managing data systems and pipelines, and optimizing project delivery. The ideal candidate has expertise in SQL, experience with Snowflake and dbt, and strong analytical skills. This position also includes responsibilities as a Scrum Master, enhancing team productivity in a collaborative environment. Join us to make a significant impact on data-driven decision-making.

Qualifications

• At least 4 years of experience in a software development-related role.
• Expert proficiency in SQL and database management systems.
• Experience in environment management and testing.

Responsibilities

• Design, develop, and maintain data models in Snowflake using dbt.
• Facilitate Agile ceremonies and gather business requirements.
• Implement data quality testing and optimize query performance.

Skills

SQL

Analytical skills

Project management

Attention to detail

Team collaboration

Education

Bachelor’s degree in Information Technology or Business

Tools

Snowflake

dbt

ETL tools

Job description

A leading commercial real estate firm in Toronto is seeking a Business Analyst to join their Data Architecture team. This role involves bridging business stakeholders and developers, managing data systems and pipelines, and optimizing project delivery. The ideal candidate has expertise in SQL, experience with Snowflake and dbt, and strong analytical skills. This position also includes responsibilities as a Scrum Master, enhancing team productivity in a collaborative environment. Join us to make a significant impact on data-driven decision-making.