Job opportunity
Data Analyst, Analytics & Reporting
Gestion Zagora
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 [email protected] and tell us what would help. We will work it out with you, and asking never affects how your application is assessed.
#J-18808-Ljbffr
Apply on source site 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 [email protected] and tell us what would help. We will work it out with you, and asking never affects how your application is assessed.
#J-18808-Ljbffr