Apply on Employer Site

Westcore · 2 months ago

Senior Business Intelligence Analyst - Commercial Real Estate

San Diego, CA

Full-time

Onsite

Senior Level

$100K/yr - $130K/yr

5+ years exp

Westcore is a fully-integrated commercial real estate investment company focused on industrial properties in the United States. They are seeking a Senior Business Intelligence Analyst to architect and implement a next-generation business intelligence and data analytics platform, translating commercial real estate operations into data-driven insights.

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, consistency, and accessibility

Translate complex business requirements into analytical solutions by partnering with stakeholders across asset management, leasing, and finance to identify needs, define KPIs, and design reporting frameworks

Build and maintain sophisticated Power BI dashboards and reporting solutions that deliver actionable insights aligned with CRE industry best practices and operational needs

Create automated data workflows and reporting processes using Power Automate and Python scripting to improve efficiency and data reliability

Champion AI and emerging technology adoption by staying current with industry trends, proactively identifying opportunities to enhance analytics capabilities, and positioning data architecture for future AI integration including natural language interaction

Promote data literacy and adoption by training users, advancing 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 robust data pipelines and integrations from Yardi ERP (SQL Data warehouse), SharePoint (Excel/PDFs), Argus, CoStar, GreenStreet, Measurabl, and other CRE data sources

Design comprehensive data models that normalize and contextualize information across disparate systems

Establish data governance, quality controls, and documentation standards

Implement data architecture that supports both current BI needs and future AI integration

Collaborate with business stakeholders to understand operational challenges and translate requirements into analytical solutions

Define and implement KPIs and metrics specific to CRE operations (NOI, occupancy, lease expirations, rent rolls, capital expenditures, tenant retention, portfolio performance, etc.)

Develop and maintain comprehensive Power BI dashboards for asset management, leasing, and financial reporting that align with industry best practices

Design interactive visualizations and reports that transform complex data into actionable insights for stakeholders at all levels

Create executive-level reporting packages and operational dashboards tailored to different user groups and business functions

Build self-service analytics capabilities enabling users to explore data independently while maintaining governance

Implement row-level security and access controls to ensure appropriate data visibility across the organization

Partner with FP&A and operations teams to continuously refine analytical frameworks and reporting as business needs evolve

Create automated workflows for recurring reports, data collection, and validation processes using Power Automate

Develop Python scripts for data manipulation, transformation, and API integration

Build custom connectors and integrations to streamline data flow between systems

Implement data quality monitoring and alerting systems

Document processes and create technical specifications for all automation workflows

Train end-users on Power BI, data tools, and best practices for data exploration

Foster data literacy across the organization through workshops and documentation

Provide technical support and guidance to business users on analytics and reporting

Stay current with BI and data platform trends to recommend future enhancements

Qualification

Microsoft FabricPower BISQLPythonData ArchitectureData ModelingETL/ELT ProcessesAPI IntegrationsData AnalyticsAutomationData GovernanceData LiteracyTeamworkCommunication

Required

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

5+ years of professional experience in business intelligence, data analytics, or data engineering

Proven ability to understand business requirements and translate them into analytical solutions and KPIs

Proven track record of building complex Power BI solutions and data models

Strong understanding of data architecture, data modeling, and ETL/ELT processes

Experience building API integrations and automated workflows

Power BI: Advanced dashboard development, complex DAX calculations, Power Query (M language), data modeling, performance optimization

SQL: Advanced query writing, stored procedures, performance tuning, database design (Azure SQL, SQL Server, or similar)

Python: Data manipulation and automation scripting (pandas, numpy, requests, API integration)

Data Platforms: Hands-on experience with Microsoft Fabric, Azure Synapse, or similar enterprise data platforms

Power Automate: Workflow automation and system integration

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

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

Version Control: Git/GitHub for code management and collaboration

Preferred

Demonstrated experience in Commercial Real Estate, real estate finance, or related industry strongly preferred

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

Familiarity with CRE data systems: Yardi, CoStar, Argus or similar property management and analytics platforms

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)