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

City of New York; New York (NY); On-site; USD 90,000 - 140,000; Full time

Job summary

The City of New York's Department of Housing Preservation and Development seeks an Analytics & Reporting Engineer in the SOA division to make HPD’s data more accessible and reliable. You will build datasets, data models, and data flows to support reporting and analytics for programs like homeless placement, homebuyer assistance, housing distress, and fair housing.

You will design and maintain pipelines in SQL Server, develop Python scripts, and create Power BI dashboards.

Qualifications

• Master's degree required in a physical, biological, environmental science or public health field.
• Doctorate degree or equivalent experience for higher levels.

Responsibilities

• Build datasets, data models, and dashboards to support program reporting and analytics.
• Load cleaned datasets into SQL Server and connect to BI tools to support reporting.
• Document code standards and workflows for maintainability.
• Collaborate across teams to implement scalable data models and automated workflows.

Skills

SQL

Python

Power BI

ETL/ELT

Data pipelines

Relational databases

Azure DevOps Repos

Data modeling

Education

Master's degree in physical, biological, environmental science or public health

Doctorate degree in relevant field

Tools

SQL Server

Power BI

Azure DevOps

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) leverages 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

CITY RESEARCH SCIENTIST - 21744

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

Minimum 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.

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 generally required within 90 days of appointment. However, City Employees in certain titles who have worked for the City for 2 continuous years may also be eligible to reside in Nassau, Suffolk, Putnam, Westchester, Rockland, or Orange County. To determine if the residency requirement applies to you, please discuss with the agency representative at the time of interview.

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.