Senior Analytics Engineer

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

About You

You are a high achiever looking to thrive in a fast-paced environment. You take pride in your own work but are comfortable collaborating with a team of highly motivated individuals. You can communicate clearly and concisely with teammates and clients, and you enjoy strong company culture and camaraderie. You can navigate multiple corporate functions, including global lines of service and corporate centers of excellence. You possess strong interpersonal skills and are willing to take on diverse tasks to achieve the team’s common goal. You value personal and professional growth and are ready to take the next step in advancing your career.

About Us

Avison Young is a global commercial real estate brokerage and advisory firm, offering transaction, management, financial and consulting services. We’ve designed our corporate structure to best serve our clients by enhancing collaboration across our organization. Real estate can have an enormous positive impact on people’s lives - and we’re in the business of making spaces and places work better for people. Our purpose is to create real economic, social and environmental value as a global real estate advisor, powered by people. We care about each other and we have each other’s backs. This makes Avison Young a great place to be a client, and a great place to work. We support the whole person and their complete wellness - economic, mental and physical - because what’s best for our business comes from our people bringing their whole selves to work. Of course we love it here, but outsiders think we’re pretty great too! Avison Young has been recognized as one of Canada's Best Managed Companies for the 13th year in a row, with a Platinum Club designation!

Join Avison Young’s dynamic Data Architecture team as a Business Analyst, where you will play a pivotal role in bridging the gap between business stakeholders, users, and developers. You will be instrumental in setting and communicating project and product goals, developing technical requirements, conducting acceptance testing, and overseeing deployments and rollouts. Your work will primarily focus on internal data systems, pipelines, and warehousing projects that support our proprietary products and data visualization teams.

What we value in a business analyst

• Customer-focused: We believe that prioritizing our customers’ needs is key to driving our business forward.
• Attention to detail: Managing complex projects with numerous moving parts requires exceptional attention to detail, organizational skills, and clear communication.
• Diverse thoughts: We value diverse opinions, perspectives, and experiences, as they lead to better outcomes. You actively listen, empathize with others, and seek collaborative paths forward.
• Team player: You understand that more can be achieved together. You listen to feedback and provide supportive feedback to help others grow and improve.
• Pragmatic: You know when to take shortcuts that don’t compromise quality or maintainability to quickly learn what our customers desire.
• Global teammate: Comfortable working in a remote environment, you thrive in a global team setting.
• Senior technical position focused on analytics engineering with Snowflake and dbt.
• Additional responsibilities as Scrum Master for the data team.
• Lead requirements gathering process for data initiatives.
• Design and implement data models and transformations.
• Drive data team productivity and project delivery.

Analytics Engineering Responsibilities

• Design, develop, and maintain data models in Snowflake using dbt.
• Create efficient SQL transformations for complex business logic.
• Implement data quality testing and documentation.
• Optimize query performance and data pipeline efficiency.
• Establish data modeling standards and best practices.
• Develop reusable analytics components and design patterns.
• Collaborate with data engineers on data ingestion and architecture.

Co-ordination Responsibilities

• Facilitate Agile ceremonies (daily stand-ups, sprint planning).
• Gather business requirements from stakeholders across departments.
• Translate business needs into technical requirements for the data team.
• Document user stories and acceptance criteria.
• Prioritize backlog items based on business value and technical dependencies.
• Expert proficiency in SQL and database management systems.
• Expert proficiency in writing requirements and testing technology systems.
• Experience in environment management, deployment management, and testing.
• Familiar with data warehousing, ETL processes, and data pipelines.
• Strong analytical skills and complex problem-solving capabilities.
• Bachelor’s degree in Information Technology, Business, or a related field, or equivalent industry experience.
• At least 4 years of direct experience in a software development-related role.

Equal Employment Opportunity

Avison Young practices equal opportunity employment in all services locations around the world. We are committed to building and maintaining a workforce diverse in experience, skills and knowledge with uniformity in service excellence, commitment and integrity. The firm maintains a strict policy to ensure employment opportunities are equal and do not discriminate based on race, color, religion, creed, age, sex, gender, gender identity or expression, sexual orientation, national origin, citizenship, disability, marital and civil partnership/union status, protected veteran or military service status, or any other elements protected by law. Avison Young welcomes and encourages applications from people with disabilities. Accommodations are available upon request for candidates during the recruitment process. For those requiring assistance, information relating to the need for accommodation and accommodation measures will be addressed confidentially. Avison Young is committed to employing the best talent with the most fair and equitable recruitment practices. Apply with us TODAY!