AI & Data Solutions Architect

Overview

We're looking for a highly capable data engineering and architecture professional with a forward-looking mindset toward artificial intelligence. This individual will be responsible for designing and owning a modern data and AI ecosystem that supports how our company retrieves, interprets, and leverages commercial property data. This position will be the driving force behind our conversational data initiative - enabling users to interact with data through natural language.

In this role, you will establish and manage a centralized data environment built on Microsoft Fabric/OneLake, construct controlled ingestion frameworks from systems such as Yardi, SharePoint, CoStar, GreenStreet, Argus, and others, and develop intelligent agents and interfaces that allow non-technical users to explore portfolio data without relying on dashboards or coding. Close collaboration with IT, FP&A, and additional cross-functional partners will be required to define data needs and deliver a dependable, governed, AI-enabled data foundation.

The successful candidate brings a hands-on builder mentality, strong proficiency in Python and SQL, familiarity with vector-based data approaches, and background working with enterprise-scale cloud data ecosystems. Experience in commercial real estate is helpful but not essential-what's critical is the ability to quickly understand business domains and translate them into scalable data solutions.

Key Responsibilities

• Design and deploy a centralized, cloud-based data platform using Microsoft Fabric/OneLake.
• Develop structured, governed pipelines to ingest data from platforms such as Yardi, DataFreedom, SharePoint, Argus, CoStar, GreenStreet, Measurabl, and related systems.
• Create and implement conversational AI solutions and smart agents leveraging Microsoft Copilot and Azure AI technologies within a secure Microsoft 365 environment.
• Enforce data integrity through validation rules, schema controls, and quality monitoring at ingestion points.
• Act as the core data engineering partner for analytics teams, ensuring a strong and reliable data layer for BI consumption.
• Advocate for responsible adoption of AI and emerging tools within secure, enterprise-approved environments.
• Manage permissions, governance standards, and auditability across the full data ecosystem.
• Enable business users through training on AI-driven tools and natural language data access.

Core Areas of Work

Data Platform & Integration (Approx. 35-45%)

• Build and manage the centralized Fabric/OneLake platform, including components such as lakehouse structures, Delta tables, Dataflow Gen2 processes, and DirectLake models.
• Create controlled ingestion frameworks from multiple internal and third-party data systems, including ERP, document repositories, and external data providers.
• Ensure robust data validation, rule enforcement, and quality checks prior to promotion into authoritative datasets.
• Develop standardized data models that unify disparate sources, anchored by a consistent property master reference.
• Maintain governance structures, including documentation, lineage tracking, and change control procedures.
• Transition existing BI models from on-prem infrastructure to cloud-native solutions, eliminating dependency risks.

AI Enablement & Automation (Approx. 35-45%)

• Develop and deploy AI-enabled tools and conversational interfaces using Azure AI and Copilot technologies, ensuring all activity remains within secure tenant boundaries.
• Build and sustain conversational AI assistants integrated with collaboration tools such as Teams and Outlook, supported by vector-based search over structured and unstructured datasets.
• Design and implement integrations (APIs and connectors) that allow AI systems to access both structured and document-based data.
• A

  All qualified applicants will receive consideration for employment without regard to race, color, national origin, age, ancestry, religion, sex, sexual orientation, gender identity, gender expression, marital status, disability, medical condition, genetic information, pregnancy, or military or veteran status. We consider all qualified applicants, including those with criminal histories, in a manner consistent with state and local laws, including the California Fair Chance Act, City of Los Angeles' Fair Chance Initiative for Hiring Ordinance, and Los Angeles County Fair Chance Ordinance.