Data Engineer

City Of New York • $90K — $120K *

New York, NY 10025In-Person

Education, Government & Non-Profit

Less than 5 years of experience

Today

Be an Early Applicant

By clicking Apply, I agree with Ladders' Terms of Use and Privacy Policy

Job Overview by Ladders

Qualifications

Baccalaureate degree in computer science, engineering, or related field.
4 years of experience in datacenter, cloud, or complex IT infrastructure engineering.
8 years of relevant experience without a degree may also qualify.
Strong proficiency in SQL and Python, with PySpark preferred.
Experience with enterprise reporting tools like Power BI or OBIEE.

Responsibilities

Perform data analysis, profiling, modeling, and reporting for analytics projects.
Develop and maintain data models for operational and reporting needs.
Analyze legacy systems for data quality and recommend improvements.
Collaborate with teams to design and support data integration pipelines.
Maintain technical documentation for data processes and models.
Develop SQL solutions, including complex queries and stored procedures.
Support business intelligence initiatives by creating reports and dashboards.

Benefits

Flexible work arrangements to foster work-life balance.
Professional development opportunities and training programs.
Access to modern data platforms and innovative technologies.
Collaboration with a diverse team across multiple city agencies.

Full Job Description

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

IT INFRASTRUCTURE ENGINEER - 95714

Qualifications

1. 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,

2. 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,

3. Education and/or experience which is equivalent to "1" or "2" above.

About City Of New York

The City of New York is the most iconic and dynamic city on the planet. With a population of more than 8.4 million people, New York is not only the largest city in the United States — it is the academic, cultural, commercial, and financial capital of the world. City government is filled with opportunities for talented individuals seeking to improve their communities and make a meaningful difference in the lives of their fellow New Yorkers. Every day, the City’s more than 300,000 employees improve infrastructure, provide vital social services, build technology, protect health and safety, and so much more.

City of New York Careers

There has never been a better time to explore the diverse job opportunities at the City of New York—the hub of professional growth and innovation in the public sector.

Work You’ll Do

Join the City of New York’s dynamic team to contribute to the community and enhance the city’s services across a broad spectrum of disciplines. The City of New York offers a unique opportunity to engage in meaningful work that impacts the lives of millions while navigating through a career filled with learning and growth. Transform the metropolitan landscape and enrich the lives of its residents with the best minds in public administration, urban planning, and community services. The City of New York stands at the forefront of urban management and innovation. Lead with a unique position in public service, at the intersection of technology, community needs, and sustainable development. Work alongside a diverse team of professionals dedicated to improving city operations and enhancing the quality of urban life. Collaborate with the largest network of public service experts in the nation, fostering leadership, diversity training, and professional development.

Introducing the City of New York Public Service Careers

The team is building a market-leading public service career path to help professionals master their roles and contribute effectively to the city’s development.

Do Innovative Work

Join a vast network of experts—dedicated professionals at the intersection of governance, community service, and urban innovation.

Drive Change in Public Service

Deliver targeted solutions and policies that enhance city living and maintain New York as a leading global city through a depth and breadth of expertise that’s second to none.

Be Part of a Great Team

Engage in a wide range of city projects utilizing cutting-edge technology and strategies, harnessing the unparalleled capabilities, scale, and collaborative spirit of a dedicated public service team.

Future-proof Your Career

Advance your career with limitless opportunities in the public sector, supported by unmatched training, development programs, and certification support.

Explore

From improving city infrastructure to enhancing public safety, the City of New York offers a platform for professionals to apply their skills, innovate, and lead.

The City of New York Public Service Initiative

The combined efforts of various departments help overcome urban challenges and lead transformation in city management. Professionals around the globe look to the City of New York for new strategies and solutions to drive significant change and growth in urban living. ## Stay Connected

Join the Team

Search open positions that match your skills and interests. The City of New York looks for passionate, curious, creative, and solution-driven team players. SEARCH CITY OF NEW YORK JOBS

Keep Up to Date

Stay ahead with career tips, insider perspectives, and industry-leading insights you can put to use today—all from the people who serve here.

READ CAREERS BLOG

Job Alert Emails

Personalize your subscription to receive job alerts, latest news, and insider tips tailored to your preferences. Discover what exciting and rewarding opportunities await in the City of New York.

Learn more about City Of New York

Industry