Senior Program Manager - Data & Reporting

Cambridge Housing Authority • Cambridge, MA

10d • $108,500 - $132,800 • 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 planning 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 Senior Program Manager will help define and evolve CHA’s data strategy in alignment with business goals and promote a data-informed culture across departments. The role will lead development of a fit-for-purpose data warehouse and a reliable, accurate, standardized data and reporting program. A key objective is implementing and maintaining organization-wide dashboards based on reporting needs gathered from department heads.

This role works closely with senior leaders, department heads, staff, and external vendors. It manages departmental data roadmaps and the rollout of data and reporting plans, including timelines, progress tracking, and milestone reporting. It also leads data warehouse design, data modeling, and implementation; supports the integration and validation of external data; and establishes documentation standards for data processes, methodologies, and reporting logic.

The position is based in an office environment and is eligible for a hybrid work schedule under CHA policies. The regular 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 extraction, warehousing, and reporting.
• 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 and create organizational alignment in support of an overall data strategy.
• Ability to document reporting and dashboards to support long-term access and maintainability.
• Strong stakeholder-management and communication skills, including the ability to engage confidently with staff at all levels, consider alternate views, and maintain a position where needed.

Nice To Haves

• Awareness of data governance, including data quality, stewardship, and compliance.
• Exposure to Python, including work with reporting or report migration.
• Understanding of HUD guidelines and reporting requirements.
• Experience with housing-specific platforms such as Yardi Voyager or Emphasys Elite, including familiarity with their databases.
• A bachelor’s degree from an accredited college or university; preferred but not required.
• Technical certifications; preferred but not required.

Responsibilities

• Help define and evolve the organization’s data strategy, aligning it with business goals and fostering 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 and department heads and translate them into industry-standard, user-friendly dashboards.
• Implement and maintain organization-wide dashboards.
• Manage the end-to-end rollout of departmental data and reporting plans, including timelines, progress tracking, and milestone reporting to leadership.
• Lead the design, data modeling, and implementation of a fit-for-purpose data warehouse supporting accurate, real-time reporting and long-term strategic insights.
• Work with external vendors as needed to access, validate, and integrate external data sources.
• Establish and maintain comprehensive documentation of data processes, methodologies, and reporting logic.
• Support the data lifecycle from source-system analysis and data acquisition through transformation, warehousing, reporting, and user adoption.
• Communicate and collaborate with staff at all organizational levels, influencing decisions and building alignment around data strategy.

Benefits

• Health insurance
• Dental insurance
• Paid time off
• Paid holidays
• Life and disability insurance options
• Tuition reimbursement
• Commuter benefits
• Retirement pension and deferred compensation 457b plans
• Flexible work schedules for employees in eligible positions, including a hybrid work environment

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed