Power BI & SQL Programmer

Job Description

Job Description

About Us :

The Community Preservation Corporation (CPC) believes stable and sustainable affordable housing is the foundation of strong communities and we strive to contribute to comprehensive neighborhood revitalization through our lending and partnerships. A nationally recognized leader in affordable housing finance, CPC has provided a consistent source of capital to underserved housing markets throughout New York State since our inception in 1974.

Today, CPC stands as the largest CDFI solely committed to investing in multifamily housing, having invested more than $15 billion to finance the creation and preservation of more than 230,000 units of quality housing in neighborhoods across New York State and beyond. CPC has a robust construction lending platform, a mortgage bank, and equity and impact investment platforms that focus on our three goals : Expanding Affordable Housing, Closing the Racial Wealth Gap and Investing in the Green Economy.

As a member of our team, you'll have the opportunity to work on impactful projects that make a real difference in people's lives. We're looking for talented individuals who are passionate about our mission and share our values of commitment, respect, excellence, accountability, and collaboration.

Role Summary :

As a Power BI & SQL Programmer, you play a key role in supporting and enhancing CPC’s Microsoft Power BI environment and Microsoft SQL Server database systems within an Azure environment. You’re responsible for the full lifecycle of report and database development—including SQL code creation, report building, testing, deployment, upgrades, and ongoing maintenance.

Your day-to-day includes monitoring Power BI operations, creating and maintaining reporting tables, and ensuring optimal report performance. You bring advanced SQL programming skills to the table, writing complex queries, optimizing performance, and developing stored procedures and functions. You also implement both temporary and permanent bug fixes to maintain system reliability and data accuracy.

This hands-on technical role is ideal if you thrive in a fast-paced environment and enjoy turning data into meaningful visualizations through Power BI dashboards and Paginated Reports that drive strategic decision-making.

What You’ll Do :

• Develop, implement and optimize stored procedures and functions using T-SQL
• Build appropriate and useful database tables and views
• Analyze existing SQL queries for performance improvements
• Develop procedures and scripts for data migration
• Create optimized datasets for Power BI and setup refresh schedules
• Build reports using Power BI Paginated Reports and create Power BI dashboards
• Build workflows for power automate to save reports as files on schedule
• Provide capacity for off-hour code deployment and emergency support for production issues on rare occasions as necessary.

Skills and Experience :

What We Offer :

This is a hybrid role where you will work from the Manhattan office two – three days a week. The salary range is $88,000 – $110,000, dependent on experience.

The Community Preservation Corporation is an Equal Opportunity Employer and all employment-related decisions including recruitment, selection, evaluation, promotion, compensation, training and termination are made without regard to race, creed, color, national origin, sex, disability, marital status, status as a veteran, sexual orientation or gender identity, or any other protected status.