Data Engineer

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

WHAT WILL YOU DO?

• Design, develop, maintain, optimize and document the corporate Azure Data Factory pipelines following the corporate development framework.
• Design and implement data models and define both logical and physical models.
• Develop, maintain and optimize data pipeline architecture.
• Execute CI/CD protocols using Azure DevOps to run deployment pipelines.
• Design, develop, and maintain various DataMarts.
• Ensure full up-to-date documentation is maintained.
• Ensure all information assets are fully tested, documented and reflect accurate data for timely and optimized reporting of corporate information.
• Foster strong collaborative relationships with IT/IS teams, data science professionals, BI development team, and various business units to identify data quality issues and develop solutions.
• Responsible for the administration, maintenance, and support of data warehouse environment, tools, and jobs.
• Ensure critical process contingency plans are in place for any key processes required to ensure data availability.
• Monitor data warehouse work and provide subject matter expertise.
• Analyze and optimize various data warehouse objects.
• Ensure strict adherence to all applicable privacy regulations.
• Any other related responsibilities not detailed herein but that could be reasonably expected.

WHAT WILL YOU NEED? 

• Bachelor’s degree in computer software science or a related discipline.
• 3+ years of experience in Azure SQL MI, designing, developing, and scripting database objects.
• Extensive experience with CI/CD using Azure DevOps.
• Extensive experience in relational and multi-dimensional data modeling, including multiple source systems from databases and flat files, OLAP, ROLAP.
• Expert experience in data pipeline and data mart development using Azure Data Factory (ADF).
• Proficiency in using Python for data manipulation, analysis, and automation tasks is essential.
• Extensive experience in development and administration with Azure SQL Database.
• Excellent communication skills, both written and verbal.
• Experience in project management methodologies.
• Works independently as well as in a team-oriented environment.
• Strong analytical skills to solve and model complex business requirements.
• Places emphasis on client satisfaction and clearly communicate solutions to both technical and non-technical team members and other staff.
• Demonstrated ability for creativity and innovative problem solving.
• Able to multi-task in a dynamic environment and think clearly and calmly under pressure.
• Ability to work in a fast-paced, dynamic environment that requires flexibility and balancing of competing priorities.
• Ability to deal with situations, people, and problems ethically, with honesty and integrity.

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. 

#ALAM123

#LI-HC1