Microsoft Business Intelligence Developer Jobs (NOW HIRING)

AVE is seeking a Business Intelligence Developer to support the continued growth of our reporting, analytics, and decision-support capabilities.

Reporting to the VP, Revenue & Data Strategy, this role will serve as a key technical partner responsible for developing, maintaining, and validating business intelligence solutions that support operational and strategic decision-making. The Business Intelligence Developer will translate defined business objectives and reporting requirements into trusted, scalable Power BI solutions by integrating data from multiple business systems, developing data models, writing SQL and DAX, and ensuring reporting accuracy through data validation and reconciliation.

Success in this role requires strong technical skills, intellectual curiosity, and the ability to build relationships across the organization. The ideal candidate is someone who can interpret business needs, ask thoughtful questions, communicate effectively with both technical and non-technical stakeholders, and translate business requirements into meaningful reporting solutions. While the initial focus is technical development and reporting execution, this role offers the opportunity to grow into a trusted business intelligence partner who contributes to the continued evolution of AVE's analytics capabilities.

This is a hybrid position, working both at a property and at home. There is one position available, however, we are open to the role being based in Philadelphia/Suburban Philadelphia, Pennsylvania; Northern New Jersey; Phoenix/Scottsdale, Arizona; or Austin, Texas. 

Responsibilities:

Business Intelligence Development

• Design, develop, and maintain Power BI dashboards, reports, scorecards, and datasets
• Develop DAX measures, KPIs, and calculations that support business reporting needs
• Translate business requirements into effective reporting and visualization solutions
• Optimize report performance, usability, and scalability
• Support the development of reporting tools that identify opportunities, risks, trends, and key performance drivers

Data Integration & Modeling

• Integrate data from multiple business systems, including property management, CRM, marketing, financial, and operational platforms
• Develop and maintain SQL queries, views, and data transformation processes
• Build and maintain scalable data models that support consistent reporting
• Support the consolidation of data across furnished and apartment housing platforms to create unified portfolio reporting
• Identify opportunities to improve data accessibility, reporting automation, and reporting efficiency

Data Quality & Governance

• Validate reporting outputs against source systems and operational reports
• Investigate and resolve data discrepancies
• Develop and maintain reconciliation processes for key business metrics
• Document report logic, calculations, data sources, and business rules
• Support reporting standards and best practices that promote consistency and transparency

Collaboration & Continuous Improvement

• Partner with business leaders and cross-functional teams to understand business objectives, operational processes, and reporting priorities
• Interpret business needs and translate them into effective reporting and analytics solutions
• Build collaborative relationships across departments to support reporting initiatives and continuous improvement
• Communicate technical concepts, assumptions, and recommendations clearly to both technical and non-technical audiences
• Identify opportunities to automate reporting processes and improve operational efficiency

Qualifications:

Required

• Bachelor's degree in Information Systems, Business Analytics, Data Analytics, Computer Science, Finance, Mathematics, or a related field
• 3+ years of experience developing business intelligence or reporting solutions
• Experience with Microsoft Power BI, including report development, DAX, Power Query, and data visualization best practices
• Strong SQL skills and experience working with relational databases
• Experience with data modeling and data transformation concepts
• Experience validating and reconciling reporting outputs against source systems
• Strong analytical, troubleshooting, and problem-solving skills
• Strong interpersonal, verbal, and written communication skills, with the ability to build relationships, interpret business needs, gather requirements, and communicate effectively with both technical and non-technical stakeholders
• Ability to manage multiple priorities and work independently in a collaborative environment

Preferred

• Experience with Yardi, Yardi Data Connect, or similar property management platforms
• Experience integrating data from multiple systems and data sources
• Experience with APIs, Microsoft Fabric, Azure, or cloud-based reporting environments
• OTA XML data structures - Orion's integration language is XML-based, which is a different skillset than typical REST/JSON API work
• Experience in multifamily housing, real estate, hospitality, or related industries

Compensation

• $85,000+/year

Individual compensation decisions will vary as the annual base compensation range provided is approximate and determined by a variety of factors including but not limited to experience, qualifications, education, and geographic location. AVE also offers additional bonus potential paid out on a monthly and/or quarterly basis (dependent upon the position), which is not included in the base compensation range listed above. All applicants who meet the general job requirements as outlined in the description are encouraged to apply.

#LI-onsite