The department oversees housing standards for all 3.7 million homes in New York City and is the largest municipal housing agency in the country.
It builds and preserves affordable housing, protects tenants from harassment and displacement, and holds landlords to account across all five boroughs.
The Office of Policy and Strategy supports the agency's offices in becoming more effective, efficient, and data-driven. Its Division of Strategic Operations and Analytics reviews agency operations, runs improvement initiatives, and turns data into insights for programs.
In this role you help the division make the agency's data easier to access, trust, and reuse for reporting and analysis.
Responsibilities
Build and maintain core datasets, data models, and dashboards that support program reporting.
Write Python pipelines that clean data and combine records from separate source systems, using automation for housing placement and fair housing reporting.
Load prepared data into SQL Server and connect it to BI tools such as Power BI.
Build scripts and code that can be reused across programs, including homeless placement services, homebuyer assistance, housing distress and compliance, and fair housing.
Add basic validation and testing, and document code and workflows so the team can keep datasets and scripts reliable over time.
Work out technical problems, and help shape the team's approach through creative collaboration.
Requirements
For Assignment Level I, you need a master's degree from an accredited college or university in a relevant field of physical, biological, or environmental science, or in public health.
For Assignment Level II and above, you need one of the following: a doctorate from an accredited college or university in a relevant physical, biological, environmental, or social science, plus 1 year of full-time supervisory, administrative, or research experience in that field; or a master's degree from an accredited college or university in such a science, plus 3 years of full-time responsible research experience in that field.
Equivalent education or experience can also qualify, but you must hold at least a master's degree in a relevant field and have at least 2 years of the research experience described above. Time as a City Research Scientist Level I can replace 2 years of the experience required.
Preferred: experience building or supporting ETL or ELT pipelines that extract, clean, and transform data from several sources.
Preferred: experience with relational databases such as SQL Server or similar.
Plus: some BI data modeling experience, preferably in Power BI or similar.
Preferred: familiarity with source control and version control workflows, such as Azure DevOps Repos.
Preferred: strong interpersonal and organizational skills, with the ability to ask good questions and work across teams.
Preferred: a self-motivated problem solver who wants to make organizations more data-driven.
Preferred: comfort working in a fast-moving, resource-constrained setting with messy data and legacy systems, and a drive to build practical tools.
Preferred: a strong ability to learn new tools and technologies on your own using online resources.
Preferred technical skills: SQL, Python, Power BI data modeling with DAX and Power Query M, and data modeling fundamentals.
Conditions
This is position code 21744 under the title City Research Scientist.
Appointments carry a minimum probationary period of 1 year.
The city is an equal opportunity employer and prohibits discrimination and harassment based on legally protected status.