The agency keeps New York City healthy, safe, and clean by collecting and recycling waste, cleaning city streets and vacant lots, and clearing snow and ice.
The agency clears litter, snow, and ice from about 6,500 miles of city streets, removes debris from vacant lots, and takes abandoned vehicles off the streets.
The role supports the Operations Management Division with reporting, analytics, and operational projects. You will design, build, improve, document, and maintain database systems, data integration solutions, custom applications, and related software.
You will be a Data Engineer working on complex data engineering, integration, and analysis across several platforms in one enterprise environment.
Responsibilities
Carry out data analysis, profiling, modeling, source-to-target mapping, and reporting for enterprise data and analytics projects.
Build and maintain conceptual, logical, and physical data models that meet current and future operational, analytical, and reporting needs.
Review legacy and current source systems for data quality problems, inconsistencies, and gaps in integrity, and recommend fixes that strengthen governance.
Work with business stakeholders, technical teams, and external partners to design, build, and support complex integration pipelines in tools such as Databricks, Informatica PowerCenter, Pentaho Data Integration (Kettle), and similar technologies.
Write and update technical documents, including data models, data dictionaries, source-to-target mappings, ETL specifications, process flows, and reporting materials.
Build and maintain SQL-based solutions, such as complex queries, stored procedures, database objects, and transformation processes.
Create reports, dashboards, and analytics tools in platforms such as OBIEE, Power BI, and other enterprise reporting tools to support business intelligence work.
Help design and implement data architecture and integration strategies that improve data sharing and interoperability across business areas in the agency and with other city agencies.
Support and maintain internal IT systems, applications, and databases, keeping them reliable, performant, and aligned with agency standards.
Requirements
Strong SQL and Python skills.
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 analytics environments.
Bachelor's degree from an accredited college in computer science, engineering, or a related field, plus 4 years of satisfactory full-time experience in datacenter engineering and operations, cloud engineering and operations, or complex IT infrastructure engineering; or
Bachelor's degree from an accredited college plus 8 years of satisfactory full-time experience in datacenter engineering and operations, cloud engineering and operations, or complex IT infrastructure engineering; or
Education and/or experience equivalent to option 1 or option 2 above.
Strong analytical and problem-solving skills, clear communication, and the ability to work well with others.
Conditions
Works under general supervision, with considerable latitude to use independent judgment and initiative.
The city is an equal opportunity employer that works to keep the workplace free from discrimination and harassment based on any legally protected status or characteristic.