Data Engineer

New York City Department of Transportation; New York (NY); On-site; USD 110,000 - 150,000; Full time

Job summary

New York City Department of Transportation is seeking an IT Infrastructure Engineer specializing as a Data Engineer to support the Enterprise Data Science and Engineering Unit (EDSE). The role focuses on building scalable data pipelines with Apache NiFi, managing Snowflake data warehouses, and administering Linux cloud environments (Azure, AWS, or GCP).

You will collaborate with analysts to deliver production-ready datasets and analytics solutions.

Qualifications

• Bachelor's degree in computer science, engineering or related field and 4+ years of relevant experience in datacenter/cloud engineering or IT infrastructure.
• Alternative 8+ years of relevant experience in datacenter/cloud engineering or IT infrastructure can substitute the degree.
• Experience designing and operating data pipelines and data warehouses is preferred.

Responsibilities

• Architect, implement, and maintain scalable data pipelines using Apache NiFi for ETL and real-time data integration.
• Design, optimize, and manage Snowflake data warehouses including schema design and security controls.
• Administer Linux-based cloud environments (Azure, AWS, or GCP) and automate deployments and monitoring.

Skills

Python

SQL

Data engineering

CI/CD

Education

Bachelor's degree in computer science, engineering or related field

Tools

Apache NiFi

Snowflake

Linux

Terraform

Ansible

Git

Job description

IT INFRASTRUCTURE ENGINEER - 95714

The IT & Telecom division is seeking a highly skilled, detail-oriented Data Engineer to support the Enterprise Data Science and Engineering Unit (EDSE). EDSE is a specialized team within the Agency dedicated to designing and operating advanced data storage and processing solutions capable of handling very large datasets, or "Big Data." In addition to overseeing Big Data operations, EDSE partners with Agency analysts and data scientists to empower leadership and planners with actionable, data-driven insights for critical projects and strategic initiatives.

The Data Engineer will play a key role in supporting the Department of Sustainable Delivery (DSD), a new division within the NYC Department of Transportation focused on the rapid growth of app-based deliveries and the increasing use of electric micromobility devices such as e-bikes, mopeds, and scooters. DSD brings together data analytics, policy, enforcement, education, and industry oversight to address the unique safety and operational challenges posed by the commercial use of micromobility. By collaborating with DSD, the Data Engineer will help develop and maintain data systems that enable the division to monitor, analyze, and report on micromobility trends, support enforcement and policy initiatives, and ensure that data-driven insights contribute to a safer and more sustainable transportation future for New York City.

Under the direction and supervision of the Director, the Data Engineer will: architect, implement, and maintain scalable data pipelines using Apache NiFi for ETL and real-time data integration; design, optimize, and manage Snowflake data warehouses, including schema design, performance tuning, and security controls; administer Linux-based cloud environments (Azure, AWS, or GCP), including automation of deployments, patching, and monitoring; develop and maintain CI/CD workflows for data engineering solutions; collaborate with data scientists and analysts to deliver high-quality, production-ready datasets and analytics solutions; implement robust data governance, lineage, and auditing practices; troubleshoot and resolve issues across the data platform, including connectivity, performance, and security; mentor Agency staff and contribute to technical best practices and documentation; and perform other data engineering tasks as assigned to support a dynamic and fast-paced team, among other duties.

Minimum 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.

Preferred Skills

• -3+ years hands-on experience architecting and operating Apache NiFi flows in production.
• -3+ years of advanced Snowflake experience, including data sharing, security, and performance optimization.
• -Strong Linux administration skills in cloud environments experience with shell scripting and automation tools.
• -Fluency in Python, SQL
• -Experience integrating NiFi with cloud storage, databases, and APIs.
• -Familiarity with infrastructure-as-code (Terraform, Ansible) for cloud resource management.
• -Experience with Git-based workflows, including branching, merging, pull requests, and version control best practices
• -Experience with monitoring, alerting, and logging solutions for data platforms.
• -Knowledge of secure data handling, including TLS/SSL, role-based access, and compliance standards.
• -Cloud certification (Azure, AWS, or GCP) highly desirable.
• -Excellent organizational and interpersonal skills and ability to work cross-functionally.
• -Ability to effectively prioritize and execute tasks in a high-pressure environment.
• -Ability to understand and gather client requirements as well as provide a solution that meets or exceeds client expectations.

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