Senior Business Intelligence Analyst - Commercial Real Estate

Senior Business Intelligence Analyst

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 Finance Department and the anticipated doubli ng of our portfolio over the next few years, Westcore is looking for a well-rounded Senior Business Intelligence Analyst.

Westcore is seeking a commercially fluent, technically proficient Business Intelligence Analyst to own portfolio reporting, fund performance analytics, and investor-facing data products for our growing fund and investor management business. This role sits at the intersection of finance and technology, you understand how industrial CRE assets perform, how funds are structured, and how to translate that into dashboards and reports that drive decisions at the leadership and investor level.

You will be the primary owner of Power BI reporting for asset management, leasing, and financial performance. You will work closely with the VP of Finance, FP&A, and the AI & Data Solutions Analyst to consume a governed, cloud-native data platform (Microsoft Fabric/OneLake) and deliver reporting that is accurate, timely, and investor-ready.

Core Roles & Responsibilities: Portfolio & Investor Reporting Leadership - Own the design, development, and delivery of fund-level performance reporting, ensuring alignment with institutional investor standards and supporting transparency across key financial and operational metrics. Business Intelligence & Analytics Strategy - Lead the development of scalable analytics solutions and dashboards that translate business needs into actionable insights for leadership, asset management, acquisitions, leasing, and finance teams. Data Infrastructure & Semantic Model Management - Oversee the integrity and performance of Power BI data models and reporting architecture, partnering with IT to ensure accurate, reliable, and scalable data pipelines within the OneLake/Fabric environment. Automation & Reporting Efficiency - Drive automation and process optimization initiatives to streamline reporting workflows, reduce manual effort, and improve consistency, auditability, and speed of delivery. Data Governance & Stewardship (Finance Domain) - Act as the Finance Data Steward, ensuring adherence to data governance standards, maintaining data quality, and supporting the development of consistent financial data definitions and validation frameworks. Primary Duties:

Portfolio & Investor Reporting

Design and maintain Power BI dashboards and reporting packages for fund-level performance (NOI, occupancy, lease expirations, rent rolls, IRR, equity multiples, cap rates, capital expenditures) Develop investor reporting templates and fund performance summaries (quarterly reports, board packages, capital account statements) Support new fund launches by defining reporting infrastructure, data requirements, cadence, and distribution workflows Partner with FP&A on variance analysis, budget vs. actual reporting, and quarterly close commentary Implement row-level security and fund-level access controls for appropriate data visibility

Business Intelligence & Analytics

Collaborate cross-functionally (asset management, leasing, acquisitions, finance) to define KPIs and analytical requirements Build self-service analytics capabilities using Copilot for Power BI, enabling natural language data exploration Design role-specific dashboards for executive and operational users Maintain and enhance Power BI semantic models within the OneLake/Fabric platform Establish feedback loops to convert recurring ad hoc requests into standardized dashboard solutions

Automation & Efficiency

Develop automated workflows using Power Automate for report distribution, validation alerts, and investor package generation Create Python, Excel, and Power Query solutions for data transformation and reporting support Document reporting logic, DAX measures, and data dependencies to ensure continuity and audit readiness

Data Governance

Serve as Finance Data Steward, approving taxonomy, validation rules, and data quality standards Identify and escalate upstream data quality issues; collaborate on validation rule development for financial datasets (budgets, rent rolls, capital tracking) Desired Experience: Bachelor's degree in Finance, Accounting, Real Estate, Data Analytics, or related field 5+ years of experience in business intelligence, financial reporting, or data analytics Commercial real estate experience required, including familiarity with operating metrics, fund structures, an