hirq
← All jobs

City of New York

Senior Data Analyst for the Division of Budget & Program Operations (City HAP Program)

New York City, NY, US · Hybrid · Full-time

Apply well, not just fast

Create a free account and upload your resume to get a match score, keyword gaps, a tailored resume, a cover letter and interview prep for this job.

About the role

ExcelSQLPower BI
About The Agency: The Department of Housing Preservation and Development (HPD) oversees housing standards across all 3.7 million homes in New York City. As the nation’s largest municipal housing agency, HPD is responsible for building and preserving affordable housing, protecting tenants from harassment and displacement, and holding landlords accountable across the five boroughs. Under Commissioner Dina Levy and the Mamdani Administration, HPD is pursuing an ambitious housing agenda focused on the needs of New York’s tenants. With a broad set of tools including standards enforcement, tenant resources, and the creation of new affordable housing, HPD is committed to making New York City a more affordable place for renters and homeowners alike. Your Team: The Office of Housing Access and Stability (“HAS”) consists of the divisions of Housing Opportunity, Tenant and Owner Resources, Housing Stability, Budget and Program Operations, and Program Policy and Innovation. The mission of the office is to ensure fair, efficient, and transparent access to affordable housing. The Office provides subsidies, placement services, and tools that connect New Yorkers to affordable housing and ensures vulnerable households in subsidized housing have the support they need to be safely housed. Housing Access is committed to expanding housing choices, affirmatively furthering fair housing, and stabilizing the financial health of buildings. The Division of Budget and Program Operations (BPO) within the Office of Housing Access and Stability provides support services to the Division of Housing Opportunity, Division of Tenant and Owner Resources, the Division of Housing Stability, and the Division of Policy and Program Innovation. BPO assists with monitoring and supporting program budgeting and planning, including both staffing and procurement support. The Division also manages the Housing Quality Enforcement and related inspection functions for the Office. In addition, the BPO team coordinates technology initiatives and analytics across the Office in coordination with key technology stakeholders across the agency, providing support on key systems to internal and external stakeholders. Your Impact: The City Housing Assistance Program (CHAP) is a City funded rental assistance program administered by the New York City Department of Housing Preservation and Development (HPD). The program provides rental assistance to low-income households with incomes at or below 50% of Area Median Income (AMI) who are at risk of homelessness, including eligible rent-stabilized households facing eviction for nonpayment of rent and certain households residing in shelter who do not qualify for existing rental assistance programs. CityHAP helps eligible households maintain stable, permanent housing by subsidizing their rent, with the household generally contributing 30% of its adjusted monthly income toward rent. The program provides targeted assistance to New Yorkers facing housing instability while helping preserve rent-stabilized housing and prevent homelessness. Under the supervision of the Director of Analytics and Digital Support, and within the portfolio of the Executive Director, The Division of Budget and Program Operations (BPO) is seeking a Senior Data Analyst that will be responsible for using data to assist in the implementation of policy and procedures that help carry out HPD’s mission while conforming program mandates. The Department of Housing Preservation & Development and the City of New York is an equal opportunity employer. Your Role: - Producing reports and dashboards that effectively communicate data related to rental assistance programs. - Ensuring that Divisions within HAS operate in accordance with HPD mandates. - Using quantitative data and qualitative procedures to evaluate and assess program operations; offering recommendations of how to improve operations. - Supporting and migrating legacy MS Access applications and Crystal Reports to more modern platforms. - Collaborating with other team members to identify, plan, and implement changes to applications. - Lead and participate in User Acceptance Testing. - Assists in producing reports and completing ad hoc requests using Power BI, Oracle Analytics, Excel, SQL, and other various analytical tools. - Managing. troubleshooting, and participating in projects that may transform business processes including Applications, lease up, Recertifications, Client Services, Continued Occupancy, Housing Quality Enforcement, Family Self Sufficiency and Legal Support. - Automate processes with Power Automate and Power Apps. - At the discretion of the Director, work on special projects and assignments. Preferred skills - Strong proficiency with Microsoft Excel; business intelligence systems (Oracle Analytics, Microsoft Powe BI), Power Automate, Power Apps, MS Access, Crystal Reports, and/or SQL experience preferred - Strong analytical and detail-oriented aptitude; a high degree of accuracy is required - Excellent communication and organizational skills - Proven ability to problem solve - Ability to transform complex regulations and information into simple procedures - Ability to manage time effectively, set priorities, and meet deadlines - Must be able to work effectively with minimal supervision - Ability to learn and adapt to change This is a hybrid in office/remote work position. Successful candidates must be able to work at our NYC offices. COMMUNITY COORDINATOR - 56058 1. A baccalaureate degree from an accredited college and two years of experience in community work or community centered activities in an area related to the duties described above; or 2. High school graduation or equivalent and six years of experience in community work or community centered activities in an area related to the duties as described above; or 3. Education and/or experience which is equivalent to "1" or "2" above. However, all candidates must have at least one year of experience as described in "1" above. The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.