Sql data analyst h1.location_city

NYC DOT is seeking a Senior Data Analyst to strengthen how the City understands, manages, and improves automated camera enforcement in service of Vision Zero and safer streets for New Yorkers. The role is based in Automated Camera Enforcement, the group responsible for the Red Light, Bus Lane, ACE, and Speed Camera programs an operational portfolio that is large, highly visible, and continuing to expand citywide (currently issuing approximately 6.4 million violations per year).
The City has established expansive access to operational and program data. This position will turn that access into practical insight: framing the questions that matter most to program leaders, finding credible answers in the data, and communicating those answers in ways that support day-to-day management, inform program decisions, and strengthen the evidence base for safety outcomes.
The position is a senior individual contributor role with substantial independence and visibility, working closely with operations leadership and alongside an established analytics community across the agency and the City.

Responsibilities:
-Tell the program’s operational story through analysis: translate complex findings into plain language, decision-ready recommendations, and materials that support briefings, leadership updates, and cross-agency coordination.
- Build and maintain a small set of trusted program metrics, with clear definitions and documentation so results are consistent, explainable, and easy to use.
- Identify where operations are slowing down or becoming inconsistent across locations or workflows, explain the drivers, and propose practical improvements that teams can implement.
- Forecast volume and workload needs and translate those forecasts into planning inputs (for example: staffing needs, processing capacity, and timelines) that support responsible program expansion.
- Evaluate the impact of operational or policy changes using sound methods that fit real-world constraints, and explain what changed, why it mattered, and what should happen next.
- Create simple, durable tools and recurring reports (for example: performance trackers, workload views, early-warning indicators) that reduce manual work and help teams manage the program at scale.
- Write efficient SQL to pull and combine data from multiple systems and develop reliable automated datasets that reduce one-off reporting and improve data freshness.
- Use Python and/or R to build reusable analytical workflows (for example: forecasting, anomaly detection, segmentation), with clear documentation of assumptions and limitations.



Work Location: To Be Determined


Hours/Shift: 35 Hrs./ Mon-Fri / 9:00AM – 5:00PM


This position may be eligible for remote work up to 2 days per week, pursuant to the Remote Work Pilot Program agreed to between the City and DC37.



All resumes are to be submitted electronically using one of the following methods:
Please go to and search for the JOB ID #:
Current employees please log on into Employee Self Service at and follow the Careers Link and search for JOB ID #:
No phone calls, faxes or personal inquiries permitted.
Only applicants under consideration will be contacted.
Most public libraries have computers available for use.
Note: New hires must reside in NYC for the first two years of employment. Appointments are subject to OMB approval.
For more information about DOT, visit us at: RESEARCH SCIENTIST -

Minimum Qualifications

1. For Assignment Level I (only physical, biological and environmental sciences and public health) A master's degree from an accredited college or university with a specialization in an appropriate field of physical, biological or environmental science or in public health.
To be appointed to Assignment Level II and above, candidates must have:
1. A doctorate degree from an accredited college or university with specialization in an appropriate field of physical, biological, environmental or social science and one year of full-time experience in a responsible supervisory, administrative or research capacity in the appropriate field of specialization; or
2. A master's degree from an accredited college or university with specialization in an appropriate field of physical, biological, environmental or social science and three years of responsible full-time research experience in the appropriate field of specialization; or
3. Education and/or experience which is equivalent to "1" or "2" above. However, all candidates must have at least a master's degree in an appropriate field of specialization and at least two years of experience described in "2" above. Two years as a City Research Scientist Level I can be substituted for the experience required in "1" and "2" above.

NOTE:
Probationary Period
Appointments to this position are subject to a minimum probationary period of one year.

Preferred Skills
Successful candidate demonstrate the following, though not every qualification is required: - Strong writing and presentation skills, including experience explaining quantitative work to non-technical audiences and advocating for data-informed recommendations. - Significant experience delivering applied analytics in complex operational or public-facing environments, including framing questions, conducting analysis, and influencing decisions through clear communication. - Advanced SQL proficiency and experience working with large datasets from multiple sources comfort navigating messy data and defining metrics that can be trusted. - Familiarity with transportation operations, street safety, enforcement programs, or Vision Zero-oriented work is valued experience in citywide stakeholder environments is a plus. We recognize that a strong candidate may come from a variety of backgrounds and experiences. If this position interests you and you meet many but not all of the criteria, we encourage you to apply.
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 class="jobad-residencyRequirement">Residency RequirementNew 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.