Job Information
City of New York System Administrator/Data Analyst in New York, New York
Job Description
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.
HPD is entrusted with fulfilling these objectives through the goals and strategies of “Housing Our Neighbors: A Blueprint for Housing and Homelessness,” Mayor Adams’ comprehensive housing framework. To support this important work, the administration has committed $5 billion in new capital funding, bringing the 10-year planned investment in housing to $22 billion the largest in the city’s history. This investment, coupled with a commitment to reduce administrative and regulatory barriers, is a multi-pronged strategy to tackle New York City’s complex housing crisis, by addressing homelessness and housing instability, promoting economic stability and mobility, increasing homeownership opportunities, improving health and safety, and increasing opportunities for equitable growth.
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.
Qualifications
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
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
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.
Additional Information
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.