Data Engineer

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 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. #J-18808-Ljbffr New York City Department of Transportation