Senior Program Manager - Data & Reporting

Department:  Information Technology                                                                                                 Union:  N/A

Reports To:  MIS Manager

ABOUT US

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 in eligible positions 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 newly formed data team. This includes participating in strategy planning and adoption, as well as hands-on technical work. Success in this role requires the ability to identify, source, integrate, and model data from a variety of business systems, transforming fragmented data into trusted reporting and analytics solutions. If you love data and like the idea of building a platform from the ground up, even if you don't meet every requirement, we'd love to hear from you.

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 program, 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.
• Experience designing, managing, and optimizing data pipelines, including data sourcing, API integrations, ETL/ELT processes, data transformation, and quality assurance across multiple systems.
• Advanced skills in SQL – Writing complex queries as needed for extraction, warehousing, and reporting.
• Scripting and automation experience – hands-on experience with Power Automate to streamline data processes.
• Ability to work across the full data lifecycle, from source-system analysis and data acquisition through transformation, warehousing, reporting, and user adoption.
• 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.

Education and Experience

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

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.

Work Environment

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Office environment. The noise level in the work environment is usually moderate.