Skip to main content
City of New York logo

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

City of New York

New York, NYJob$95–101K/yrSeen todayIn the employer's feed · checked in the last 2 days

See where you stand before you apply. No sign-up to start.

You apply on the posting's application page, with no Olive account needed.

Watch jobs like this.

Don't just apply. Show up ready.

Olive works from this exact posting.

At a glance

Compensation
$95–101K/yr
Location
New York, NY
Work Authorization
Not specified

Olive focuses on jobs in the United States, including remote roles you can work from there.

Job overview

The Analytics & Reporting Engineer will support the Division of Strategic Operations and Analytics by making agency data more accessible, reliable, and reusable. The role develops data pipelines, curated datasets, automated workflows, reports, and dashboards for HPD programs, including housing placement services, homebuyer assistance, housing distress and compliance, and fair housing. It also supports reporting, research, and analytics through scalable data models and BI data flows.

Skills & qualifications

RequiredNice to have

Skills

Data Pipelines, nice to haveETL/ELT, nice to haveRelational Databases, nice to haveSQL Server, nice to haveSQL, nice to havePython, nice to havePower BI, nice to haveDAX, nice to havePower Query M, nice to haveBI Data Modeling, nice to haveData Modeling, nice to haveAzure DevOps Repos, nice to haveProblem Solving, nice to haveInterpersonal Skills, nice to haveOrganization, nice to haveCollaboration, nice to haveIndependent Learning, nice to have

Qualifications

Doctorate or Master's With Experience, requiredOne Year Research Experience, requiredThree Years Research Experience, requiredTwo Years Research Experience, requiredTwo Years as City Research Scientist Level I, required

Full job description

Job Description

About the Agency:

The Department of Housing Preservation and Development (HPD) oversees housing standards across all 3.7 million homes in New York City.

As the nation’s largest municipal housing agency, HPD is responsible for building and preserving affordable housing, protecting tenants from harassment and displacement, and holding landlords accountable across the five boroughs. Under Commissioner Dina Levy and the Mamdani Administration, HPD is pursuing an ambitious housing agenda focused on the needs of New York’s tenants. With a broad set of tools including standards enforcement, tenant resources, and the creation of new affordable housing, HPD is committed to making New York City a more affordable place for renters and homeowners alike.

Your Team:

The Office of Policy and Strategy (OPS) leverage its expertise to guide and support HPD and its many Offices in their efforts to deepen their impact, optimize their efficiency, and become more data-driven, climate-adaptive, and mission-focused. As part of OPS, the Division of Strategic Operations and Analytics (SOA) works to increase HPD's impact by analyzing and improving operations agency-wide. SOA does this by clarifying HPD program missions, objectives, and stakeholders; implementing initiatives that advance HPD's goals; analyzing data to deliver actionable insights to HPD programs; and increasing the agency's overall ability to leverage data.

Your Impact:

As the Analytics & Reporting Engineer within SOA, you will play a key role in making HPD’s data more accessible, reliable, and reusable to support reporting and analytics. By building well-structured datasets, automations and data flows, you will help SOA and other HPD offices turn data into key reporting and metrics that support key agency programs for New Yorkers.

Your Role:

Your role will focus on hands-on development of data pipelines, curating datasets and data flows in SQL Server and building reusable scripts and code to support reporting and analytics work for agency programs such as homeless placement services, homebuyer assistance, housing distress & compliance, and fair housing work. You will also create and maintain reports and dashboards, or related dataflows/models. Exercising independent judgement and initiative, you will implement solutions through scalable data models, automated workflows, and well-structured datasets and BI data flows - to enable more efficient reporting, research, and analytics for key agency programs.

Your Responsibilities:

  • Build and maintain core datasets, data models, and dashboards to support key program reporting and analytics

  • Build and automate Python-based data cleaning and integration pipelines merging data across siloed source systems and using automation tools to support reporting needs for housing placements, fair housing and more.

  • Load cleaned datasets into SQL Server and connect to BI tools (e.g. Power BI) to support reporting/dashboarding.

  • Implement basic code validation, testing, and documentation practices to keep analytics scripts and datasets reliable and maintainable.

  • Document code standards and workflows so datasets and scripts remain usable/maintainable by the team over time.

  • Apply data engineering skills and creative collaboration techniques to address technical issues and drive the approach for the team

Preferred skills

  • Inquisitive, self-motivated problem-solver who is passionate about making organizations more data-driven

  • Comfortable working in a fast-moving, resource-constrained environment with messy data and legacy systems; motivated by rolling up your sleeves and building practical tools that make a real impact on people's lives.

  • Experience building or supporting data pipelines (ETL/ELT) extracting, cleaning, and transforming data from multiple sources.

  • Experience working with relational databases (e.g., SQL Server or similar)

  • Some experience with BI data modeling (preferably Power BI or similar) is a plus

  • Familiarity with source control and version control workflows (e.g., Azure DevOps Repos)

  • Strong interpersonal and organizational skills; able to ask thoughtful questions and collaborate across teams

  • Strong aptitude for learning new tools and technologies independently using online resources

  • Technical skills: SQL, Python, Power BI data modeling (DAX, Power Query M), and data modeling fundamentals

CITY RESEARCH SCIENTIST - 21744

Qualifications

  1. For Assignment Level I (only physical, biological and environmental sciences and public health) A master's degree from an accredited college or university with a specialization in an appropriate field of physical, biological or environmental science or in public health.

To be appointed to Assignment Level II and above, candidates must have:

  1. A doctorate degree from an accredited college or university with specialization in an appropriate field of physical, biological, environmental or social science and one year of full-time experience in a responsible supervisory, administrative or research capacity in the appropriate field of specialization; or

  2. A master's degree from an accredited college or university with specialization in an appropriate field of physical, biological, environmental or social science and three years of responsible full-time research experience in the appropriate field of specialization; or

  3. Education and/or experience which is equivalent to "1" or "2" above. However, all candidates must have at least a master's degree in an appropriate field of specialization and at least two years of experience described in "2" above. Two years as a City Research Scientist Level I can be substituted for the experience required in "1" and "2" above.

NOTE:

Probationary Period

Appointments to this position are subject to a minimum probationary period of one year.

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.

Salary Min: $ 95,000.00

Salary Max: $100,904.00

How this job compares

Set against the 3,517 open Data Engineering jobs on Olive Jobs, counted November 21, 2026.

Pay
  • This posting$95–101K/yr
  • New York median$127–223K/yr204 salary ranges
  • US median$124–210K/yr2,969 salary ranges

This range's midpoint, $98K, is 45% below the New York median midpoint ($178K) — in the lowest quarter of Data Engineering salary ranges in New York.

Openings
Olive Jobs lists 227 open Data Engineering jobs in New York and 3,517 across the US. 9% of them nationwide are listed as remote or flexible.
Hiring the most in New York
Experience
This posting asks for at least 2 years of experience — less than three in four Data Engineering postings that state a minimum ask for (median 5 years, across 3,086 postings).
Education
1,248 of the 3,517 open Data Engineering jobs (35%) ask for a bachelor's degree or higher.

Counted across the open, public US postings on Olive Jobs on November 21, 2026. Figures based on too few postings are left out.

Prepare for this role

You've read the whole posting — now see how you match it.