Data Engineer

The New York City Department of Sanitation (DSNY) is hiring a Data Engineer to support its Operations Management Division. The role designs, develops, maintains, and documents data management systems, integration solutions, applications, and analytics supporting operational and reporting initiatives.

Responsibilities

• Perform data analysis, data profiling, data modeling, source-to-target mapping, and reporting activities for enterprise data and analytics projects
• Develop and maintain conceptual, logical, and physical data models to support current and future operational, analytical, and reporting requirements
• Analyze legacy and strategic source systems to 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 complex data integration pipelines using ETL tools such as Databricks, Informatica PowerCenter, Pentaho Data Integration (Kettle), and similar technologies
• 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 through the development of reports, dashboards, and analytical solutions utilizing platforms such as Oracle Business Intelligence Enterprise Edition (OBIEE), Power BI, and other enterprise reporting tools
• Participate in the design and implementation of innovative data architecture and integration strategies to improve data sharing and interoperability across multiple business domains within DSNY and across City agencies
• Support and maintain internal IT systems, applications, and databases, ensuring reliability, performance, and adherence to agency standards

Preferred

• Additional experience with pySpark
• experience with Databricks
• Experience with Microsoft .NET technologies, including ASP.NET, C#, TypeScript, React or other 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
• The ideal candidate will possess strong analytical and problem-solving skills, excellent communication abilities, and the capacity to work effectively with
• PySpark
• Databricks
• Microsoft .NET
• ASP.NET
• C#
• TypeScript
• React
• Modern Web Frameworks
• Java Development
• Java Technologies
• Data Warehousing
• Data Governance
• Cloud Platforms
• Enterprise Data Integration
• Analytical Skills
• Problem-Solving
• Communication
• Teamwork

Company

• Municipal government providing public services
• New York, New York, USA
• http://www1.nyc.gov/
• Founded in 1898
• 10001+ employees

Qualifications

• 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 from an accredited college 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, complex IT infrastructure engineering; or
• A baccalaureate degree from an accredited college and eight years of satisfactory full-time experience related to datacenter engineering and operations, cloud engineering and operations, complex IT infrastructure engineering; or
• Education and/or experience which is equivalent to "1" or "2" above
• Additional experience with pySpark
• Experience with Databricks
• Experience with Microsoft .NET technologies, including ASP.NET, C#, TypeScript, React or other 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
• The ideal candidate will possess strong analytical and problem-solving skills, excellent communication abilities, and the capacity to work effectively with
• A baccalaureate degree from an accredited college 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, complex IT infrastructure engineering; or,
• A baccalaureate degree from an accredited college and eight years of satisfactory full-time experience related to datacenter engineering and operations, cloud engineering and operations, complex IT infrastructure engineering; or,

Required skills

• SQL, Python, Data Modeling, ETL Development, Database Design, Power BI, Oracle Business Intelligence Enterprise Edition (OBIEE), Tableau, Databricks, Data Warehousing, Data Governance, Cloud Analytics

Preferred skills

• Additional experience with pySpark, experience with Databricks, Experience with Java development and related technologies, Glassdoor, 3.7, New York, New York, USA, http://www1.nyc.gov, Late Stage, Leadership Team, Carl G Esposito, Chief Information Security Officer, Denise Clay, NYC Chief Efficiency Officer, Recent News, IndiaTimes, 2026-09-12, 2026-07-22, PR Newswire, 2026-07-16, Company data provided by, AI Tools, Customize Your Resume, Maximize your interview chances, Build Cover Letter, Make your application stand out, Analyze How Well You Fit, Understand your strength & weakness

Experience

• 4+ years