Company Overview
Westcore is a fully-integrated commercial real estate investment company with institutional scale and capabilities that operates with the speed and adaptability of opportunistic entrepreneurs. Westcore has a dynamic track record of real estate investing going back to its founding in 2000. We focus on well-located industrial properties in the United States. We are a vertically integrated company with expertise in all facets of real estate investment management: acquisitions, finance, asset management, leasing, construction, and building operations.
To better support our IT Department with the anticipated doubling of our portfolio over the next few years, Westcore is seeking a technically fluent, AI-forward data engineer and solutions architect to build and own the next-generation data and AI platform that powers how our organization accesses, analyzes, and acts on commercial real estate data. This role is the builder behind Westcore's "talk to your data" initiative.
Position Summary
You will architect and implement Microsoft Fabric/OneLake as our centralized data platform, build governed ingestion pipelines from Yardi, SharePoint, CoStar, GreenStreet, Argus, and other CRE systems, and develop AI agents and natural language interfaces that enable business users to query the portfolio without writing a single line of code or opening a dashboard. You will work directly with IT, FP&A, and other stakeholders to define data requirements and ensure the platform delivers reliable, governed, AI-ready data.
Core Roles & Responsibilities
- Architect and implement Microsoft Fabric/OneLake as Westcore's centralized, cloud-native data platform.
- Build governed ingestion pipelines from Yardi and Data Freedom, 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
PRIMARY DUTIES: (The list below is not comprehensive, and priorities will change on a day-to-day basis)
Data Infrastructure & Integration (35–45%)
- 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 a single point of failure.
AI Agent Development & Automation (35–45%)
- 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.
Platform Security & Governance (Ongoing)
- 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