Business Intelligence Analyst for the Division of Data Management and Technology (DMT)

About the

Agency:

The NYC Department Housing Preservation & Development (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 Enforcement and Neighborhood Services (OENS) lead the agency's effort to work closely with other HPD divisions and outside community partners to identify buildings in distress, assess and develop appropriate strategies to address those properties and work closely with responsible owners to develop a plan to improve conditions and return buildings to firm financial footing and physical health. OENS uses enforcement tools within its Division of Code Enforcement, Housing Litigation Division, Emergency Operations and Enhanced Enforcement, and the Division of Neighborhood Preservation to ensure compliance with legal and regulatory obligations. The Office of Enforcement and Neighborhood Services is composed of seven divisions: Data Management & Technology (DMT), Division of Neighborhood Preservation (DNP), Administration & Internal Compliance (AIC), Housing Litigation Division (HLD), Division of Code Enforcement (DCE), and Emergency Operations and Enhanced Enforcement Division (EOD) and Division of Emergency Housing Services (EHS).

Your Impact:

The Data Management and Technology Unit (DMT) is a vital part of the Office of Enforcement and Neighborhood Services, actively supporting all reporting functions. Through data collection, studies, and analyses, the DMT unit continually formulates strategies to assist the office in meeting its responsibilities. It leads the development and oversight of analysis and preservation planning across all operations and initiatives. By leveraging performance-based indicators, the unit performs strategic management assessments and forecasting, which inform the refinement and redesign of program plans to further the Enforcement and Neighborhood Services mission. The Business Intelligence Analyst/Certified IT Administrator (Database) will contribute to enhancing HPD's effectiveness by developing, analyzing and optimizing ENS operations. This involves analyzing data to provide actionable insights for ENS divisions and strengthening the agency's overall capacity to utilize data effectively. As a Business Intelligence Analyst/Certified IT Administrator (Database), you will deploy data tools that enhance ENS capacity to operate as a data-driven division. Your work will help cultivate a robust, wide data culture one where insights are actively used to strengthen Enforcement and Neighborhood Services (ENS) operations and drive improved outcomes.

Your Role:

As the Business Intelligence Analyst/Certified IT Administrator (Database), reporting to the Assistant Commissioner and Director of Data Management and Technology, you will drive the expansion of HPD's business intelligence program. This includes facilitating the adoption of innovative analytic tools and enabling ENS programs to more effectively utilize data to inform policy development and enhance operational efficiency. The position provides ample opportunities for collaboration with agency staff and leadership, as well as exposure to a wide range of housing programs.

Your Responsibilities:

• Develop and maintain dashboards that deliver critical insights into ENS operations and outcomes, partnering closely with program teams to grasp their goals and data requirements.
• Work alongside ENS program and technical staff to plan and support the advancement of business intelligence initiatives.
• Gain mastery of HPD's BI platforms (Oracle BI and Power BI) and act as a go-to expert, providing support and training to SOA analysts and agency personnel on using these tools, including advanced functionalities like dashboard creation, reporting, and publisher features.
• Lead special projects focused on analyzing data pertinent to ENS programs.

Preferred Skills:

The ideal candidate will be an inquisitive self-starter, collaborator, and problem-solver with the following skills:

• Strong technical and analytic skills and comfort working with data.
• Experience with business intelligence tools, experience with visualizing data or building dashboards.
• Strong attention to detail, with the ability to maintain a comprehensive project view while also keeping an eye on details.
• Strong interpersonal and communication skills, comfortable working with staff at all levels and asking thoughtful questions to ensure understanding.
• Collaborative, team player with the ability to also drive projects forward independently.
• Enthusiastic about using data to improve government programs and policies.
• Must have advanced Microsoft Excel skills, experience with SQL developer, and Microsoft Access.

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.

CERT IT ADMINISTRATOR

(DB)

• 13644 Minimum Qualifications Professional/Vendor Certification(s) in database administration that is required for the position to be filled.

In addition, you must have one of the following: 1. A baccalaureate degree from an accredited college or university, and two years of satisfactory fulltime (not classroom based) experience in database administration. Experience must include database design, configuration, installation, troubleshooting, integration, performance monitoring, maintenance, enhancement, and security management; 2. A four-year high school diploma or its educational equivalent and six years of satisfactory full-time (not classroom based) information technology experience (IT) of which at least two years must have been database administration experience as described in "1" above; OR 3. A satisfactory equivalent of education and/or experience equivalent to "1" or "2" above. Undergraduate education may be substituted for experience on the basis that 30 undergraduate semester credits from an accredited college or university is equivalent to 6 months of information technology experience, but may not be substituted for the required database administration experience. A masters degree in computer science or a related field from an accredited college or university may substitute for one year of database administration experience. However, all candidates must have at least one year of satisfactory full-time (not classroom based) database administration experience as described in "1" above. 55a Program This position is also open to qualified persons with a disability who are eligible for the 55-a Program. Please indicate at the top of your resume and cover letter that you would like to be considered for the position through the 55-a Program. Public Service Loan Forgiveness As a prospective employee of the City of New York, you may be eligible for federal loan forgiveness programs and state repayment assistance programs. For more information, please visit the U.S. Department of Education's website at https://studentaid.gov/pslf/. Residency Requirement New York City Residency is not required for this position 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.