RMV Crash Data Analytics Co-op Fall 2026

Commonwealth of MassachusettsQuincy, MA
6h

About The Position

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.

Requirements

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

Nice To Haves

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

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%25 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.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service