Data Analyst, Analytics & Reporting

Gestion Zagora; Westmount; On-site; CAD 60,000 - 85,000; Full time

Benefits offered by this job

Bilingual workplace FR · EN

Job summary

Gestion Zagora is seeking a data professional to join the Data Strategy & Innovation team in Montreal. You will collaborate with Finance, Asset Management, Operations, Accounting and Leasing to replace manual reporting with automated, verified numbers, and you will report to the Head of Data Strategy & Innovation.

This is the first step on our analytics career ladder, with bi-weekly internal technical sessions and a path toward owning a reporting domain.

Qualifications

• Strong SQL skills with joins, aggregations, and window functions.
• Advanced Excel or Google Sheets.
• Ability to reconcile large, inconsistent data sets line by line.
• Bilingual in French and English for reports and data sources.
• Background in finance, accounting, economics, engineering or another quantitative field.

Responsibilities

• Validate warehouse data against reality: rent rolls, unit counts, lease terms, collections and vacancy.
• Build reconciliation checks and resolve variances with operating teams.
• Validate ERP migration data set and sign off on what is clean.
• Produce recurring weekly and monthly KPI reporting for leadership in French and English, in SQL on BigQuery.
• Answer leadership’s questions: define the metric, pull the data and present the answer.
• Help turn operational questions into data structures that scale.

Skills

SQL proficiency

Excel / Sheets

Education

Quantitative field

Tools

BigQuery

Job description

Gestion Zagora manages more than 8,000 residential units across Canada and the United States. The Data Strategy & Innovation team works with Finance, Asset Management, Operations, Accounting and Leasing to replace manual reporting with automated, verified numbers. You report to the Head of Data Strategy & Innovation and become the person leadership asks when they need to know what the data actually says.This is the first step on our analytics career ladder, with bi-weekly internal technical sessions and a path toward owning a reporting domain.

What you’ll do

• Validate warehouse data against reality: rent rolls, unit counts, lease terms, collections and vacancy
• Build reconciliation checks and resolve variances with the operating teams
• Validate the ERP migration data set by set and sign off on what is clean
• Produce recurring weekly and monthly KPI reporting for leadership in French and English, in SQL on BigQuery
• Answer leadership’s questions: define the metric, pull the data and present the answer
• Help turn operational questions into data structures that scale

What we’re looking for

• Strong SQL: joins, aggregations, window functions, and checking your own output
• Advanced Excel or Google Sheets
• Comfort reconciling large, inconsistent data sets line by line
• Clear written and spoken French and English: our reports, stakeholders and source data are bilingual
• A background in finance, accounting, economics, engineering or another quantitative field

We work together to create safe, comfortable and accessible homes, with attentive, responsive service for the people and communities we serve.

Team members 200+

Residential units 8,500+

Areas of expertise 5+

Bilingual workplace FR · EN

Need an accommodation? If a disability or another need makes any part of applying or interviewing harder, write to [e-mail] and tell us what would help. We will work it out with you, and asking never affects how your application is assessed.