Senior Program Manager - Data & Reporting

Cambridge Housing Authority•Cambridge, MA

9d•Hybrid

About The Position

The Cambridge Housing Authority (CHA) is seeking a Senior Program Manager, Data & Reporting to help build and advance its newly formed data team. The role combines participation in data strategy and adoption with hands-on technical work to identify, source, integrate, and model data from multiple business systems, turning fragmented data into trusted reporting and analytics solutions. The position will help define and evolve CHA’s data strategy in alignment with business goals and promote a data-informed culture across departments. It will lead the creation of a data program supported by a fit-for-purpose data warehouse, enabling staff to produce and use reliable, accurate, standardized reports and dashboards. A central objective is implementing and maintaining organization-wide dashboards in collaboration with department heads. The Senior Program Manager will manage the rollout of data and reporting plans, design and implement the data warehouse, coordinate with external vendors when needed, and establish documentation standards for data processes and reporting. The position is based in an office environment and is eligible for a hybrid schedule under CHA policies. The stated schedule is Monday through Friday during normal business hours, eight hours per day and 40 hours per week, excluding meal breaks; occasional after-hours work may be required.

Requirements

Advanced Power BI skills, including the ability to deploy best-practice dashboards and a 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 SQL skills, including writing complex queries for data extraction, warehousing, and reporting.
Hands-on experience with Power Automate for streamlining 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 and create organizational alignment in support of an overall data strategy.
Ability to document reporting and dashboarding processes to support long-term access and maintainability.
Stakeholder management skills, including confidently engaging and communicating with staff at all levels while carrying out strategy.
Ability to consider alternate views and maintain a position when needed.

Nice To Haves

Awareness of data governance, including data quality, stewardship, and compliance.
Exposure to Python, including working with reporting or migrating reports.
Understanding of HUD guidelines and reporting requirements, and appreciation of regulatory context.
Experience with housing platforms such as Yardi Voyager or Emphasys Elite, including familiarity with their applications and databases.
Bachelor’s degree from an accredited college or university; preferred but not required.
Technical certifications; preferred but not required.

Responsibilities

Help define and evolve CHA’s data strategy, align it with business goals, and foster a data-informed culture across departments.
Create a data program supported by a fit-for-purpose data warehouse for reliable, accurate, and standardized reporting and dashboards.
Gather reporting requirements from senior leaders, department heads, and staff, and translate them into industry-standard, user-friendly dashboards.
Deliver departmental data roadmaps.
Manage the end-to-end rollout of the data and reporting plan, including timelines, progress tracking, and milestone reporting to leadership by department.
Lead the design, data modeling, and implementation of a fit-for-purpose data warehouse that supports accurate, real-time reporting and long-term strategic insights.
Work with external vendors as needed to access, validate, and integrate external data sources for complete and accurate reporting.
Establish and maintain comprehensive documentation of data processes, methodologies, reporting, dashboards, and logic to support transparency, consistency, and continuity.
Support data acquisition, transformation, warehousing, reporting, and user adoption across the full data lifecycle.

Benefits

Health insurance
Dental insurance
Paid time off
Paid holidays
Life insurance options
Disability insurance options
Tuition reimbursement
Commuter benefits
Retirement pension
Deferred compensation 457b plans
Flexible work schedules, including a hybrid work environment, for eligible positions