You and the process

With a person
Anna, in-house recruiter
9 years hiring engineers
30 minutes with a real recruiter
They read your CV with you, on a call, and say where the offers are being lost.
Didn’t find what you were looking for? Tell us what to build
Early Window: Closes in
Company hidden

Analytics & Reporting Engineer for the Division of Strategic Operations & Analytics

  • Office

Salary

Not stated

Similar roles pay $120K - 220K a year · our estimate

AI summary

For members

The whole posting in a few lines. Sign up to read it here and on every role you open.

Sign Up to Read

Description

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.

Where you’d work

From the office

The office

About the company

Company hidden

Office in New York City, United States

Your chances

Mixed signs it's still hiring, not crowded yet, and you'd be among the first.

  • 15 checks run
  • 4 good signs
  • 2 red flags

Still hiring?

10 checks

Mixed signals

In its favour2

  • Still on the company's own careers site, checked 1 h agoModerate evidence
  • Found in the last 48 hours, before the big job boardsModerate evidence

Against it2

  • Listed again after an earlier listing of the same role closedModerate evidence
  • No salary stated, though New York asks most employers to post oneModerate evidence

How crowded?

5 checks

Low

In its favour2

  • In its Early Window: not on the big job boards yetStrong evidence
  • In the office in New York City: only people nearby can take itSlight evidence

Fits Me

How well does this role fit you?

Answer a few questions or drop your CV, and every role gets a fit score with the reasons, this one first.

  • Your field
  • Level
  • Stack
  • Work model
  • Salary floor
  • Must-haves
Details8 facts · Role, Location, Compensation, Employment
Tech stack
  • Python
  • SQL
  • Azure
Type
Full-time
Region
United States
Pay period
Annual
Show 4 more factsShow less

Role

Category
Data & Analytics
Tech stack
  • Python
  • SQL
  • Azure

Location

Work model
Office
Region
United States
Office
  • New York City, United States

Compensation

Salary
Salary by agreement
Pay period
Annual

Employment

Type
Full-time

Something wrong with this vacancy?

Similar vacancies

Share this vacancy

What's wrong with it?

The employer never sees who reported.

Reason