BI Developer; Multifamily LIHTC

Description

KCG Companies is a leading vertically integrated real estate development and construction firm specializing in the development of sustainable multifamily housing. Our commitment to quality, innovation, and affordable housing is at the core of everything we do.

KCG Companies is a leading vertically integrated real estate development and construction firm specializing in the development of sustainable multifamily housing. Our commitment to quality, innovation, and affordable housing is at the core of everything we do.

We are seeking a skilled and business-minded Business Intelligence Developer to join our Data & Process team. This role is responsible for designing, developing, and maintaining business intelligence solutions that deliver actionable insights and support data-driven decision-making across the organization.

In addition to enterprise BI development, this position will play a critical role in in-system reporting development within operational platforms such as Procore, Term Sheet, and Sage Intacct, as well as providing consultation on data pipeline configuration and system design to ensure high-quality, scalable downstream analytics.

• Design, develop, and maintain scalable BI solutions using tools such as Power BI, Tableau, or similar platforms.
• Translate business requirements into reliable, well-modeled analytical datasets and reporting solutions.

• Develop and maintain in-system reports and analytics within operational platforms including Procore, Term Sheet, and Sage Intacct.
• Ensure alignment between source-system reporting and enterprise BI outputs to maintain consistency and trust in data.

• Analyze complex datasets to identify trends, patterns, and insights that drive operational and strategic decision-making.
• Partner with stakeholders to interpret results and communicate findings clearly to technical and non-technical audiences.

• Create and maintain analytical data models that support accurate and performance reporting.
• Consult on and influence data pipeline configuration and source-system design decisions, ensuring data integrity, security, and optimal downstream analytics outcomes.

• Serve as the analytics lead on enterprise software implementations, driving reporting strategy, defining data standards, validating system configurations, and ensuring all new platforms are implemented with scalable, high-quality analytics and governance in mind.
• Provide analytics-focused input on software configuration and implementation projects, advocating for data quality, scalability, and long-term reporting usability.

• Develop automated dashboards and reports that provide timely, accurate insights to stakeholders across the organization.

• Deliver training and documentation to maximize adoption and effective use of BI tools and reports.
• Support organizational change by guiding teams toward consistent, data-driven practices.

• Work closely with cross-functional teams to align analytics solutions with business objectives.
• Own BI deliverables end-to-end, ensuring solutions meet business requirements, performance standards, and data quality expectations.

• Continuously evaluate and improve BI processes, tools, and systems to increase efficiency and effectiveness.
• Maintain clear, comprehensive documentation of BI solutions, processes, and standards.

• Bachelor’s degree in Computer Science, Information Technology, Business Analytics, or equivalent demonstrated expertise in analytics and data modeling.
• Demonstrated understanding of multifamily real estate business drivers (e.g., occupancy, rent growth, operating expenses, NOI), or a strong interest with the ability to quickly learn industry-specific metrics and workflows.
• Proficiency in BI platforms (e.g., Power BI, Tableau).
• Strong SQL skills, including complex joins, transformations, and performance optimization.
• Experience with data modeling best practices (e.g., star or snowflake schemas).
• Experience developing in-system operational reports and partnering on data pipeline configuration.
• Strong analytical and problem-solving abilities with attention to data quality and detail.
• Excellent verbal and written communication skills, with the ability to translate complex data into clear, actionable insights.
• Demonstrated ability to assess true business needs and support organizational change and adoption.

• Experience with cloud-based BI solutions and modern data platforms.
• Proficiency with Microsoft Power Platform and automation tools.
• Experience training, mentoring, or enabling business users in analytics tools.
• Experience maintaining data hygiene and ensuring data accuracy and consistency.
• Experience implementing or supporting data…