Data Engineer

City of New York • New York City, NY

8d

About The Position

The New York City Department of Sanitation (DSNY) keeps New York City healthy, safe, and clean through waste collection, recycling and disposal, street and vacant-lot cleaning, and snow and ice removal. DSNY is the nation's largest municipal sanitation agency, with nearly 10,000 employees, 59 district garages, and a fleet of more than 5,000 vehicles and other equipment.

Under general supervision, with considerable latitude for independent judgment and initiative, the Data Engineer designs, develops, implements, enhances, documents, and maintains database management systems, data integration solutions, custom applications, and related software functions supporting the Operations Management Division (OMD). The role performs complex data engineering, integration, and analytical work in a multi-platform enterprise environment, supporting reporting, analytics, and operational initiatives across the DSNY Operations Management project portfolio.

Requirements

• 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.
• A baccalaureate degree in computer science, engineering, or a related field and four years of satisfactory full-time experience related to datacenter engineering and operations, cloud engineering and operations, or complex IT infrastructure engineering; or a baccalaureate degree and eight years of such experience; or equivalent education and/or experience.
• Strong analytical and problem-solving skills, excellent communication abilities, and the capacity to work effectively with IT teams.

Nice To Haves

• Additional experience with pySpark.
• Experience with Databricks.
• Experience with Microsoft .NET technologies, including ASP.NET, C#, TypeScript, React, or another modern web application framework.
• Experience with Java development and related technologies.
• Familiarity with data warehousing, data governance, cloud platforms, and enterprise data integration best practices.

Responsibilities

• Perform data analysis, data profiling, data 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.
• Analyze legacy and strategic source systems, assess data quality, identify inconsistencies, and recommend corrective actions to improve data integrity and governance.
• Collaborate with business stakeholders, technical teams, and external partners to design, develop, and support data integration pipelines using ETL tools such as Databricks, Informatica PowerCenter, and Pentaho Data Integration (Kettle).
• Develop, maintain, and enhance technical documentation, including data models, data dictionaries, source-to-target mapping documents, ETL specifications, process flows, and reporting artifacts.
• Develop and maintain SQL-based data solutions, including complex queries, stored procedures, database objects, and data transformation processes.
• Support business intelligence and reporting initiatives by developing reports, dashboards, and analytical solutions using platforms such as OBIEE and Power BI.
• Participate in designing and implementing data architecture and integration strategies to improve data sharing and interoperability within DSNY and across City agencies.
• Support and maintain internal IT systems, applications, and databases, ensuring reliability, performance, and adherence to agency standards.

What This Job Offers

• Job Type: Full-time