Data Engineer
- Pay
- $120,000 – $180,000 per year
- Location
- New York City, NY
- Listed
- 3 days ago
About the role
The New York City Department of Sanitation (DSNY) keeps New York City healthy, safe, and clean by collecting, recycling, and disposing of waste, cleaning City streets and vacant lots, and clearing snow and ice. 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 trucks, cars, and other types of equipment. The Department clears litter, snow, and ice from approximately 6,500 miles of City streets and removes debris from vacant lots as well as abandoned vehicles from City streets.
Under general supervision, with considerable latitude for the exercise of independent judgment and initiative, the incumbent will be responsible for the design, development, implementation, enhancement, documentation, and maintenance of database management systems, data integration solutions, custom applications, and related software functions supporting the Department of Sanitation's Operations Management Division (OMD).
The selected candidate will serve as a Data Engineer, performing complex data engineering, data integration, and analytical functions within a multi-platform enterprise environment. The role will support critical reporting, analytics, and operational initiatives across the DSNY Operations Management project portfolio.
Key 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.
Required Qualifications
- Strong proficiency in SQL and Python programming. Additional experience with pySpark 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.
Preferred Qualifications
- 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
Qualifications & Requirements
- 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.
Equal opportunity and legal notices
The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.
From City of New York's careers page, first listed on Rolev.ai on November 7, 2026. Rolev.ai is not the employer.
How Rolev.ai helps with this application
Rolev.ai is a job search and application tool for US job seekers. For this Data Engineer role at City of New York, it shows how your resume fits, tailors your resume to the posting, and prepares the application for you to review.
See how you fit
Openings from employer career sites are ranked against your whole resume—and searchable inside Claude, ChatGPT, and Cursor via Rolev.ai MCP.
Tailor without inventing
Every change to your resume is checked against your original. New experience goes in only with your yes—zero fabricated claims.
Draft the full kit
Tailored and Full Match resumes, role-specific cover letters, and answers to employer screening questions are prepared in seconds.
1-Click Extension Autofill
The Chrome extension fills the employer's Greenhouse, Workday, Lever, or Ashby form in 1 click. You review it and press Submit.
Similar roles
All Data Engineer jobsCommon questions
What is the salary for the Data Engineer role at City of New York?
The Data Engineer posting at City of New York states compensation of $120,000 – $180,000 per year. Final pay may depend on location, experience, and interview evaluation on City of New York's official career site.
Where is the Data Engineer job at City of New York located?
This Data Engineer position at City of New York is located in New York City, NY. Always check City of New York's application page for specific state eligibility or relocation policies.
How do I apply for the Data Engineer position at City of New York?
This listing links directly to City of New York's SmartRecruiters application page. You can apply directly on City of New York's site, or use Rolev.ai to check your resume fit, generate a zero-hallucination tailored resume and cover letter for this posting, and autofill the SmartRecruiters application form in 1 click with the Rolev.ai Chrome extension. You always review the form and press Submit yourself.