Data Analyst Job at New York City Department of Transportation in New York

Overview

The Department of Sustainable Delivery (DSD) is a new division within the NYC Department of Transportation (DOT), launched in 2025 to respond to the rapid growth of app-based delivery and micromobility. DSD oversees safe, legal, and climate-aligned use of micromobility and delivery vehicles through data analytics, policy, enforcement, education, and industry oversight. Its mission is to bring structure, clarity, and safety to the city's evolving micromobility landscape and ensure responsible integration into the urban environment.

DOT seeks a Data Analyst to support DSD in designing and executing data-driven research and in building and maintaining data infrastructure that supports research, policy, and operational decision-making. The role involves processing and analyzing diverse transportation and delivery datasets, designing and maintaining data pipelines, and integrating new data sources into DOT's data ecosystem.

Under the direction of the Executive Director for Sustainable Delivery Policy, the Data Analyst will:

• Provide analytical support for research projects, legislation, studies, and reports.
• Create data visualizations and dashboards to communicate findings to internal and external stakeholders.
• Design, build, and maintain scalable data pipelines for large and complex datasets, ensuring high data quality, integrity, and availability.
• Coordinate solutions for ingesting and processing third-party data feeds, including establishing data validation and quality-control processes.
• Collaborate with IT and analytics teams to design and optimize cloud-based infrastructure for storage, processing, and analytics (e.g., Microsoft Azure, Snowflake).
• Work with Power BI, Python, SQL, and/or other tools to transform raw data into usable formats for dashboards, reports, and analysis.
• Document data flows, business logic, and technical processes to support data governance and reproducibility.
• Support DSD and the Analytics, Performance, and Management unit with analytical requests, system integrations, and the development of internal data standards.

IT AUTOMATION AND MONITORING E - 95712

Minimum Qualifications

1. A baccalaureate degree in computer science, engineering or a related field from an accredited college and four years of satisfactory full-time experience related to IT automation engineering, monitoring engineering, management of infrastructure; or

2. Eight years of satisfactory full-time experience related to IT automation engineering, monitoring engineering, management of infrastructure;

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

Preferred Skills

• Demonstrated ability to synthesize data findings into clear, actionable insights for policy development, program design, or performance evaluation.
• Strong programming skills in Python (libraries such as Pandas, Polars, or Django) and SQL (Snowflake, SQL Server, Oracle).
• Experience with cloud services such as Microsoft Azure (Data Factory, DevOps) or similar platforms.
• Ability to design, implement, and optimize data pipelines for large, complex datasets.
• Experience with business intelligence tools (e.g., Microsoft Power BI, Tableau) for dashboard development and KPI reporting.
• Strong MS Excel skillset.
• Familiarity with geospatial data and mapping tools (e.g., QGIS, ArcGIS).
• Strong communication skills (oral and written) and the ability to collaborate across technical and non-technical teams.

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 Requirement

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 that is free from discrimination and harassment based on protected status or protected characteristics, including sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.