About ZEN Residential

ZEN Residential manages about 6,500 homes across Edmonton, Calgary, Saskatoon and Regina. We’re moving from a site-based model to a centralized, technology-enabled one. Clear service standards, good data and AI do the repetitive work, so our people can focus on residents and property owners.

Why this role exists

We have more data than our managers can use. Across about 80 buildings, our reports show everything and highlight nothing.

We need one person who owns our numbers: sets up how they’re measured, makes sure they’re right and on time, and turns them into a short list of what needs action and who owns it. The same person will run the annual budget cycle for the properties we manage.

What you’ll do

Build and run our reporting system

- Set up the KPI and service-level (SLA) reporting structure for the whole company: what we measure, how each number is calculated, its target, and when it turns yellow or red.
- Keep a single metric dictionary so every KPI is defined once and used the same way everywhere.
- Build exception-based reporting:

– a weekly company scorecard for the leadership team; – weekly department scorecards;

– a ranked list of red items, each with an owner.

- Write a one-page weekly brief: the top issues, what changed, and who owns each one.
- Track red items through to resolution and escalate the ones that stay red.

Set up and run the data
- Work with our IT provider to set up and run our SQL data warehouse in Azure.

Yardi

Voyager data loads nightly, and our leasing CRM, maintenance and accounting systems feed in by API.

- Write and maintain the SQL that turns raw data into reliable reporting tables.
- Monitor the nightly loads, catch failures early, and get them fixed.
- Choose and build the right tools for each job, and be creative about it. That could be Power BI dashboards, Claude for analysis and the written weekly brief, and Power Automate or n8n to route red items to their owners automatically.
- Dig into occupancy, arrears, unit turnover,



leasing and revenue per door, down to the individual unit and tenant.

Budgets and owner reporting

- Build and coordinate annual operating budgets for the properties we manage, working with property managers and area managers and using AI tools to speed up the work.
- Produce monthly budget-vs-actual reporting and explain the variances.
- Prepare monthly owner reports and commentary once Accounting closes the books.

AI and automation
- Make sure our AI tools (leasing, maintenance and reporting) connect to the same data and use the same definitions, so they don’t create conflicting records.
- Keep a easy register of the AI tools we use: who owns each one, what data it uses, and what it’s for.
- Automate your own reporting so it runs with as little manual work as possible.

What you bring

Must have

- Hands-on SQL. You write your own queries and can design tables that others report from.
- Experience building reports or dashboards that leaders acted on.
- Accounting or financial knowledge: you can build a budget and explain a variance.
- You use AI tools in your daily work, and you can show what they changed.
- You bring recommendations, not just data, and you’ll tell a senior leader when a number is wrong.

Nice to have

- Property management or real estate experience.
- Yardi Voyager, Power BI, Azure, Power Automate, n8n, Claude or similar tools.
- Programming experience (Python, JavaScript or similar).
- An accounting designation or degree.

Why join ZEN

- You’ll build the reporting system from the ground up, with the CEO’s direct backing.
- You’ll get real ownership: your work decides what the leadership team acts on each week.
- You’ll get to use AI and automation for real, not just talk about them.

How we hire
- A 30-minute intro video call.
- A practical data exercise: we’ll give you a sample KPI data set and ask for a one-page brief.
- Structured interviews.
- Reference calls with former managers, which you arrange.

You’re welcome to use AI tools in the exercise; we’ll ask how you used them.

📌 Business Analyst & Budgeting Coordinator (Calgary)
🏢 Zen Residential
📍 Calgary