System Administrator/Data Analyst at CityOfNewYork

About the Agency: The New York City Department of Housing Preservation (HPD) promotes quality and affordability in the city's housing, and diversity and strength in the city’s neighborhoods because every New Yorker deserves a safe, affordable place to live in a neighborhood they love. - We maintain building and resident safety and health - We create opportunities for New Yorkers through housing affordability - We engage New Yorkers to build and sustain neighborhood strength and diversity. Your Team: The Office of Asset and Property Management (APM) leads the agency’s effort to protect the City’s investment in affordable housing and ensure that properties remain stable and affordable over the long-term. APM actively monitors the performance and regulatory compliance of projects sponsored, supervised, and owned by the City, and connects people to affordable housing opportunities. The Office of Asset and Property Management (APM) is composed of five divisions, which includes the Divisions of Asset Management, Property Management & Client Services, Housing Supervision, and Co-op Readiness & Technical Services. The Tax Credit and Home Compliance unit monitors housing projects developed or preserved over the last 20 years that were financed with federal Low Income Housing Tax Credits (LIHTC) and/or HOME. The use of such funds involves extensive regulatory requirements and the monitoring of an owner’s compliance with those regulations. On a yearly basis the team examines rent-rolls to ensure that rents and incomes are within the prescribed limits, conducts site visits to audit tenant files, works with Code Enforcement to assess the physical condition of the apartments, while also following up on any non-compliance related to previous years. Your Impact: As a System Administrator/Data Analyst in the Tax Credit and HOME Compliance Unit (within the Division of Asset Management), you will be responsible for assisting analysts and supervisors with monitoring for regulatory compliance a portfolio of properties that received tax credit and/or HOME assistance through HPD. You will assist with: (i) the Annual Owner Certification (AOC) process for income and rent monitoring; and (ii) Housing Quality Standards (HQS) monitoring. In addition, you will manage the Access database used to track all projects monitored by the Unit and serve as the primary point of contact for owners and property managers who submit rent rolls for their properties through HPD’s e-Rent Roll portal. Your Role: Under general supervision, you will work directly with property owners and managers and other internal and external partners to request and review compliance submissions; maintain the database used to track owners’ noncompliance issues; and coordinate and assist owners and managers with e-Rent Roll submissions. You will monitor Access database for proper performance, manage backups and recovery and make system updates. Your Responsibilities: Day-to-day responsibilities will include: - Assisting with AOC and HQS mailings and sorting AOC submissions - Coordinating directly with the Division of Code Enforcement regarding inspections and communicating regularly with owners - Regularly updating status reports relating to AOC submissions, HQS inspections and incidents of noncompliance. - Researching new projects for entry in the Unit’s Access database - Inputting data, running queries and preparing database reports - Performing regular required updates and maintenance of the database - Assisting owners and managers with e-Rent Roll submissions; identifying and correcting users’ upload errors; coordinating with HPD IT to correct e-Rent Roll system issues Required skills: - Knowledge and experience working with Microsoft Excel and Microsoft Access database including creating queries and generating reports. Knowledge and experience working with SQL queries, SAP Crystal Reports and Word is preferred. Authorization to work in the United States is required for this position. The NYC Department of Housing Preservation and Development does not provide sponsorship for international employees for visa applications, extensions, or status changes, including H-1B visas. Applicants are responsible for ensuring that they meet all qualifying requirements for this position at the time of application. COMMUNITY COORDINATOR - 56058