Data Analyst

Gestion Zagora; Westmount; Presencial; CAD 70.000 - 110.000; Jornada completa

Descripción de la vacante

Gestion Zagora is seeking a data-minded analyst to join the Data Strategy & Innovation team across Canada and the US. You will validate data in our warehouse, reconcile rent rolls and lease terms, and support ERP migration by verifying migrated datasets.

You'll build KPI reports weekly and monthly in SQL against BigQuery, ensure bilingual French and English outputs, and help translate operational questions into scalable data structures.

Formación

• Strong SQL with validation of outputs before sharing
• Advanced Excel or Google Sheets with pivot tables and lookups
• Comfort with large, messy datasets and meticulous reconciliation
• Clear written and spoken French and English for bilingual reports
• Ability to explain numbers to leadership and defend methodology

Responsabilidades

• Data validation of warehouse contents and reconciliations
• ERP migration data validation and sign-off on clean datasets
• Produce weekly and monthly KPI reports in SQL against BigQuery
• Answer analytics questions from senior leadership and define metrics
• Contribute to scalable data models for future quarters

Conocimientos

SQL

Excel

Bilingual FR/EN

Data validation

Communication to leadership

Educación

Quantitative background

Herramientas

BigQuery

Power BI

Apps Script

Python

Descripción del empleo

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.