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 poundsHearing and visual ability to observe and detect signs of emergency requiredAbility to remain stationary move around reach and position oneself as needed for extended periodsAbility 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 quicklyAbility 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 soundVisual requirements including color depth perception and field visionAbility to compare copy coordinate synthesize negotiate communicate and instructAbility to tolerate stressful situationsAbility to work under minimal to moderate supervisionThis 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
Key Skills
Business Intelligence,Cognos,SQL,Power BI,QlikView,Data Visualization,ssrs,Tableau,SSIS,Data Modeling,Data Warehouse,Data Analysis Skills
Employment Type : Full-Time
Experience : years
Vacancy : 1
