Business Intelligence Developer

AVE by Korman Communities • Phoenix, AZ

2h • $85,000 • Hybrid

About The Position

Our hospitality-driven real estate brand is growing, and we are seeking hard-working and passionate top talent to grow their careers with us! If you are interested in being a pioneer with AVE as we continue to expand our portfolio of luxury flexible-stay apartment communities nationwide, apply today for an opportunity to join our award-winning team. For four consecutive years, AVE has been ranked in our tier as #1 Apartment Operator in the country, based on resident survey scores through the Kingsley Survey program!
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.

Requirements

• 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

Nice To Haves

• 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

Responsibilities

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

Benefits

• PTO
• medical
• vision
• dental
• 401k
• paid Birthday Time Off
• paid Volunteer Time Off
• Complimentary furnished apartment stays at any AVE location nationwide for personal travel

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level