BI Analyst & Report Developer

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 $6 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 BI Analyst & Report Developer is responsible for implementing data analytics solutions, including designing and developing dashboard, reports and other BI products using the corporate Qlik Sense solution. The incumbent will be experienced in the areas of data visualization techniques, data modelling, advanced statistical analysis techniques and business requirements gathering.

WHAT WILL YOU DO?

• Gather and analyze business requirements for analytical and reporting purposes.
• Translate business requirements and develop end-user business-oriented dashboards, self-service analytics and reports.
• Develop project specific Key Performance Indicators and develop dashboards and reports to monitor performance.
• Develop complex statistical analytical and predictive models to enhance business insights into available data.
• Analyze, interpret and evaluate outcome data and write analytical reports.
• Create and document business/technical specifications and validate the application results.
• Build operational, tactical and strategic dashboards, reports and other analytical solutions to help business users gain better insights and improve their decisions and operational efficiencies.
• Provide production support, including working with users to identify issues and to ensure user satisfaction. 
• Act as the subject matter expert in best practice data visualization methods.
• Ensure full up-to-date documentation is maintained.
• Ensure all analytics solutions are fully tested, documented and reflect accurate data for timely and optimized reporting of corporate information.
• Create close working relationship with data engineering team and various business units to identify business problems, gather requirements and develop analytics solutions.
• Adhere 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 designing, developing and deploying complex BI solutions.
• Expert experience in querying databases/data warehouses/data lakes using SQL.
• Experience designing and developing efficient and effective dashboard and reports using data visualization best practices.
• Experience in QlikView or Qlik Sense UI design experience and advanced expressions (Set Analysis) is an asset.
• Experience in project management methodologies.
• Excellent communication and interpersonal skills.
• Excellent problem solving and analytical skills.
• Works independently as well as in a team-oriented environment.
• Places emphasis on client satisfaction and clearly communicate solutions to both technical and non-technical team members and other staffs.
• 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, a generous awards and recognition program, discounted monthly rent in Avenue Living Communities’ properties, and employee and savings program savings 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