Data Engineer

New York City Department of Transportation
$88,684.00 - $127,520.00
United States, New York, Manhattan
Aug 12, 2025
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 the widespread use of micromobility devices on city streets. As these vehicles become more common for both personal and commercial use, DSD is responsible for ensuring they are used safely, legally, and in ways that support the City's broader transportation and climate goals. DSD employs a multifaceted approach combining data analytics, policy, enforcement, education, and industry oversight to reduce crashes and conflicts on city streets. Its mission is to bring structure, clarity, and safety to the city's evolving micromobility landscape, ensuring these vehicles are integrated responsibly into the urban environment. DOT seeks a Data Engineer to support the Policy Team within the Department of Sustainable Delivery while being assigned to DOT's central analytics unit, Analytics, Performance, and Management (APM). The candidate will play a critical role in building and maintaining the data infrastructure needed to support research, policy, and operational decision-making. In addition to analyzing micromobility, travel, delivery, and other related datasets, this position will focus heavily on designing, implementing, and optimizing data pipelines; developing and maintaining data ingestion, validation, and transformation processes; and integrating new data sources into DOT's data ecosystem. Under the direction and supervision of APM's Deputy Director of Data Engineering and Hosting, the Data Engineer will: 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. CYBER SECURITY ANALYST - 13633 Minimum Qualifications 1. A baccalaureate degree, from an accredited college including or supplemented by twenty-four (24) semester credits in cyber security, network security, computer science, computer programming, computer engineering, information technology, information science, information systems management, network administration, or a pertinent scientific, technical or related area; or 2. A four-year high school diploma or its equivalent approved by a State's department of education or a recognized accrediting organization and three years of satisfactory experience in any of the areas described in "1" above; or 3. Education and/or experience equivalent to "1" or "2", above. College education may be substituted for up to two years of the required experience in "2" above on the basis that sixty (60) semester credits from an accredited college is equated to one year of experience. In addition, twenty-four (24) credits from an accredited college or graduate school in cyber security, network security, computer science, computer programming, computer engineering, information technology, information science, information systems management, network administration, or a pertinent scientific, technical or related area; or a certificate of at least 625 hours in computer programming from an accredited technical school (post high school), may be substituted for one year of experience. Preferred Skills 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. Strong communication skills (oral and written) and the ability to collaborate across technical and non-technical teams. Candidates with experience managing large, complex datasets, transportation or mobility data are preferred. Knowledge of privacy standards, data-sharing agreements, and public-sector data governance is a plus. Familiarity with urban or transportation policy is a plus. 55a Program This position is also open to qualified persons with a disability who are eligible for the 55-a Program. Please indicate at the top of your resume and cover letter that you would like to be considered for the position through the 55-a Program. 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 generally required within 90 days of appointment. However, City Employees in certain titles who have worked for the City for 2 continuous years may also be eligible to reside in Nassau, Suffolk, Putnam, Westchester, Rockland, or Orange County. To determine if the residency requirement applies to you, please discuss with the agency representative at the time of interview. 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 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.