Job Summary:
Westcore is a fully-integrated commercial real estate investment company with a focus on industrial properties in the United States. They are seeking an AI & Data Solutions Architect to build and own a next-generation data and AI platform that enhances the organization’s ability to access and analyze commercial real estate data. The role involves architecting data solutions, developing AI agents, and ensuring data governance within the organization.
Responsibilities:
• Architect and implement Microsoft Fabric/OneLake as Westcore's centralized, cloud-native data platform.
• Build governed ingestion pipelines from Yardi and DataFreedom, SharePoint, Argus, CoStar, GreenStreet, Measurabl, and other CRE data sources.
• Design and deploy AI agents and natural language interfaces using the Microsoft Copilot and Azure AI stack governed within Westcore's Microsoft 365 tenant.
• Implement schema validation, business rule enforcement, and data quality monitoring at the ingestion layer.
• Serve as the platform engineering partner to analysts, define and maintain the data foundation that BI reporting consumes.
• Champion AI and emerging technology adoption within enterprise-governed, security-first boundaries.
• Maintain access controls, audit trails, and data governance standards across all platform components.
• Train end-users on AI tools and natural language interfaces.
• Architect and implement Microsoft Fabric/OneLake as Westcore's centralized, cloud-native data platform including Lakehouses, Delta tables, Dataflow Gen2 pipelines, and DirectLake semantic model configuration.
• Build governed ingestion pipelines from Yardi ERP (via DataFreedom SQL abstraction layer and/or MCP), SharePoint (Excel templates, PDFs), Argus, CoStar, GreenStreet, Measurabl, and other CRE data sources.
• Implement schema validation, business rule enforcement, and data quality monitoring at the ingestion layer, ensuring that only validated, approved data is promoted to the authoritative OneLake layer.
• Design data models that normalize and contextualize information across disparate systems, aligned with the DataFreedom property master as the referential integrity anchor.
• Establish and maintain data governance standards, documentation, data lineage tracking, and change management processes.
• Migrate Power BI semantic model from on-premises gateway (WDSSRV) to cloud-native Fabric refresh eliminating single point of failure.
• Design and deploy AI agents and natural language interfaces using the Microsoft Copilot and Azure OpenAI stack (Azure AI Search, Azure OpenAI Service, Copilot Studio, Power Automate), governed within Westcore's Microsoft 365 tenant with no external data transmission.
• Build and maintain the Ask AI agents (Teams + Outlook integration), connecting it to the Azure AI Search vector index over OneLake Delta tables and SharePoint metadata-tagged documents.
• Build API integrations and custom connectors enabling AI systems to query structured (OneLake) and unstructured (SharePoint metadata-tagged documents) data sources.
• Develop automated workflows for recurring report distribution, data collection, validation notifications, and business processes using Power Automate and Python.
• Evaluate, pilot, and operationalize emerging AI capabilities within the Microsoft 365 and Azure ecosystem, maintaining an enterprise-governed, security-first approach.
• Implement and maintain access controls for OneLake workspaces and Azure AI Search indexes, inheriting Entra ID security groups and Conditional Access policies.
• Ensure all AI-generated outputs are scoped by user authorization, security trimming enforced at the query layer, not just the UI.
• Maintain audit trail integrity via Delta table versioning in OneLake.
• Work with IT leadership to ensure all data pipelines, AI agents, and integrations comply with Westcore's data governance, privacy, and security standards.
• Serve as the data platform partner to the Senior BI Analyst, define upstream data requirements, validate semantic model inputs, and resolve data quality issues at the source.
• Maintain and enhance existing Power BI dashboards as needed during platform transition.
• Support Copilot for Power BI enablement on the Fabric-hosted semantic model.
• Train end-users on AI tools, natural language interfaces, and new platform capabilities.
Qualifications:
Required:
• Bachelor's degree in Computer Science, Information Systems, Data Engineering, Data Analytics, or related field.
• 3–6 years of professional experience in data engineering, analytics engineering, or a BI/data platform role with a strong engineering component.
• Demonstrated experience building production data pipelines on cloud-native platforms (Microsoft Fabric, Azure Data Lake, Databricks, or equivalent).
• Hands-on experience building AI-powered applications or agents using LLMs, beyond basic prompting, including RAG architecture, vector search, API integration, or Copilot Studio/custom agent development.
• Strong understanding of data architecture, data modeling, and ETL/ELT processes.
• Experience building API integrations and automated workflows.
• Architect and implement Microsoft Fabric/OneLake as Westcore's centralized, cloud-native data platform.
• Build governed ingestion pipelines from Yardi and DataFreedom, SharePoint, Argus, CoStar, GreenStreet, Measurabl, and other CRE data sources.
• Implement schema validation, business rule enforcement, and data quality monitoring at the ingestion layer.
• Design data models that normalize and contextualize information across disparate systems.
• Establish and maintain data governance standards, documentation, data lineage tracking, and change management processes.
• Migrate Power BI semantic model from on-premises gateway to cloud-native Fabric refresh.
• Design and deploy AI agents and natural language interfaces using the Microsoft Copilot and Azure OpenAI stack.
• Build and maintain the Ask AI agents (Teams + Outlook integration).
• Build API integrations and custom connectors enabling AI systems to query structured and unstructured data sources.
• Develop automated workflows for recurring report distribution, data collection, validation notifications, and business processes using Power Automate and Python.
• Evaluate, pilot, and operationalize emerging AI capabilities within the Microsoft 365 and Azure ecosystem.
• Implement and maintain access controls for OneLake workspaces and Azure AI Search indexes.
• Ensure all AI-generated outputs are scoped by user authorization.
• Maintain audit trail integrity via Delta table versioning in OneLake.
• Work with IT leadership to ensure all data pipelines, AI agents, and integrations comply with Westcore's data governance, privacy, and security standards.
• Serve as the data platform partner to the Senior BI Analyst, define upstream data requirements, validate semantic model inputs, and resolve data quality issues at the source.
• Maintain and enhance existing Power BI dashboards as needed during platform transition.
• Support Copilot for Power BI enablement on the Fabric-hosted semantic model.
• Train end-users on AI tools, natural language interfaces, and new platform capabilities.
Preferred:
• Commercial real estate, real estate finance, or related industry experience preferred but not required.
• Experience with SharePoint Premium (Syntex / Content AI): document classification, metadata extraction, content processing.
• Familiarity with CRE data systems: Yardi, DataFreedom, CoStar, Argus, GreenStreet, or Measurabl.
• Understanding of enterprise data governance frameworks, data lineage, and stewardship models.
• Experience with Azure Entra ID, security group-based access control, and data security trimming in AI search contexts.
• Microsoft Fabric DP-600 certification (or willingness to obtain).
Company:
Founded in 2000, Westcore is a fully integrated industrial real estate investment company with institutional scale and capabilities that operates with speed, agility and adaptability. Founded in 2000, the company is headquartered in San Diego, USA, with a team of 51-200 employees. The company is currently Growth Stage.