DIVISION: BPS Operations
OFFICE: Transportation Department
TEAM: Data & Strategy
ACADEMIC/NON-ACADEMIC: NON-ACADEMIC
____________________________________________________________________________________
REPORTS TO: Assistant Director of Data Management
POSITION OVERVIEW:
The Boston Public Schools Office of Transportation is one of the largest departments in the district overseeing a nearly $200M annual budget (~12% of total spending). The Transportation office provides over 600 buses that transport nearly 20,000 students across the district as well as local parochial, private and charter schools. This is one of the largest and most complex school bus transportation systems in the country. The Data Analyst for Routing and Scheduling works within the BPSDOT Data Team providing technology system management, fleet schedule assembly and management, and reporting and data analysis to support overall effective and efficient routing and fleet scheduling.
Responsibilities:
Technology System Management:
- Maintain technology systems related to routing (e.g., Zum, Geotab) and adapt these systems to shifting business needs
- Serve as primary liaison with vendors to ensure BPS DOT is:
- Using the most appropriate version of software
- Utilizing the software to its fullest potential
- Up to date on training all necessary staff
- Serve as liaison between the BPS routing team, BPS Technology and transportation contractors
- Develop and run queries to perform data extractions needed by teams in the department from various data sources including the routing system as well as the district's student information system.
- Manage data in all software systems related to routing and ensure data is properly synced with external data sources.
- Implement data auditing strategies and processes to ensure data integrity
Fleet schedule assembly and management
- Create and maintain fleet schedule that balances performance and efficiency
- Assist with optimization and troubleshooting of routes
Reporting and data analysis
- Gather and translate user requirements into technical specifications
- Develop and generate reports and dashboards for various stakeholders such as BPSDOT staff, t