Commonwealth of Massachusetts · 6 hours ago
Senior Data Analyst (Data Analyst II)
Commonwealth of Massachusetts is responsible for developing and coordinating transportation policies and projects. The selected applicant will be part of a team leading strategic initiatives and supporting performance tracking in transportation, requiring skills in quantitative analysis and effective communication.
Government Administration
Responsibilities
Gathering, analyzing, and interpreting data from all operational administrative units, including transit, traffic, maintenance, construction, economic, environmental impact, historical preservation, finance, and safety and security data, with a main focus on data analysis and interpretation, including
Literature review and overview of secondary data sources related to transit and transportation
Retrieving and organizing GIS data (including demographic, transportation, and land use data) for reporting, analysis, and presentation purposes
Ad hoc cleaning, merging, analysis, and visualization of MBTA & MassDOT’s data using a combination of ArcGIS/SQL/ Excel/R/Python as needed
Performing quality control on scenario modeling tools’ input data, calculations, algorithms, and outputs, and investigating associated data gaps or inconsistencies
Prepare data and workflows for use in a variety of visualization platforms (for example, Leaflet, ArcGIS Insights, Tableau, etc.)
Automating analysis processes
Designing graphs, charts, and tools that clearly communicate outcomes, findings, and trends of agency data
Preparing scheduled and ad-hoc reports, slideshows, and other visual reports incorporating narratives and graphic data, for both online and print format
Recommending changes in the collection and presentation of performance data in order to improve the efficiency and effectiveness of operational and administrative units
Managing and supporting project management for analysis projects, including developing research plans, delegating tasks, and managing timelines
The selected applicant will have the opportunity to oversee and manage the work of interns
Qualification
Required
At least four years of full-time or equivalent part-time professional experience performing related duties that include business data recovery, analysis, query design, reporting and statistical analysis
Ability to work effectively in a fast-paced office environment
Ability to collaborate and interact professionally with other MassDOT and MBTA personnel and staff at other public agencies
Skills in quantitative analysis and written and verbal communication and presentation
Conducting and managing quantitative, qualitative, and spatial analysis projects at OPMI in all areas of transportation, including transit, roadway, and bicycle/pedestrian services
Preferred
Familiarity with Python (or other programming languages), SQL, Apache Spark, or other AWS data solutions, and/or data management and statistical analysis tools (R, SPSS, STATA, SAS, etc.) is preferred
Proficiency in ESRI desktop software and geodatabase products
Proficiency with databases and the Microsoft Office Suite, including extensive spreadsheet and word processing skills
An ability to communicate highly technical work to a non-technical audience through a variety of mediums
Written communication, visual communication, and presentations. Experience with business intelligence software, such as Tableau or PowerBI a plus
An ability to manage projects or support project managers with tasks including developing research plans based on requests from agency staff, creating and delegating tasks to other OPMI staff members and interns, and managing project timelines and products
Ability to learn new tools, technologies, and methods on the job
Benefits
Comprehensive Benefits
Company
Commonwealth of Massachusetts
Commonwealth of Massachusetts is a government administration.
H1B Sponsorship
Commonwealth of Massachusetts has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (7)
2024 (4)
2023 (2)
2022 (6)
2021 (1)
Funding
Current Stage
Late StageTotal Funding
$20.84MKey Investors
U.S. Department of Agriculture
2024-10-29Grant· $20.84M
Recent News
2026-01-11
2025-12-24
Company data provided by crunchbase