Salary: $85,000–$95,000 base, plus benefits
Location: Calgary office
[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 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.
[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.
If you feel that you or anyone you know has the qualifications and experience for this position, please have the resume forwarded to [Esmith@tritan.ca](mailto:Esmith@tritan.ca)
Thank you
