Business Intelligence Lead

Avenue5 Residential•Phoenix, AZ

1d•Hybrid

About The Position

The Business Intelligence (BI) Lead is a hands-on role responsible for developing, maintaining, and optimizing business intelligence dashboards, datasets, and reports that drive operational performance across the organization. This position combines technical expertise in Power BI with team leadership to deliver high-quality, actionable insights. The BI Lead will manage a small team, resolve BI support tickets, and directly build and troubleshoot dashboards, data models, and integrations. A strong understanding of Power BI, DAX, Power Query, and basic data warehousing is required. Familiarity with property management systems such as Yardi, RealPage, or OneSite is preferred. This role is ideal for someone who enjoys doing the work — not just directing it — and thrives in a fast-moving, collaborative environment. Candidates seeking a primarily strategic or executive-level role may find this position too hands-on.

Requirements

High school diploma required; bachelor’s degree preferred.
2 - 5 years of experience in business intelligence, data analytics, or reporting.
2+ years of hands-on Power BI experience including DAX, Power Query, and data modeling.
1 - 2 years of experience leading or mentoring BI professionals.
Strong understanding of SQL, ETL processes, APIs, and basic data warehousing concepts.
Strong understanding of SQL, ETL processes, API, and data warehousing concepts.
Excellent analytical, problem-solving, and project management skills.
Strong communication skills and the ability to explain technical concepts to non-technical users.
Self-motivated with a bias toward action and ownership.
Proven ability to balance leadership responsibilities with hands-on development work.
Sensitivity to confidential information and strong attention to detail.
Required to maintain a regular schedule, which may include working outside business hours, weekends, and non-traditional holidays.
Hybrid work environment with a minimum of three days worked in office.
Ability to travel (10%).
Ability to lift, push, and pull up to 25 pounds
Hearing and visual ability to observe and detect signs of emergency required
Ability to remain stationary, move around, reach, and position oneself as needed for extended periods
Ability to communicate and express or exchange ideas with others, as well as those activities in which they must convey detailed or important instructions to other works accurately, loudly, or quickly
Ability to perceive the nature of sounds at normal speaking levels, including the ability to receive detailed information through oral communication, and to make the discriminations in sound
Visual requirements including color, depth perception, and field vision
Ability to compare, copy, coordinate, synthesize, negotiate, communicate, and instruct
Ability to tolerate stressful situations
Ability to work under minimal to moderate supervision

Nice To Haves

Experience with property management analytics or systems (Yardi, RealPage, OneSite) preferred.
Microsoft Power BI certification is a plus.

Responsibilities

Design, build, and maintain dashboards, reports, and datasets using Power BI.
Develop and optimize DAX measures, Power Query transformations, and visuals.
Configure and manage Row-Level Security (RLS) within Power BI.
Troubleshoot and resolve Power BI or data-related issues, including end-user support tickets.
Lead and mentor a small team of BI Analysts or Developers (2–3 team members).
Oversee workload prioritization, provide feedback, and ensure timely delivery of BI solutions.
Promote a collaborative team culture focused on learning and excellence.
Integrate data from multiple sources, including Yardi, RealPage, OneSite, and other systems.
Partner with IT and Data teams to maintain stable, high-performing data pipelines and refresh schedules.
Optimize data models and BI performance through best practices and automation.
Partner with Operations, Accounting, and Performance Management teams to identify BI needs.
Translate business questions into functional dashboards and analytical insights.
Train and support internal stakeholders to ensure adoption and effective use of dashboards.
Maintain Power BI workspace organization, security, and documentation.
Drive process improvement and automation to enhance efficiency and reduce manual work.
Ensure data integrity, accuracy, and consistency across reports and models.