Senior Program Manager - Data & Reporting

Department:  Information Technology                                                                                                 Union:  N/A

Reports To:  MIS Manager

About Cambridge Housing

The Cambridge Housing Authority ("CHA"), a leader in developing and maintaining affordable housing communities, is seeking a qualified and highly motivated candidate. By focusing on policy innovation and family economic opportunities, the CHA is committed to developing and managing safe, high quality, affordable housing for low-income individuals and families. CHA provides long-term rental housing and rental assistance to more than 5,500+ individuals and families through its Public Housing and Housing Choice Voucher (HCV) Programs. CHA has been awarded accreditation by the Affordable Housing Accreditation Board (AHAB) and was the seventh affordable housing provider in the nation to receive this prestigious accreditation.

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! CHA employees enjoy flexible work schedules including a hybrid work environment consisting of a combination of on-site and work from home days.

Role Overview

CHA is seeking a highly capable Senior Program Manager - Data & Reporting to play a meaningful part in its data journey. This includes participating in strategy planning and adoption, as well as hands-on technical work. If you love data and like the idea of building a platform from the ground up, we would love to hear from you!

This role is focused on three key initiatives:

•    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

Data Strategy

Play a pivotal role in defining and evolving the organization’s data strategy, ensuring alignment with business goals and fostering a data-informed culture across departments.

Data Platform

Create a data platform, backed by a fit-for-purpose data warehouse, that will provide staff with the means to create and consume reporting and dashboards in a reliable, accurate, and standardized way. The Senior Program Manager is a key player in driving and achieving this goal, with the aim of establishing a data-informed agency.

Organizational-Wide Dashboarding

The implementation and maintenance of organizational-wide dashboarding is a key objective for this role. Achieving this goal will require working closely with department heads to gather reporting needs and then translating those needs into standardized dashboards.

While this may appear to be a standard requirement for any role, strong interpersonal, influencing, and documentation skills, along with the ability to articulate at all organizational levels, are essential for success.

Additional Responsibilities

•    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

Lead the design, data modeling, and implementation of a fit-for-purpose data warehouse that supports CHA’s desire for accurate, real-time reporting and long-term strategic insights.

•    Liaise with external vendors for reporting and data development

Where necessary, utilize third-party vendors to access, validate, and integrate external data sources, ensuring complete and accurate reporting as required.

•    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 Skills:

•    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. A willingness to embrace alternate views but also hold where needed.

Favorable Extras:

•    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. Understanding these applications and their databases is a huge benefit.

The work schedule is Monday – Friday, excluding company holidays, and is 40 hours per week. The role is hybrid after the first 6 months of employment, whereby two work-from-home days are permitted each week. For the first 6 months, in-office attendance is required. Infrequently, after-hours work may be required.

Education and Experience

The ideal candidate will have hands-on experience in data reporting, a track record of deploying organizational-wide Power BI dashboarding, and experience with data warehouse design and implementation. They will understand how to work with senior staff and have the ability to translate data requests into actionable items.

A bachelor's degree from an accredited college or university is preferred but not required. Technical certifications are preferred but not required.

If available, prospective candidates are welcome to include a portfolio, or examples of their work, as part of their application. Such materials will be considered alongside their application.

Physical Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential job functions. While performing the duties of this job, the employee is frequently required to maintain a stationary position, operate computers and other office equipment, move about the office, attend onsite and offsite meetings and communicate. The employee must be able to accurately exchange information in person, in writing, and via e-mail and telephone. The employee must occasionally transport up to 25 pounds.