Data Analyst

Job summary

The role focuses on validating data accuracy, supporting ERP migration, and producing automated KPI reports for leadership. The analyst will also perform deep-dive analytics to answer strategic business questions and help structure scalable data models.

Job details

Data Analyst, Analytics & Reporting Gestion Zagora | Montréal, QC | On-site | Full-time The opportunity Gestion Zagora manages more than 8,000 residential units across Canada and the US. The Data Strategy & Innovation team partners with Finance, Asset Management, Operations, Accounting, and Leasing to replace manual reporting with automated, verified numbers. You report directly to the Head of Data Strategy & Innovation and you'll be the person leadership comes to when they need to know what the data actually says. What you'll actually do Data validation. Verify that what's in our warehouse matches reality. Rent rolls, unit counts, lease terms, collections, vacancy. You'll build reconciliation checks, chase down variances with the operating teams, and document what you find. This is a large share of the job and it is the foundation everything else rests on. ERP migration support. You'll validate migrated data set against set, investigate mismatches, and sign off on what's clean. This is the fastest way anyone has ever learned how a property management business works. Reporting. Help the production of recurring KPI reporting: weekly and monthly packages for leadership, bilingual French and English, built on SQL against BigQuery rather than copy-paste. Where a report is still manual, your job is to make it not be. Analytics. Answer real questions from senior leadership. Why is turnover up in one portfolio, what does our collections curve look like by region, which buildings are underperforming their market rent and by how much. You'll define the metric, pull the data, and present the answer. Data modelling input. Help translate operational questions into structures that scale, so the same question next quarter takes ten minutes instead of two days. What we're looking for Strong SQL. Joins, aggregations, window functions, and the habit of validating your own output before anyone else sees it Advanced Excel or Google Sheets. Pivot tables, lookups, and the judgment to know when a spreadsheet is the wrong tool Comfort with large, messy, inconsistent datasets and the patience to reconcile them line by line Clear written and spoken French and English. Our reports, stakeholders, and source data are all bilingual Ability to explain a number to leadership and defend how you got it Bonus: Python and pandas, BigQuery, Power BI, Apps Script, real estate or property management data, accounting or finance coursework, ERP exposure of any kind Background in finance, accounting, economics, engineering, or anything quantitative works. The right mindset You are bothered when two reports disagree, and you don't stop until you know which one is wrong Naturally curious. You dig into problems rather than waiting for direction Structured and independent. Small team, no micromanagement You want to grow toward senior analyst or analytics engineering, and you're happy to pick up Python and warehouse modelling along the way How you'll grow We have a defined career ladder for this team. This role is the first rung on the analytics track, with a path toward owning a reporting domain and eventually the business-facing side of the department. We run bi-weekly internal technical sessions, and our head of department is a former quantitative developer who trains actively.

What you’ll do

The role focuses on validating data accuracy, supporting ERP migration, and producing automated KPI reports for leadership. The analyst will also perform deep-dive analytics to answer strategic business questions and help structure scalable data models.

Requirements

Candidates must have strong SQL and advanced spreadsheet skills, along with the ability to communicate fluently in both French and English. A quantitative background in finance, accounting, economics, or engineering is preferred.

Listed skills

• Power BI · Preferred
• SQL · Preferred
• Data Validation · Preferred
• Financial analysis · Preferred
• Python · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• SQL
• Advanced Excel
• Google Sheets
• Data Validation
• Data Modeling
• Bilingual French and English
• BigQuery
• Python
• Pandas
• Power BI
• Apps Script
• Financial Analysis
• ERP Migration
• KPI Reporting
• Data Reconciliation

Job areas

• Data & Analytics
• Finance & Accounting
• Technology
• Sales
• Engineering