Summary of Responsibilities

The Business Intelligence (BI) Lead/Manager 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/Manager 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.

Primary Responsibilities and Objectives

Power BI Development & Support

• 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.

Team Leadership

• 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.

Data Integration & Optimization

• 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.

Stakeholder Collaboration

• 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.

Governance & Process Improvement

• 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.

Education and Experience

• 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.
• Experience with property management analytics or systems (Yardi, RealPage, OneSite) preferred.
• Microsoft Power BI certification is a plus.

Skills and Requirements

• 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.

Scheduling

• 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%).

Environment

• Exposure to a typical office environment.

Physical Requirements:

Avenue5 will make reasonable accommodations to enable individuals with disabilities to perform essential functions. These functions include, but are not limited to:

• 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

This job description is not an all-inclusive list of functions and tasks. Over the length of employment, these functions and tasks may change.

Diversity

Diversity creates a healthier atmosphere: Avenue5 is an Equal Employment Opportunity/Affirmative Action employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law.