RMV Crash Data Analytics Co-op Fall 2025

Position Summary

The Crash Data Analytics & Outreach plan development Co-op will transform existing/new summary crash reports in Service Now into clear, actionable insights that drive Law enforcement agency (LEA) outreach and demonstrate measurable improvement in data quality. Working in ServiceNow, IMPACT, and complementary reporting tools, you will map existing reports, expose gaps, build dashboards, and design a proactive trigger based communication cadence to relevant audiences that helps police departments submit high quality crash reports in a timely fashion.

Duties and Responsibilities

• Collaborate with crash team and IT to develop a detailed understanding of current state in terms of reports, emails, audiences, communication cadence and criteria with LEAs.
• Document pain points and challenges and any unmet needs.
• Gap analysis and recommendations for future state.
• Build relevant actionable dashboards/newsletters for audiences (e.g. LEA chief, traffic records) showing key metrics, progress and high priority action items.
• Create internal triggers/alerts that surface deteriorating metrics in real time (e.g., >5% rejection spike) or sudden unexpected variations.
• Draft an email & call-sheet playbook that translates data findings into plain-language action items for each department.
• Design a contact calendar (routine & ad-hoc) tied to trigger logic.
• Develop reports to track the impact of outreach efforts and refine triggers to maximize LEA engagement.
• Develop criteria for determining if observed issues in data quality are RMS vendor driven or LEA driven.
• Develop standardized templates for reaching out to LEAs for specific issues.

Required Qualifications

• Intermediate proficiency with Excel/Google Sheets and at least one data-viz tool (Power BI, Tableau, or similar).
• Familiarity with SQL querying or ServiceNow reporting (coursework or project experience acceptable).
• Strong written and verbal communication skills—able to turn complex data into clear, actionable narratives.
• Detail-oriented, self-starter mindset with the judgment to handle sensitive information responsibly.

Preferred Qualifications

• Experience building automated alerts or trigger logic in ServiceNow, Power Automate, or comparable platforms.
• Prior exposure to public-sector, law-enforcement, or transportation data.

Pre-Hire Process 

Upon a conditional offer of employment, applicants must agree to and successfully satisfy: (i) a comprehensive name-based and fingerprint-based background check of his/her state and federal criminal history records information from all U.S. states, the District of Columbia and certain U.S. Territories and from some foreign nations; (ii) an employment reference check, and (iii) a satisfactory review of his/her driving records to be eligible for this position. 

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