Data Solutions Architect

Allied is a leading owner-operator of distinctive urban workspace in Canada's major cities. Our work is grounded in a clear purpose: to provide knowledge-based organizations with distinctive urban environments that support creativity, connectivity and human wellness.

Our vision is more expansive. We seek to make a continuous contribution to cities and culture that elevates and inspires the humanity in all of us. This vision informs how we operate, how we design and how we lead.

Real estate, for us, is not a passive investment. It is a profoundly human endeavour, one that must promote wellness, sustainability, diversity and creativity today and for generations to come.

Allied is also a place to build a career of consequence. If you are looking for work that is thoughtful, tangible and enduring-work that contributes meaningfully to cities and the people who inhabit them you will find purpose here.

For more information on Allied's approach to city-building, visit our Insights page.

Responsibilities

Area of Work 1: Enterprise Data Architecture and Platform Evolution

• Continue to evolve and scale Allied's enterprise data platform built on Microsoft Fabric, Power Platform, and Power BI, ensuring it remains secure, performant, and aligned with business needs.
• Maintain and advance the target-state architecture, standards, and technology stack; update roadmaps and reference designs as the platform matures.
• Optimize existing data pipelines and ingestion processes from Yardi, Excel, and other operational sources into Fabric.
• Evaluate and implement modern data tools that fit our Microsoft-centric ecosystem while remaining open to complementary solutions (e.g., AWS services, Amazon QuickSight) when they offer faster deployment or better fit.
• Define and enforce standards for documentation, testing, monitoring, and ongoing platform evolution.

Area of Work 2: Data Integration and Engineering

• Own and improve data integration across Yardi ERP, Microsoft services (Power Platform, Fabric, SharePoint, Power BI), smart building systems (BAS, access control, IoT), and third-party applications.
• Build on the streamlined Yardi data extraction and SQL query processes already in place; continue to improve efficiency and reliability.
• Develop and maintain Power Apps for data ingestion and Power BI dashboards for data delivery, building on existing solutions.
• Lead the transition of Yardi reports into Power BI, working closely with end users to manage change and ensure adoption. This requires someone who can introduce new reporting approaches in a way that teams can absorb.
• Work with stakeholders to prioritize new ingestion pipelines, data products, and real-time analytics capabilities.
• Champion data quality, security, lineage, cataloging, and observability; optimize performance and cost of cloud services.

Area of Work 3: Data Governance and Data Modelling

• Work closely with the Data Governance Committee and Data Stewards to advance Allied's Data Governance framework, including data ownership, access controls, sensitivity classification, and retention requirements.
• Continue building and refining the enterprise Data Model so the organization has a clear understanding of what data exists, who owns it, and how it should be managed.
• Champion data quality and ensure governance practices are practical, sustainable, and adopted across the business.
• Support data retention and lifecycle management initiatives.

Area of Work 4: AI Enablement and Innovation

• Connect Allied's data solutions with AI investments, ensuring all AI solutions are built on top of reliable, governed data.
• Advance the integration of Data Agents with Microsoft Copilot Studio Agents and other AI tools.
• Collaborate across departments (Finance, Leasing, Portfolio Operations, and beyond) to unlock data-driven insights and faster decision-making.
• Drive innovation by proposing new data products, real-time analytics, self-service BI experiences, and creative approaches to solving business problems.
• Test and evaluate emerging platforms and tools (e.g., Amazon QuickSight, new Fabric capabilities) for faster or more effective solution delivery.
• Other duties as assigned.

Who You Are

• A builder who can pick up and scale: You are comfortable inheriting an existing platform and making it better. You do not need to start from zero to be effective.
• An integration expert: You know how to wrangle complex source systems (ERP, IoT, APIs) into cohesive and accessible data ecosystems.
• A