Business Intelligence Developer

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

• 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

• Bachelor's degree in Information Systems, Business Analytics, Data Analytics, Computer Science, Finance, Mathematics, or a related…