Business Intelligence Developer
AVE by Korman Communities · Florham Park, NJ · 3 days ago
On-siteInformation Technology$85k/yrFull-time
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
- 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
- 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 and operational reports
- 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