Data Solutions Architect

About Allied  

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.  

Purpose

Support and evolve Allied’s enterprise data environment to enable secure, scalable, and insight-driven business operations. As a Data Solutions Architect, Technology, you will provide technical leadership across Allied’s data platform, including enterprise data architecture, integration, data modelling, governance, reporting modernization, and AI enablement. You will help ensure Allied’s data solutions are reliable, well-governed, and aligned with business needs across the organization.

Reporting to the Senior Manager, Data Strategy and Transformation, you will collaborate with Technology, Finance, Leasing, Portfolio Operations, Property Management, and other business stakeholders to evolve Allied’s Microsoft-centric data ecosystem, including Microsoft Fabric, Power BI, Power Platform, Yardi integrations, and related tools. Through strong technical ownership, stakeholder engagement, documentation, and continuous improvement, you will help scale Allied’s data foundation, support the transition to modern reporting and analytics, and enable informed decision-making across the business.

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.

Qualifications

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 Microsoft power user: You are fluent in the Microsoft data stack (Fabric, Power BI, Power Platform, Azure data services) and can work with complementary tools when needed.


• AI-savvy: You understand how AI depends on reliable data and can connect data platforms with AI tools like Microsoft Copilot Studio and Data Agents.


• A change agent: You can introduce new ways of working (like transitioning reports from legacy systems to Power BI) in a way that people can accept and adopt.


• A communicator and collaborator: You speak both tech and business, translating needs into architecture and outcomes into value.


• A problem-solver and innovator: You come up with new ideas and have the technical depth to tackle the most complex challenges.

Must Have

• 5+ years designing, implementing, and evolving enterprise data platforms (data lakes, warehouses, large-scale pipelines) and preparing data for advanced analytics and AI workloads.


• Deep expertise with the Microsoft data and AI stack (Fabric, Power Platform, Power BI, Azure data/compute services) with ability to configure AI compute and optimize storage.


• Solid grasp of machine-learning fundamentals, large-language models (LLMs), and generative AI concepts; able to adapt to meet the requirements of Allied's use cases.


• Experience with data governance frameworks, data modelling, metadata management, and working with governance committees or data stewards.


• Advanced SQL and at least one programming language (e.g., Python, Scala).


• Proven track record integrating ERP data, ideally Yardi or similar real-estate/financial systems.


• Experience transitioning reporting from legacy systems to modern BI platforms, including managing the change with end users.


• Proven ability to lead data projects through full lifecycle within a formal PMO/SDLC framework, delivering under Agile, Waterfall, and Hybrid methodologies.


• Strong communication skills to translate business needs into technical and AI-driven solutions.


• Ability to work independently, come up with creative solutions, and handle complex technical challenges with minimal direction.

Would Be an Asset

• Experience ingesting and modelling IoT or BAS data (HVAC, access control, sensors).


• Hands-on experience with Microsoft Copilot Studio, AI Agents, or similar AI orchestration tools.


• Experience with Amazon QuickSight or other cloud-based BI/analytics platforms.


• Working knowledge of MLOps practices (versioning, CI/CD, feature stores, model monitoring).


• Real-estate or property-management industry experience.


• Experience with change management or user adoption strategies for new technology solutions.


• Professional certifications (e.g., Microsoft Certified: Azure Data Engineer, TOGAF, DAMA DMBOK).

$105,000 - $130,000 a year

Allied determines individual compensation by work location and other factors, including relevant experience, education and internal equity.  

Note: The listed salary range does not reflect total compensation and rewards. We encourage all qualified candidates to apply.  

This role is a current vacancy on the Allied team.  

Total Rewards* and the Employee Experience  

At Allied, total rewards are designed with the same perspective that shapes our operations. They are intended to support sustained contribution, creativity and a genuine sense of ownership in the work we do.  

In practice, this includes:  

• 
  

  Shared financial success and an ownership mindset  
  Eligible employees participate in performance-based bonus programs and a retirement savings program, with the option to invest in traditional funds or Allied units. This approach aligns individual effort with Allied’s long-term performance and reinforces a sense of ownership at every level of the organization.  

• 
  

  Intentional presence and time off
  In addition to vacation, employees receive six personal days and half-days before statutory holidays. Allied supports flexibility while maintaining a strong, in-person culture. This reflects how we collaborate most effectively and how we operate as a business.  

• 
  

  Health, wellbeing and support  
  Comprehensive, company-paid health benefits include vision and dental coverage, along with a healthcare spending account. An employee assistance program is available to provide confidential support when it is needed.  

• 
  

  Growth through leadership and exposure  
  Allied believes in leadership at every level. Employees are encouraged to contribute beyond the boundaries of their role, collaborate across disciplines and develop a broad understanding of the business. For those drawn to real estate, this includes uncommon exposure to how buildings, organizations and cities evolve through hands-on experience and shared responsibility.  

• 
  

  Professional development grounded in practice  
  Learning at Allied is both formal and experiential. Ongoing professional development and a mentorship program support growth through structured learning and day-to-day engagement with experienced colleagues across the organization.  

• 
  

  Purpose and connection beyond work
  Each year, employees are provided with a paid volunteer day to contribute time and effort to a cause that is personally meaningful to them, reflecting our belief that contribution extends beyond the workplace.  

If you are motivated by the role real estate plays in shaping cities and culture, and want your work to contribute to that effort, we encourage you to apply.  

More insight into life at Allied, including our ESG and EDI initiatives, can be found in our  annual ESG report .  

*Temporary or contract roles may not qualify for all the benefits listed, and some roles may follow a modified total rewards structure. We will confirm what benefits you qualify for during the recruitment process.  

Additional Information  

We value human connection and experience. While Allied uses technology, including AI-enabled tools, to support administrative efficiency, all screening, assessment and hiring decisions are made by people.  

We are committed to hiring the most qualified candidates with a dedication towards supporting diversity, equity and inclusion across our organization. All qualified applicants will receive consideration for employment without regard to gender, ethnicity, origin, sexual orientation, disability and socioeconomic background. Diverse perspectives strengthen our organization and help us deliver better outcomes for our tenants, partners and communities. All qualified candidates are encouraged to apply.  

We strive to provide an accessible recruitment experience and welcome reasonable accommodation requests at any stage of the recruitment process. Please reach out to  [email protected]if support is needed.  

We look forward to receiving your application.