Senior Program Manager - Data & Reporting

About the role

The Cambridge Housing Authority ("CHA"), a leader in developing and maintaining affordable housing communities, is seeking a Senior Program Manager - Data & Reporting. This role plays a pivotal part in the agency’s data journey, focusing on developing and implementing the agency’s data strategy, creating a data platform, and implementing organizational-wide Power BI dashboarding.

Responsibilities

• Aide in developing and implementing the agency’s data strategy
• Review and implement the agency’s data platform
• Review and implement organizational-wide Power BI dashboarding
• Collaborate to understand reporting needs
• Act as a consultative partner to senior leaders and department heads to gather reporting requirements and translate them into industry standard and user-friendly dashboards
• Deliver departmental data roadmaps
• Manage the end-to-end rollout of the data and reporting plan, including timeline, progress tracking, and milestone reporting to leadership, by department
• Design and implement a “fit-for-purpose” data warehouse
• Liaise with external vendors for reporting and data development
• Establish and maintain documentation standards
• Create and maintain comprehensive documentation of data processes, methodologies, and logic to ensure transparency, consistency, and continuity across reporting practices
• Must have the ability to influence decisions to drive strategy, create alignment across the organization in aid of an overall data strategy
• Document support for all reporting & dashboarding, ensuring long term access and maintainability
• Able to confidently engage with staff of all levels, able to communicate clearly while carrying out strategy

Requirements

• Advanced skills in Power BI – ability to deploy best practice dashboards, strong technical understanding of DAX, ability to work with disparate data sources, ability to consult other users on the proper use of Power BI
• Advanced skills in SQL – Writing complex queries as needed for extraction, warehousing, and reporting
• Scripting and automation experience – hands-on experience with PowerShell and Power Automate to streamline data processes
• Advanced Microsoft Excel skills – Power Query, data modeling, advanced formulas, and pivot tables
• Ability to influence decisions to drive strategy – create alignment across the organization in aid of an overall data strategy
• Documentation – documented support for all reporting & dashboarding, ensuring long term access and maintainability
• Stakeholder management – Able to confidently engage with staff of all levels, able to communicate clearly while carrying out strategy

Qualifications

• Data governance awareness – understanding of data quality, stewardship and compliance
• Python – exposure to Python, working with reporting, migrating reports
• Familiarity with HUD regulations – an understanding of HUD guidelines and reporting requirements, an appreciation for regulatory context
• Knowledge of housing platforms – experience working with housing specific platforms such as Yardi Voyager or Emphasys Elite

Skills

• Data governance awareness
• Python
• Familiarity with HUD regulations
• Knowledge of housing platforms

Benefits

CHA offers competitive compensation commensurate with experience. Our generous benefits package includes health and dental insurance, paid time off, paid holidays, life and disability insurance options, tuition reimbursement, commuter benefits, retirement pension and deferred compensation 457b plans, and more!

Pay

Commensurate with experience

Schedule

Hybrid work environment consisting of a combination of on-site and work from home days. For the first 6 months, in-office attendance is required. Infrequently, after-hours work may be required.