BI Developer (SQL and Power BI)

Quick Facts

• 3+ years BI development with Power BI (advanced DAX, Power Query M) and dimensional modeling
• Strong SQL (CTEs, window functions, performance tuning)
• Experience building real estate data models and metrics (rent roll, NOI, occupancy, leasing, capex, budget vs. actual)
• Experience with Power BI Service: workspaces, deployment pipelines, row-level security, refresh

Description

Build reusable Power BI reports and semantic models for institutional real estate investors, starting from standardized white-label templates and configuring them per client. You will write SQL to create star-schema models from multiple real estate data sources, implement DAX for budget vs. actual and year-over-year logic, and manage embedded Power BI workspaces across DEV/UAT/PROD. You’ll also work directly with clients to present dashboards and validate metric logic, catching data quality issues early.

Responsibilities

• Design Power BI reports and semantic models as reusable templates and then tailor them per client
• Implement scoped custom visuals and client-specific KPIs (e.g., multi-level entity roll-ups, field-parameter views)
• Write SQL to build dimensional star-schema models fed by Yardi, MRI, VTS, Chatham, Argus, RealPage, and client-submitted data
• Create DAX logic for budget vs. actual, T-12, and year-over-year reporting
• Manage Power BI Service embedded environments (DEV, UAT, PROD): deployment pipelines, row-level security, refresh, capacity, and performance tuning
• Keep Power BI artifacts as PBIP files in GitHub with peer review and naming standards; use AI coding assistants to accelerate model changes, testing, and documentation
• Support clients in requirements sessions, UAT, and data validation; explain metric logic to finance and analyst teams
• Validate numbers proactively by identifying issues such as GL mapping gaps, missing lease dates, and occupancy over 100%
• Track work in Monday.com and JIRA; contribute to user guides, demos, and release testing

Requirements

• 3+ years BI development/analytics engineering with Power BI as the primary tool (advanced DAX, Power Query M, dimensional modeling)
• Strong SQL experience (CTEs, window functions, performance tuning)
• Power BI Service experience: workspaces, deployment pipelines, row-level security, refresh
• 2+ years working with real estate data and metrics (rent roll, NOI, occupancy, leasing, capex, budget vs. actual)
• Comfortable running client working sessions and explaining metric logic to executives
• Product mindset and a habit of validating your numbers first
• Discretion with confidential client financial data
• Bachelor’s degree in a related field or equivalent experience

Benefits

• Health, dental, and vision insurance
• Retirement savings plan with company match
• Paid time off and holidays
• Professional development opportunities
• Performance-based bonus based on position
• Salary range: USD $70,700.00–$120,300.00 per year (may vary by location and qualifications)