The MBTA Operations Division needs to design, build, and maintain data and analytics tools to help departments deliver safer, more efficient, and more reliable services by converting vast amounts of operational data into valuable tools for decision-making, root cause analysis, and identifying areas for improvement.
Requirements
- Proficiency with Microsoft Excel, Word, and PowerPoint.
- Experience in at least one approach to advanced data analysis (e.g., SQL, Python, R, SPSS, GIS, or other).
- Possess strong statistics and data fundamentals.
- Experience with relational databases (e.g., Microsoft SQL Server, PostgreSQL, Oracle), including writing queries to obtain and manipulate data.
- Experience with Python, Excel VBA, or other programming languages, and/or data management and statistical analysis tools (R, SPSS, STATA, SAS, etc.).
- Experience with Tableau or other visualization software.
Responsibilities
- Design dashboards, visualizations, graphs, charts, and tools that clearly communicate outcomes, findings, and trends of Operations data.
- Gather, analyze, and interpret operational data using a combination of SQL, Excel, Python and/or relevant modern data analysis tools.
- Perform quality control on data inputs, calculations, algorithms, and model outputs, and investigate associated data gaps or inconsistencies.
- Develop tools to facilitate the automation and dissemination of analyses.
- Prepare scheduled and ad-hoc reports, slideshows, and other visual reports incorporating narratives and graphic data, for both online and print formats.
- Collaborate with other Analysts on the knowledge sharing, cross-training, and joint support of cross-division projects.
Other
- Ability to learn quickly, take direction, work independently, and use creative and collaborative approaches to resolve issues.
- Effective organizational, analytical, multi-tasking, and time management skills.
- Effective written and verbal communication skills.
- The ability to work effectively with a diverse workforce.
- Ability to commute to assigned work locations in the Boston, MA metro area, as required by the role.
