Data Solutions Architect

Allied • Toronto, ON

8d • CA$105,000 - CA$130,000 • Hybrid

About The Position

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.

Requirements

• 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.

Nice To Haves

• 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).

Responsibilities

• 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.
• 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.
• 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.
• 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.

Benefits

• performance-based bonus programs
• retirement savings program
• vacation
• six personal days
• half-days before statutory holidays
• comprehensive, company-paid health benefits
• vision and dental coverage
• healthcare spending account
• employee assistance program
• paid volunteer day

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed