Business Intelligence Manager

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 (23 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; bachelors 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.

Required Experience:

Manager