Data Engineer jobs

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

City of New YorkNew York City, NYFull-timePosted 1 month ago

Pay not listed

Key facts

Experience
3+ years
Degree
Master's degree

This job is closed.

The employer took it down 4 days ago, after 16 days open. Here are similar open jobs.

  • To check: No pay range listed, though one is likely required in NYAsk for the pay range before you interview. The law here likely requires one.
  • Checked: On the company's own careers siteSmartRecruiters board
  • Checked: No reposts foundSmartRecruiters board
  • Note: Last seen open 5 days agoLive check
  • Trust score 90 / 100 · Strong
Posting history
  1. Posted Nov 1, 2026 · taken down Nov 17, 2026
  2. Reposted #1 Nov 20, 2026
See all 5 checksShow fewer
How we check

Similar open jobs

Senior Analytics Engineer

BetterUp · Austin, TX +3 places

$158k–$220k/yrFull-timeHybrid

StrongChecked open todayPosted 29 days ago

See more like this

What you’ll do

  • Build and maintain datasets, data models, dashboards, and dataflows for program reporting and analytics.
  • Develop and automate Python data-cleaning and integration pipelines that combine data from multiple source systems.
  • Load cleaned datasets into SQL Server and connect them to BI tools such as Power BI.
  • Apply validation, testing, and documentation practices to keep scripts and datasets reliable and maintainable.

Summarised from the posting by AI and can be wrong. The full description is the source.

Requirements

Experience

  • For Assignment Level II and above, one of the following: a master's degree in an appropriate physical, biological, environmental, or social science field plus three years of responsible full-time, and
  • Experience building or supporting ETL/ELT data pipelines that extract, clean, and transform data from multiple sources (preferred)
  • Experience with relational databases such as SQL Server (preferred)
  • Some experience with BI data modeling, preferably Power BI or similar (preferred)

Education

  • For Assignment Level I in physical, biological, or environmental sciences or public health: a master's degree with a specialization in an appropriate field
  • For Assignment Level II and above, one of the following: a doctorate in an appropriate physical, biological, environmental, or social science field plus one year of responsible full-time supervisory,1
  • Equivalent education and/or experience for Assignment Level II and above; candidates must have at least a master's degree in an appropriate field and at least two years of responsible full-time

Skills

  • Familiarity with source control and version control workflows such as Azure DevOps Repos (preferred)

Other requirements

  • Aptitude for independently learning new tools and technologies (preferred)

Full job description

From City of New York’s careers site

Job Description

About the Agency:

Show full descriptionShow less

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.

Something wrong with this job? Report it · This flag looks wrong