Posted last month
Business Analyst & Budgeting Coordinator
@ Zen Residential Ltd.
Calgary, Alberta
SIGNALS
Overview
Zen Residential Ltd. is hiring a full-time Business Analyst and Budgeting Coordinator to own its KPI and service-level reporting, run its SQL data warehouse in Azure, and coordinate annual operating budgets and monthly owner reports for about 6,500 managed homes. The work covers weekly exception-based scorecards, nightly data loads from Yardi Voyager and other systems, and use of AI tools across reporting. The posting states the role reports to the CEO's direct backing and includes a practical data exercise in hiring.
Responsibilities:
- Set up KPI and SLA reporting structure and metric dictionary
- Build weekly company and department scorecards and ranked red-item lists
- Set up and run SQL data warehouse in Azure with nightly loads
- Build and coordinate annual operating budgets for managed properties
- Produce monthly budget-vs-actual reporting and owner reports
Requirements summary:
- Hands-on SQL experience
- Experience building reports or dashboards leaders acted on
- Accounting or financial knowledge for budgeting and variance analysis
- Daily use of AI tools
- Willingness to challenge incorrect numbers with senior leaders
Tools & skills
Source and dates
Source type not verified · apify-linkedin
- Employer posting date
- 2026-10-13
- First seen by our source
- 2026-11-14
- Source record updated
- 2026-11-14
These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.
Job details
| Seniority | Mid level |
| Department | Business operations |
| Hours per week | 40 (estimated) |
| Travel | air: none · ground: none |
| Work setting | Office |
| Position | Mostly sitting |
| Physical demands | physical low · computer high |
Summary and details written by AI from the posting; the employer’s posting is the authority.
Zen Residential Ltd.
| Field | Value |
|---|---|
| Open jobs on Jobsy | 4 |
Job description
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
– weekly department scorecards;
– a ranked list of red items, each with an owner.
Must have
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:
– 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.
- 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.
- 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.
- 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 simple 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.
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.
- 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.
- 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.
- 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.
Journal
Only you can see this. Kept on this device, and in your account when you sign in.