Business Intelligence Developer

AVE by Korman Communities; Phoenix (AZ); Hybrid; USD 77,000 - 94,000; Full time

Benefits offered by this job

PTO & health benefits

Birthday Time Off

Volunteer Time Off

Furnished apartment stays nationwide

Career advancement opportunities

Job summary

AVE by Korman Communities seeks a skilled Business Intelligence Developer to design, develop, and maintain Power BI dashboards and data models supporting reporting across our luxury flexible-stay apartment communities. You will integrate data from property management, CRM, marketing, and finance systems, writing SQL and DAX to deliver accurate insights.

The role offers a hybrid work arrangement and potential growth into broader analytics leadership.

Qualifications

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

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.

Skills

Power BI

SQL

DAX

Data modeling

Data transformation

Education

Bachelor's degree in Information Systems, Business Analytics, Data Analytics, Computer Science, Finance, Mathematics

Tools

Yardi

Microsoft Fabric

Azure

APIs

Job description

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

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.

The Perks

• Fun, positive, and collaborative work environment
• Robust training program and ongoing professional development opportunities
• Comprehensive benefits package including: PTO, medical, vision, dental, and 401k (permanent full-time roles only)
• Enjoy a special day to celebrate in your birthday month each year withpaid Birthday Time Off (permanent part-time and full-time roles only)
• Opportunities to give back including: participation in AVE's regular drives and fundraisers in addition to paid Volunteer Time Off each year to volunteer with your non-profit organization of choice (permanent part-time and full-time roles only)
• Complimentary furnished apartment stays at any AVE location nationwide for personal travel (permanent part-time and full-time roles only)
• A career home! Tons of potential for long-term career advancement within a rapidly expanding organization

About AVE

AVE is a brand of Korman Communities, a fifth-generation, family-owned-and-operated real estate company on a mission to create raving residents! Our first-class residential communities offer flexible living solutions - fully furnished apartments for month-to-month stays and contemporary unfurnished apartments for longer lease terms.

Our communities are designed to deliver unparalleled carefree living. We have professional, friendly teams on site to provide exceptional service, complimentary, on-demand, business and resort amenities for convenience, and fun resident events to create a sense of community.

While we own and operate a growing portfolio of best-in-class residential communities nationwide, our most important asset has always been our passionate, dedicated team members. We have a lot of longevity within our team because we commit to team members who embrace our values and promote our reputation for excellence. Many decades ago, we committed ourselves to a value system called QUEST which stands for Quality, Uniqueness, Excellence, Service, and Teamwork. The "S" representing "service," has been the driving force behind everything we do: service to our team members, service to our residents, service to our clients, and service to our communities.

Visit us online at https://www.aveliving.com/careers.

CCPA/CPRA Disclosure Notice

When you apply to a job on this site, the personal data contained in your application will be collected byKorman Communities.

Your personal data will be processed for the purposes of managing Korman Communities recruitment related activities, which include setting up and conducting interviews and tests for applicants, evaluating and assessing the results thereto, and as is otherwise needed in the recruitment and hiring processes. Such processing is legally permissible under CCPA 1798.145, pursuant to CPRA section 31 as necessary for the purposes of the legitimate interests pursued by Korman Communities, which are the solicitation, evaluation, and selection of applicants for employment.

Your personal data will be shared with Greenhouse Software, Inc., a cloud services provider located in the United States of America and engaged by Korman Communities to help manage its recruitment and hiring process on Korman Communities behalf. You can obtain a copy of the standard contractual clauses by contacting us at [e-mail].

Your personal data will be retained by Korman Communities as long as Korman Communities determines it is necessary to evaluate your application for employment. Under the CCPA/CPRA, you have the right to request access to your personal data, to request that your personal data be rectified or erased, and to request that processing of your personal data be restrictedby contacting us at [e-mail].