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

City of New York • New York City, NY

18d

About The Position

The Analytics & Reporting Engineer works within the Division of Strategic Operations and Analytics (SOA), part of the Office of Policy and Strategy at the Department of Housing Preservation and Development (HPD). SOA analyzes and improves agency-wide operations, supports HPD programs in using data, and advances agency goals. The engineer helps make HPD data more accessible, reliable, and reusable for reporting and analytics by building structured datasets, automations, and data flows.

The role focuses on hands-on development of data pipelines, curated datasets, and data flows in SQL Server; reusable scripts and code for reporting and analytics; and reports, dashboards, and related data flows or models. The work supports agency programs including homeless placement services, homebuyer assistance, housing distress and compliance, and fair housing. The engineer uses independent judgment and initiative to implement scalable data models, automated workflows, structured datasets, and BI data flows that enable more efficient reporting, research, and analytics.

Requirements

• Technical skills in SQL and Python.
• Familiarity with Power BI data modeling, including DAX and Power Query M, and data modeling fundamentals.
• The position is listed under the City Research Scientist classification. The stated qualifications require at least a master’s degree in an appropriate field of specialization and at least two years of qualifying research experience; stated alternative qualifications include a relevant doctorate with one year of qualifying experience, a relevant master’s degree with three years of responsible full-time research experience, or equivalent education and experience, subject to the stated minimum master’s degree and experience requirements.
• Appointments are subject to a minimum probationary period of one year.

Nice To Haves

• Experience building or supporting ETL/ELT data pipelines that extract, clean, and transform data from multiple sources.
• Experience working with relational databases such as SQL Server or similar.
• Some experience with BI data modeling, preferably Power BI or similar.
• Familiarity with source control and version control workflows, such as Azure DevOps Repos.
• Strong interpersonal and organizational skills, including the ability to ask thoughtful questions and collaborate across teams.
• Ability and aptitude to learn new tools and technologies independently using online resources.
• Inquisitive, self-motivated problem-solving approach and interest in making organizations more data-driven.
• Comfort working in a fast-moving, resource-constrained environment with messy data and legacy systems, and motivation to build practical tools.

Responsibilities

• Build and maintain core datasets, data models, and dashboards for program reporting and analytics.
• Build and automate Python-based data-cleaning and integration pipelines that merge data across siloed source systems and support reporting needs.
• Load cleaned datasets into SQL Server and connect them to BI tools such as Power BI.
• Create and maintain reports, dashboards, and related data flows or models.
• 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 and maintainable by the team.
• Apply data engineering skills and collaborative problem-solving to address technical issues and help determine the team’s approach.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level