Analytics & Reporting Engineer for the Division of Strategic Operations & Analytics
City of New York1 day ago
New York, NY, USAMid Level
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 across siloed source systems.
- Load cleaned datasets into SQL Server and connect them to BI tools such as Power BI.
- Implement code validation, testing, and documentation practices for analytics scripts and datasets.
- Document code standards and workflows to keep datasets and scripts maintainable.
- Apply data engineering skills and collaborate across teams to resolve technical issues and guide implementation approaches.
Requirements
- Experience building or supporting data pipelines that extract, clean, and transform data from multiple sources.
- Experience with relational databases such as SQL Server or similar systems.
- Some experience with BI data modeling, preferably Power BI or a similar tool.
- Familiarity with source control and version control workflows such as Azure DevOps Repos.
- Technical skills in SQL, Python, Power BI data modeling, DAX, Power Query M, and data modeling fundamentals.
- Strong interpersonal, organizational, problem-solving, collaboration, and independent-learning skills.
- A master's degree in an appropriate field of specialization is required for the stated City Research Scientist qualifications.
- At least two years of responsible full-time research experience is required for the stated Assignment Level II and above qualifications, with certain equivalent education and experience pathways permitted.
About City of New York
The City of New York is the municipal government for the five boroughs, delivering public services such as housing, social assistance, public safety, and digital tools for residents and businesses. It is publicly funded and operates agencies including the Department of Social Services (HRA and DHS) and the New York City Housing Authority. Headquartered in New York, NY, it builds and maintains large-scale systems supporting benefits eligibility, case management, housing, and civic services.