Senior Business Intelligence Analyst - Commercial Real Estate

Overview

Design and lead BI platform, pipelines, and Power BI insights for CRE operations.

Key Responsibilities

• data pipelines
• power bi
• data governance
• python scripting
• fabric platform
• api integration

Tasks

-Create automated data workflows and reporting processes using Power Automate and Python scripting to improve efficiency and data reliability. -Architect and implement Microsoft Fabric/OneLake (or similar) as our centralized data platform -Establish data governance, quality controls, and documentation standards -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. -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. -Define and implement KPIs and metrics specific to CRE operations (NOI, occupancy, lease expirations, rent rolls, capital expenditures, tenant retention, portfolio performance, etc.) -Implement data quality monitoring and alerting systems -Foster data literacy across the organization through workshops and documentation -Implement data architecture that supports both current BI needs and future AI integration -Create executive-level reporting packages and operational dashboards tailored to different user groups and business functions -Build custom connectors and integrations to streamline data flow between systems -Implement row-level security and access controls to ensure appropriate data visibility across the organization -Document processes and create technical specifications for all automation workflows -Develop and maintain comprehensive Power BI dashboards for asset management, leasing, and financial reporting that align with industry best practices -Collaborate with business stakeholders to understand operational challenges and translate requirements into analytical solutions -Stay current with BI and data platform trends to recommend future enhancements -Develop unified data models and implement governance, quality, and documentation standards to ensure data accuracy, consistency, and accessibility. -Train end-users on Power BI, data tools, and best practices for data exploration -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. -Build robust data pipelines and integrations from Yardi ERP (SQL Data warehouse), SharePoint (Excel/PDFs), Argus, CoStar, GreenStreet, Measurabl, and other CRE data sources -Partner with FP&A and operations teams to continuously refine analytical frameworks and reporting as business needs evolve -Build and maintain sophisticated Power BI dashboards and reporting solutions that deliver actionable insights aligned with CRE industry best practices and operational needs. -Provide technical support and guidance to business users on analytics and reporting -Promote data literacy and adoption by training users, advancing BI tool utilization, and fostering a culture of data-driven decision-making. -Design interactive visualizations and reports that transform complex data into actionable insights for stakeholders at all levels -Develop Python scripts for data manipulation, transformation, and API integration -Build self-service analytics capabilities enabling users to explore data independently while maintaining governance -Design comprehensive data models that normalize and contextualize information across disparate systems

Requirements

• sql
• python
• power bi
• azure synapse
• yardi
• 5+ years

What You Bring

-Familiarity with CRE data systems: Yardi, CoStar, Argus or similar property management and analytics platforms -Data Platforms: Hands-on experience with Microsoft Fabric, Azure Synapse, or similar enterprise data platforms -Bachelor's degree in Data Analytics, Computer Science, Information Systems, Finance, or related field -Strong understanding of data architecture, data modeling, and ETL/ELT processes -Demonstrated experience in Commercial Real Estate, real estate finance, or related industry strongly preferred -SQL: Advanced query writing, stored procedures, performance tuning, database design (Azure SQL, SQL Server, or similar) -APIs: Understanding of REST APIs and ability to connect systems programmatically -5+ years of professional experience in business intelligence, data analytics, or data engineering -Python: Data manipulation and automation scripting (pandas, numpy, requests, API integration) -Experience building API integrations and automated workflows -Power Automate: Workflow automation and system integration -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 -Excel: Advanced formulas, pivot tables, Power Query/Power Pivot -Experience with Microsoft Fabric, OneLake, Azure Data Lake, Databricks, or similar enterprise data platforms -Power BI: Advanced dashboard development, complex DAX calculations, Power Query (M language), data modeling, performance optimization -Version Control: Git/GitHub for code management and collaboration

People Also Searched For

About westcore

Nope

Sector Specialisms