Apply on Employer Site

Westcore · 2 months ago

AI & Data Solutions Analyst

San Diego, CA, US

Full-time

Onsite

Entry, Mid Level

$100K/yr - $130K/yr

2+ years exp

Westcore is a fully-integrated commercial real estate investment company focused on industrial properties in the United States. They are seeking an AI & Data Solutions Analyst to architect and implement a data analytics platform, integrating AI capabilities to enhance decision-making and data accessibility.

Commercial Real EstateReal Estate

Growth Opportunities

H1B Sponsor Likely

Responsibilities

Design and maintain a centralized enterprise data platform (Microsoft Fabric/OneLake or equivalent) with scalable pipelines integrating key CRE systems such as Yardi, Argus, CoStar, and GreenStreet

Develop unified data models and implement governance, quality, and documentation standards to ensure data accuracy and consistency

Build and deploy AI-driven agents and automations using ChatGPT, Microsoft Copilot, and Power Automate; enable natural language data interaction and integrate AI with enterprise systems via APIs and connectors

Enhance Power BI dashboards and reporting to deliver actionable insights for asset management, leasing, and finance; partner with FP&A and operations to define KPIs and analytics frameworks

Promote data literacy and adoption by training users, advancing AI and BI tool utilization, and fostering a culture of data-driven decision-making

Architect and implement Microsoft Fabric/OneLake (or similar) as our centralized data platform

Build data pipelines and integrations from Yardi ERP (SQL Data warehouse), SharePoint (Excel/PDFs), Argus, CoStar, GreenStreet, Measurabl, and other CRE data sources

Design data models that normalize and contextualize information across disparate systems

Establish data governance, quality controls, and documentation standards

Design and deploy AI agents (using ChatGPT, Microsoft Copilot, or similar platforms) that can query, analyze, and report on data autonomously

Build API integrations and custom connectors to enable AI systems to access and interact with data sources

Develop natural language interfaces for data exploration ("talk to your data" functionality)

Create automated workflows for recurring reports, data collection, and business processes using Power Automate and other tools/scripts

Maintain and enhance existing Power BI dashboards for asset management, leasing, and financial reporting

Design new interactive visualizations and reports that deliver actionable insights to stakeholders

Partner with FP&A and operations teams to define KPIs, metrics, and analytical frameworks

Train end-users on new tools and foster data literacy across the organization

Qualification

Microsoft FabricPythonSQLPower BIAI agent developmentLow-code automationData architectureData analyticsCommercial Real EstateAPIsExcel

Required

Bachelor's degree in Data Analytics, Computer Science, Information Systems, Finance, or related field

2-5 years of professional experience in data analytics, business intelligence, or similar role

Strong technical acumen in Python and SQL

Experience with low-code automation platforms

Experience building AI agents, custom GPTs, or workflow automation using LLMs

Understanding of data architecture and ETL/ELT

Power BI: Dashboard development, DAX, Power Query, data modeling

SQL: Writing queries, understanding database structures (Azure SQL, SQL Server, or similar)

Python: Basic scripting for data manipulation, API integration, or automation (pandas, requests, etc.)

AI Platforms: Hands-on experience with ChatGPT, Microsoft Copilot, or similar LLM tools beyond basic prompting

Low-Code Tools: Power Automate, Power Apps, or similar workflow automation platforms

Excel: Advanced formulas, pivot tables, Power Query/Power Pivot

APIs: Understanding of REST APIs and ability to connect systems programmatically

Preferred

Experience in Commercial Real Estate, real estate finance, or related industry preferred

Experience with Microsoft Fabric, OneLake, Azure Data Lake, Databricks, or similar data platforms

Familiarity with CRE data systems: Yardi, CoStar, Argus or similar

Benefits

Competitive Healthcare Coverage

Multilayered Vacation

401K offerings

Company

Westcore

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

San Diego, California, USA

51-200 employees

http://westcore.net

H1B Sponsorship

Westcore has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2022 (2)