The Office of Performance Management and Innovation (OPMI) at MassDOT and MBTA needs to improve performance across all operating divisions by leveraging data to answer business questions, provide actionable insights, and enhance decision-making.
Requirements
- Experience in query writing and tuning (e.g., SQL, Access).
- Familiarity with Python or R.
- Proficiency in data lineage: including sources of data, how metrics are aggregated; and how resulting business intelligence is consumed and interpreted by the business.
- Experience conducting large-scale analysis to support business decision making.
- Expertise in at least one approach to advanced data analysis (e.g. GIS, SQL, Python, R, SPSS, or other).
- Advanced expertise in MS Word, Excel, and PowerPoint.
- At least two years of full-time or equivalent part-time professional or technical experience performing related duties that include business data recovery, analysis, query design, reporting and statistical analysis.
Responsibilities
- Build and iterate on analyses and reporting designed to tell a story and let the data speak for itself while setting the direction for future reporting.
- Contribute to design of user interaction and experience for interactive tools and dashboards using business intelligence tools, graphic design software, and/or web design.
- Conduct analyses designed to answer quantitative and spatial problems using statistical or analytic software packages.
- Advise on best practices for data structure and analysis to communicate key messages accurately and effectively.
- Design and prepare reports, blog entries, and presentations, including charts, maps, and other visualizations.
- Design and implement programmatic solutions to access and visualize data, including retrieving data from APIs, cleaning large data files, and creating visualizations using Tableau.
- Collaborate with the OPMI data strategy team to ensure accurate and seamless data storage on our research server.
Other
- Respond to each inquiry, whether from a customer, vendor or coworker in a courteous and professional manner.
- Assist with other duties in OPMI as needed, including providing support to Performance Management vertical and cross-team projects.
- Develop the skills of more junior analysts and interns and build knowledge of ridership data across the team.
- Advanced ability to draw insights from data and clearly communicate them (verbal/written/visualized) to the stakeholders and senior management as required.
- Effective organizational, analytical, quantitative, qualitative, multi-tasking and time management skills.
