Data Engineer
City of New York27 days 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.
- Assess data quality, identify inconsistencies, and recommend corrective actions for data integrity and governance.
- Design, develop, and support data integration pipelines using ETL technologies.
- Create and maintain SQL queries, stored procedures, database objects, and data transformation processes.
- Develop reports, dashboards, and analytical solutions using enterprise reporting platforms.
- Create technical documentation including data dictionaries, ETL specifications, process flows, and reporting artifacts.
- Support data architecture, integration, interoperability, internal IT systems, applications, and databases.
Requirements
- Strong proficiency in SQL and Python programming is required; PySpark experience is preferred.
- Experience with data modeling, data analysis, ETL development, and database design is required.
- Experience with enterprise reporting and analytics platforms such as Power BI, OBIEE, or Tableau is required.
- Knowledge of modern data platforms and cloud-based analytics environments is required; Databricks experience is highly desirable.
- Preferred experience includes Microsoft .NET, ASP.NET, C#, TypeScript, React, Java, data warehousing, data governance, cloud platforms, and enterprise data integration practices.
- A baccalaureate degree in computer science, engineering, or a related field plus four years of related experience is required, or a baccalaureate degree plus eight years of related experience, or equivalent education and/or experience.
- Strong analytical, problem-solving, communication, and collaboration abilities are expected.
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.