Data Engineer
City of New York1 day ago
New York, NY, USAMid Level
Responsibilities
- Perform data analysis, profiling, modeling, source-to-target mapping, and reporting for enterprise data and analytics projects.
- Develop and maintain conceptual, logical, and physical data models for operational, analytical, and reporting requirements.
- Assess legacy and strategic source systems for data quality, identify inconsistencies, and recommend corrective actions.
- Design, develop, and support data integration pipelines using ETL tools including Databricks, Informatica PowerCenter, and Pentaho Data Integration.
- Maintain technical documentation including data models, data dictionaries, mapping documents, ETL specifications, process flows, and reporting artifacts.
- Develop SQL-based solutions including complex queries, stored procedures, database objects, and data transformation processes.
- Develop reports, dashboards, and analytical solutions using Power BI, OBIEE, and other enterprise reporting tools.
- Support data architecture and integration strategies that improve data sharing and interoperability across DSNY and City agencies.
- Maintain internal IT systems, applications, and databases for reliability, performance, and compliance with agency standards.
Requirements
- A baccalaureate degree in computer science, engineering, or a related field and four years of satisfactory full-time related experience, or a baccalaureate degree and eight years of such experience, or equivalent education and/or experience.
- Strong proficiency in SQL and Python programming.
- Experience with data modeling, data analysis, ETL development, and database design.
- Experience with enterprise reporting and analytics platforms such as Power BI, OBIEE, Tableau, or similar tools.
- Knowledge of modern data platforms and cloud-based analytics environments; Databricks experience is highly desirable.
- Preferred experience with Microsoft .NET technologies, ASP.NET, C#, TypeScript, React, or another modern web application framework.
- Preferred experience with Java development and related technologies.
- Familiarity with data warehousing, data governance, cloud platforms, and enterprise data integration best practices.
- Strong analytical and problem-solving skills, communication abilities, and ability to work effectively with IT.
Tech Stack
Categories
Data Engineering
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.