Senior Data Analyst

Responsibilities

• Manage the infrastructure for efficient ETL pipelines from a wide variety of data sources, primarily using SQL.
• Build analytics tools that utilize the data pipeline to provide actionable insights into key business performance metrics.
• Work with stakeholders across the firm to assist with data-related technical issues and support their data infrastructure needs.
• Build processes supporting data transformation, data structures, metadata, dependency, and workload management.
• Work with real estate colleagues to develop analytics and reporting to support our operations.
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
• Take on projects to support development of strategy and measure its effectiveness.
• Own and govern shared Power BI semantic models deployed in Microsoft Fabric workspaces, ensuring accuracy, performance, and accessibility for business users.
• Partner with the data engineering and automation team members on pipeline design, ETL and semantic model optimization, warehouse structure, and delivery of analytics-ready datasets.

Requirements

• Advanced experience developing in Power BI and DAX, including ownership of shared semantic models and report governance in a multi-user environment. Tabular Editor experience strongly preferred.
• Hands-on experience with Microsoft Fabric, including lakehouses, warehouses, and Fabric workspace administration.
• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
• Experience integrating Power BI with Excel, including CUBEVALUE-based reporting and Excel-as-reporting-layer patterns.
• Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
• Familiarity with financial accounting and cost accounting concepts.
• Strong analytic skills related to working with unstructured datasets (e.g., media, documents).
• Strong project management and organizational skills.
• Experience using and managing SharePoint sites and document libraries.
• Working knowledge of multifamily and commercial real estate operations, including key performance metrics (NOI, occupancy, same-store variance, rent roll) and data providers (CoStar, RealPage, Argus Enterprise).
• Familiarity with Yardi Voyager data structures, Argus Enterprise exports, or comparable property management and asset management systems strongly preferred.
• Willingness to travel for periodic company meetings.