Data Engineer

Avenue Living

Avenue Living Asset Management has a dedicated focus on sourcing, analyzing, and strategizing long-term investments, establishing itself as one of Canada's leading alternative asset managers. Their growth is driven by a unique approach and the strength of their diverse and inclusive team. Operating with integrity and an entrepreneurial mindset, Avenue Living's experts actively manage assets across various sectors in North America.

In this role you can expect to have the responsibilities:

• Design and optimize Azure Data Factory pipelines within corporate framework
• Develop and maintain data models and define logical and physical data structures
• Optimize data pipeline architecture and document processes
• Execute CI/CD protocols using Azure DevOps
• Maintain DataMarts and ensure accurate and timely data reporting
• Collaborate with IT, IS teams, and business units for data quality enhancement
• Manage administration and support of data warehouse environment
• Ensure data privacy regulations compliance and maintain contingency plans
• Analyze and optimize data warehouse components

This role comes with the following benefits:

• Competitive compensation with benefits, GRSP matching, and bonus program
• Employee referral program
• Employee-centric culture with volunteerism support and rent discounts
• Maternity leave top-up and recognition programs
• Safe and inclusive work environment

This role requires you to have:

• Bachelor’s degree in computer software science or related field
• 3+ years in Azure SQL MI and database object development
• Expertise in CI/CD with Azure DevOps
• Proficiency in relational and multi-dimensional data modeling
• Expertise with Azure Data Factory
• Proficiency in Python for data tasks
• Strong communication skills
• Project management experience
• Analytical and problem-solving skills

You would benefit from having:

• Ability to handle multiple tasks in a dynamic environment
• Creativity and innovative problem solving
• Client satisfaction and effective communication with diverse teams

Avenue Living is committed to diversity and inclusion, providing a discrimination-free workplace. The company values unique perspectives and backgrounds, ensuring a respectful environment. Accommodation is available for applicants requiring assistance in the recruitment process.