DSNY is seeking a Data Engineer to support the Operations Management Division with the design, development, and maintenance of database systems, data integration pipelines, and analytics solutions. This onsite role in New York, NY offers a competitive salary range and the opportunity to contribute to data sharing, governance, and enterprise reporting across city operations. A bachelor’s degree in computer science, engineering, or a related field and at least four years of relevant experience are required.
Responsibilities
- Perform data analysis, profiling, modeling, source-to-target mapping, and reporting for enterprise data and analytics initiatives.
- Develop and maintain conceptual, logical, and physical data models to support current and future operational, analytical, and reporting needs.
- Assess legacy and strategic source systems to evaluate data quality, identify inconsistencies, and recommend corrective actions to strengthen 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 related technologies.
- Create and maintain technical documentation, including data models, data dictionaries, source-to-target mappings, ETL specifications, process flows, and reporting artifacts.
- Build and sustain SQL-based data solutions, including advanced queries, stored procedures, database objects, and data transformation processes.
- Support business intelligence and reporting efforts by developing reports, dashboards, and analytical solutions using OBIEE, Power BI, and other enterprise tools.
- Contribute to the design and implementation of innovative data architecture and integration strategies to improve data sharing and interoperability across DSNY and other City agencies.
- Support and maintain internal IT systems, applications, and databases to ensure reliability, performance, and adherence to agency standards.
Requirements
- Strong proficiency in SQL and Python; experience with pySpark is preferred.
- 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; experience with Databricks is highly desirable.
Technologies
- SQL
- Python
- pySpark
- Databricks
- Informatica PowerCenter
- Pentaho Data Integration (Kettle)
- Oracle Business Intelligence Enterprise Edition (OBIEE)
- Power BI
- Tableau
- ASP.NET
- C#
- TypeScript
- React
- Java
- Unix
- Linux
- Shell scripting
Minimum Qualifications
- A baccalaureate degree from an accredited college in computer science, engineering, or a related field plus four years of satisfactory full-time experience in datacenter engineering and operations, cloud engineering and operations, or complex IT infrastructure engineering; or
- A baccalaureate degree from an accredited college and eight 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 the above.
55A Program
This position is also open to qualified persons with a disability who are eligible for the 55-a Program. Please indicate at the top of your resume and cover letter that you would like to be considered for the position through the 55-a Program.
Public Service Loan Forgiveness
As a prospective employee of the City of New York, you may be eligible for federal loan forgiveness programs and state repayment assistance programs. For more information, please visit the U.S. Department of Education’s website at https://studentaid.gov/pslf/.
Residency
New York City residency is not required for this position.
Additional Information
The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment free from discrimination or harassment based on sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, pregnancy, or other legally protected characteristics.
