Analytics & Reporting Engineer for the Division of Strategic Operations & Analytics
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. The role helps make agency data more accessible, reliable, and reusable for reporting and analytics by building structured datasets, automations, and data flows. The work supports HPD offices and programs, including homeless placement services, homebuyer assistance, housing distress and compliance, and fair housing. The position focuses on hands-on development of data pipelines, curated datasets, and data flows in SQL Server, as well as reusable scripts and code for reporting and analytics. The engineer creates and maintains reports, dashboards, and related data flows or models. Using independent judgment and initiative, the role develops scalable data models, automated workflows, and well-structured datasets and BI data flows to improve reporting, research, and analytics for agency programs.
Requirements
- Technical skills in SQL and Python.
- 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.
- Ability to implement basic code validation, testing, and documentation practices.
- Strong interpersonal and organizational skills, including the ability to ask thoughtful questions and collaborate across teams.
- Aptitude for learning new tools and technologies independently using online resources.
- For City Research Scientist Assignment Level I, a master's degree from an accredited college or university with a specialization in an appropriate field of physical, biological, or environmental science, or public health.
- For City Research Scientist Assignment Level II and above, one of the stated qualification pathways: a relevant doctorate plus one year of responsible supervisory, administrative, or research experience; a relevant master's degree plus three years of responsible full-time research experience; or equivalent education and/or experience, subject to the stated minimum master's degree and experience requirements. Two years as a City Research Scientist Level I may substitute for the experience specified in the first two pathways.
Nice To Haves
- Experience with BI data modeling, preferably Power BI or similar.
- Familiarity with source-control and version-control workflows such as Azure DevOps Repos.
- Knowledge of Power BI data modeling, including DAX and Power Query M, and data-modeling fundamentals.
- An inquisitive, self-motivated problem-solving approach and interest in helping organizations become more data-driven.
- Comfort working in a fast-moving, resource-constrained environment with messy data and legacy systems, and motivation to build practical tools with real-world impact.
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 drive the team's approach.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
