The Department of Sustainable Delivery (DSD) within the NYC Department of Transportation (DOT) needs to manage the rapid growth of app-based delivery and micromobility devices on city streets. This role will build and maintain data infrastructure to support research, policy, and operational decision-making related to these evolving transportation methods.
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.
- Proven 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.
- Familiarity with data version control (Git/GitHub) and CI/CD workflows.
- Knowledge of data governance, privacy standards, and best practices for managing third-party data feeds.
- Experience with geospatial data (QGIS, ArcGIS) is a plus.
Responsibilities
- Design, build, and maintain scalable data pipelines for large and complex datasets, ensuring high data quality, integrity, and availability.
- Develop 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 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 APM with analytical requests, system integrations, and the development of internal data standards.
Other
- New York City Residency is not required for this position
- Strong communication skills (oral and written) and the ability to collaborate across technical and non-technical teams.
