Safety Data Analyst; Transportation Program Planner II

Position Summary

This position will assist with mapping and analyzing safety data as well as crash data geocoding activities and other matters related to crash data and analysis within the Safety Unit within Highway Safety. The main duties include tasks responsible for improving crash data quality, geocoding, data analytics and assisting with IMPACT and Federally mandated reporting. An ideal candidate for this role will have experience in GIS, geocoding, and data analytics as they specifically relate to safety data, as well as the ability to train and collaborate with staff and co-ops/interns.

The selected candidate will be expected to follow a hybrid work model that consists of both in-office and work from home days, as needed.

• Create webmaps, storymaps and other means to visualize safety data.
• Pull and analyze crash data, traffic data, road data and other data sets to understand impacts of crashes or incidents (short duration) on traffic flow/routing and speed, understand impacts of construction/work zones (short to medium duration) and understand impacts of planned events or project countermeasures (longer term duration).
• Assist the Traffic and Safety Engineering staff with complex querying of geospatial and other databases as well as asset management systems for signs, markings, signals and other infrastructure.
• Confer with agency staff to identify problems and needs in the provision of analysis tools and services.
• Improve data quality by discovering and discussing causes of data quality issues with RMV, Planning, Police and others and helping to develop solutions.
• Use Python, SQL and other programming tools to conduct traffic and/or safety analysis.
• Develop database/maps to track projects and programs enforcement programs and other needs.
• Assist to develop Crash Performance Functions and other statistical models to evaluate safety performance.
• Design automated programs/routines to accommodate Traffic and Safety Engineering staff needs (Previously, work has included integration of speed regulations into GIS, use of probe data automatically integrating WAZE data with other traffic and safety data, etc.).
• Geocode crashes as needed and follow up on data quality issues.
• QC of roads and highways road inventory used in crash database and roadway safety analyses.
• Evaluate program activities to determine progress and effectiveness and to make appropriate recommendations concerning program activities.
• Recommend the methods to be used and procedures to be followed for program monitoring and evaluation.

• Strong understanding of spatial analysis using ArcGIS is required.
• Working knowledge of SQL Studio, Postgresql, Materialized Views, FME ETL tools, and R.

The 4,000+ employees of Massachusetts Department of Transportation (MassDOT) take great pride in connecting the Commonwealth’s residents and communities. MassDOT is responsible for developing, implementing, and coordinating transportation policies and projects for the Commonwealth of Massachusetts and to efficiently plan, design, construct, and maintain a safe statewide transportation system which effectively meets the transportation needs of the Commonwealth. Information about MassDOT’s culture and career opportunities can be found /massdot-careers.

MassDOT’s divisions include Highway, Registry of Motor Vehicles, Aeronautics, and Rail & Transit. Headquarters (Planning & Enterprise Services) provides business and administrative support and policy leadership for each of the four (4) divisions.

• Applicants must have at least (A) three years of full-time, or equivalent part-time, professional or technical experience in urban planning, regional planning, land use planning or transportation planning, and (B) of which at least one year must have been in a professional capacity, or (C) any equivalent combination of the required experience and the substitutions below.
• Substitutions:
• A Bachelor's or higher degree with a major in urban or regional planning or transportation, civil or environmental engineering may be substituted for the required (A) experience.
• A Graduate degree with a…