Data Engineer

Avenue Living • Calgary, AB

30d

About The Position

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 $7.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.

Requirements

• 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).
• 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.

Nice To Haves

• Experience with Docker, Linux, and production deployments is an asset.

Responsibilities

• 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.

Benefits

• 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 This Job Offers

• Job Type: Full-time
• Career Level: Mid Level