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.

Duties and Responsibilities

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

• Improves data quality by discovering and discussing causes of data quality issues with RMV, Planning, Police and others and helping to develop solutions.

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

• Assisting to develop Crash Performance Functions and other statistical models to evaluate safety performance.

• Designs 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.).

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

Preferred Qualifications 

• A Strong understanding of spatial analysis using ArcGIS is required.

• Working knowledge of SQL Studio, Postgresql, Materialized Views, FME ETL tools, and R.

This position is eligible for a five-thousand dollar ($5,000) signing bonus (“Signing Bonus”) if you are newly hired at MassDOT. Current MassDOT employees are not eligible for the Signing Bonus. The Signing Bonus will be paid in two parts: 1) $3,000 (less applicable taxes) included in the employee's first paycheck. 2) $2,000 (less applicable taxes) after the successful completion of the employee’s probationary period.

About MassDOT

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 at mass.gov/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.  

Minimum Entrance Requirements

This requisition will remain open until filled; however, first consideration will be given to those applicants that apply within the first 14 days.

Current MassDOT employees should use their internal MassCareers account to apply.

All job applications must be submitted online through MassCareers to be considered.

Please provide a complete, accurate and current resume / application for MassDOT to review in order to determine if your submitted materials meet the minimum entrance requirements for the position.   

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

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

II. A Graduate degree with a major in urban or regional planning or transportation, civil or environmental engineering may be substituted for the required experience.*

*Education toward such a degree will be prorated on the basis of the proportion of the requirements actually completed.

SPECIAL REQUIREMENT: Based on assignment, possession of a current and valid Massachusetts Class D Motor Vehicle Operator's License may be required.

• For questions regarding the job posting, please email the MassDOT Talent Acquisition Team at talentacquisition@dot.state.ma.us.

• For general questions regarding MassDOT, call the Human Resources Service Center at 857‐368‐4722.

• For a disability‐related reasonable accommodation or alternative application method, call the ADA Coordinator, Lucy Bayard, at 857‐274‐1935.

Comprehensive Benefits

When you embark on a career with the Commonwealth, you are offered an outstanding suite of employee benefits that add to the overall value of your compensation package. We take pride in providing a work experience that supports you, your loved ones, and your future.

Want the specifics? Explore our Employee Benefits and Rewards!

An Equal Opportunity / Affirmative Action Employer. Females, minorities, veterans, and persons with disabilities are strongly encouraged to apply.

The Commonwealth is an Equal Opportunity Employer and does not discriminate on the basis of race, religion, color, sex, gender identity or expression, sexual orientation, age, disability, national origin, veteran status, or any other basis covered by appropriate law. Research suggests that qualified women, Black, Indigenous, and Persons of Color (BIPOC) may self-select out of opportunities if they don't meet 100% of the job requirements. We encourage individuals who believe they have the skills necessary to thrive to apply for this role.