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 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.ResponsibilitiesBusiness Intelligence DevelopmentDesign, develop, and maintain Power BI dashboards, reports, scorecards, and datasetsDevelop DAX measures, KPIs, and calculations that support business reporting needsTranslate business requirements into effective reporting and visualization solutionsOptimize report performance, usability, and scalabilitySupport the development of reporting tools that identify opportunities, risks, trends, and key performance driversData Integration & ModelingIntegrate data from multiple business systems, including property management, CRM, marketing, financial, and operational platformsDevelop and maintain SQL queries, views, and data transformation processesBuild and maintain scalable data models that support consistent reportingSupport the consolidation of data across furnished and apartment housing platforms to create unified portfolio reportingIdentify opportunities to improve data accessibility, reporting automation, and reporting efficiencyData Quality & GovernanceValidate reporting outputs against source systems and operational reportsInvestigate and resolve data discrepanciesDevelop and maintain reconciliation processes for key business metricsDocument report logic, calculations, data sources, and business rulesSupport reporting standards and best practices that promote consistency and transparencyCollaboration & Continuous ImprovementPartner with business leaders and cross-functional teams to understand business objectives, operational processes, and reporting prioritiesInterpret business needs and translate them into effective reporting and analytics solutionsBuild collaborative relationships across departments to support reporting initiatives and continuous improvementCommunicate technical concepts, assumptions, and recommendations clearly to both technical and non-technical audiencesIdentify opportunities to automate reporting processes and improve operational efficiencyQualificationsRequiredBachelor's degree in Information Systems, Business Analytics, Data Analytics, Computer Science, Finance, Mathematics, or a related field3+ years of experience developing business intelligence or reporting solutionsExperience with Microsoft Power BI, including report development, DAX, Power Query, and data visualization best practicesStrong SQL skills and experience working with relational databasesExperience with data modeling and data transformation conceptsExperience validating and reconciling reporting outputs against source systemsStrong analytical, troubleshooting, and problem-solving skillsStrong 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 stakeholdersAbility to manage multiple priorities and work independently in a collaborative environmentPreferredExperience with Yardi, Yardi Data Connect, or similar property management platformsExperience integrating data from multiple systems and data sourcesExperience with APIs, Microsoft Fabric, Azure, or cloud-based reporting environmentsOTA XML data structures - Orion's integration language is XML-based, which is a different skillset than typical REST/JSON API workExperience in multifamily housing, real estate, hospitality, or related industriesCompensation$85,000+/yearIndividual 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.The PerksFun, positive, and collaborative work environmentRobust training program and ongoing professional development opportunitiesComprehensive 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 with paid 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 organizationAbout AVEAVE 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 NoticeWhen you apply to a job on this site, the personal data contained in your application will be collected by Korman 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 privacy@korman.com.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 restricted by contacting us at privacy@korman.com.