Job Description

Avenue Living Asset Management is dedicated to sourcing, analyzing, and strategizing long-term investments. Our unique approach has led to rapid growth across North America now representing one of Canada’s largest alternative asset managers. Since 2006, we have acquired over $9.5 billion in assets under management across a variety of sectors throughout Canada and the USA. Our various funds include assets in multifamily residential, self-storage, commercial, as well as agricultural land.

The strength of our platform lies in working with the right people. Acting with integrity and employing an entrepreneurial mindset, our employees work together to create an exciting, dynamic workplace. By employing an active hands-on approach to asset management, our skilled and innovative team operates closely alongside our investors. We’re disciplined, we focus on value, and we’re informed experts. We pride ourselves on our diverse and inclusive workplace; we are a unique workplace with unique people.

The Data Engineer is responsible for designing, developing and maintaining the corporate Azure SQL and Azure Data factory data pipelines and database objects, ensuring optimized data integration and accuracy of all related data assets. The incumbent will be experienced in the areas of data warehousing, data modelling, data pipeline- and data mart development as well as data extraction methodologies.

WHAT WILL YOU DO?

• Design, build, and maintain scalable data pipelines using Microsoft Fabric (Data Factory, Synapse, Notebooks).
• Implement and manage Medallion Architecture (Bronze, Silver, Gold) within OneLake.
• Develop and optimize SQL queries and stored procedures for transformation and reporting.
• Build Python-based data workflows for automation and data processing.
• Monitor and troubleshoot data pipelines to ensure performance, reliability, and data integrity.
• Partner with BI, data science, and business teams to deliver trusted datasets (DataMarts, Facts, Dimensions).
• Support CI/CD deployments using Azure DevOps or Fabric deployment pipelines.
• Maintain clear, up-to-date documentation of data assets, pipelines, and architectural decisions.
• Ensure compliance with data privacy and protection regulations.
• Design and maintain scalable data models (logical and physical).
• Develop contingency and recovery processes for business-critical data systems.
• Continuously identify opportunities to improve and modernize the data platform.

WHAT WILL YOU NEED?

• Bachelor’s degree in Computer Science, Software Engineering, or a related field.
• 6+ years of hands-on experience in data engineering roles.
• Strong proficiency in Microsoft Fabric, including Data Factory, OneLake, Synapse, and Notebooks.
• Deep understanding of Lakehouse architecture and Medallion frameworks.
• Advanced SQL skills (optimization, stored procedures, data modeling).
• Strong Python skills for data transformation and automation.
• Experience with data warehousing and modeling across diverse data sources.
• Familiarity with CI/CD practices and deployment pipelines.
• Working knowledge of Agile methodologies (Scrum, Kanban).
• Experience with Docker, Linux, and production deployments is an asset.
• Strong communication skills, able to explain technical solutions to both technical and non-technical stakeholders.
• Innovative mindset, proactively seeks improvements and stays current with the evolving Fabric ecosystem.
• Strong team player, who is punctual, reliable, and thrives in a collaborative environment.
• Strong analytical and problem-solving skills with a focus on client satisfaction.

WHAT DO WE OFFER?

• We live and breathe our core values. We go the extra mile. We’re honest. We always have each other's back. We have tons of integrity. And we always own it and adapt, no matter the challenge.
• With the support to do things differently, grow personally and professionally, and bring your whole self to work, there's no limit to the impact you can make.
• We provide a competitive compensation package composed of a group benefits plan, GRSP matching, and a discretionary bonus program. In addition, Avenue Living also offers an Employee Referral Program that rewards active employees for successful referrals.
• An employee centric culture with paid time off for employer supported volunteerism, maternity leave top-up, a generous awards and recognition program, discounted monthly rent in Avenue Living properties, and employee savings program through industry partnerships.
• We are committed to a strong, safe work environment.

What makes us different makes us stronger. We want Avenue Living to be a great place to work for everyone; where people feel safe, included, inspired, trusted, and supported so they can be, and bring, their best. We're committed to creating a respectful and inclusive workplace where unique perspectives, experiences, backgrounds, cultures, and attributes are valued and utilized to help achieve better results. As an organization with operations across different geographies, we celebrate the fact that our workforce is made up of people with diverse demographics. We are committed to ensuring our workplace is fair, equitable, and free of discrimination and harassment. Should you require accommodation to participate fully in the recruitment process, please email peopleandculture@avenueliving.ca.

#LI-HC1

#ALAM123