The NYC Department of Transportation (DOT) is launching the Department of Sustainable Delivery (DSD) to manage the rapid growth of app-based delivery and micromobility devices. DSD needs a Data Analyst to support research, policy, and operational decision-making by building and maintaining data infrastructure and analyzing diverse datasets.
Requirements
- Strong programming skills in Python (experience with 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).
- Work with Power BI, Python, SQL, and/or other tools to transform raw data into usable formats for dashboards, reports, and analysis.
Responsibilities
- 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.
Other
- Demonstrated ability to synthesize data findings into clear, actionable insights for policy development, program design, or performance evaluation.
- Strong communication skills (oral and written) and the ability to collaborate across technical and non-technical teams.
- New York City Residency is not required for this position.
