Routing & Scheduling Data Analyst - Transit Analytics

Boston Public Schools; Boston (MA); On-site; USD 112,000 - 137,000; Full time

Job summary

Boston Public Schools Central Office - Transportation in Boston, MA is seeking a Data Analyst for Routing and Scheduling to join the Data Team. This role supports fleet scheduling, data management, queries, reporting and dashboards for senior leadership and partners.

The position reports to the Assistant Director of Data Management, works with vendors and internal teams, and contributes to a large $200M budget and one of the country’s largest transportation networks.

Qualifications

• Bachelor's degree in a quantitative field such as Mathematics, Engineering, Actuarial, Statistics, Economics, Computer Science, or similar field.
• 1+ years working in a data management/ technological systems maintenance capacity.
• Expert analytical skills, demonstrating a mastery of Python or R, SQL, and either Microsoft Excel or Google Sheets.
• Strong understanding of data warehousing principles and methodologies.
• Ability to create project plans / timelines, collecting input from stakeholders and sharing back outputs.
• Strong written and oral communication skills, in particular the ability to explain data systems and analyses to non-technical audience.
• Highly organized and detail oriented.

Responsibilities

• 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.
• Create and maintain fleet schedule that balances performance and efficiency.
• Assist with optimization and troubleshooting of routes.
• Gather and translate user requirements into technical specifications.
• Develop and generate reports and dashboards for various stakeholders such as BPSDOT staff, the Executive Director of Transportation, COO, Superintendent and Mayors Office.
• Perform complex analyses on routing data to improve efficiency and bus performance.
• Collaboration with operational department managers (e.g. Operations, Customer Service, Monitors Unit).
• Understand operational complexities as they relate to routing and incorporate into data flows and checks.
• Support training of other departmental staff on how to use routing and fleet data and technology to improve operational procedures.
• Participate in strategy setting and development for the Transportation Department.

Skills

Python

SQL

Excel/Sheets

Data warehousing

Communication

Project planning

Detail oriented

Education

Bachelor's Degree in quantitative field

Tools

Zum

Geotab

Job description

Boston Public Schools Central Office - Transportation in Boston, MA is seeking a Data Analyst for Routing and Scheduling to join the Data Team. This role supports fleet scheduling, data management, queries, reporting and dashboards for senior leadership and partners.

The position reports to the Assistant Director of Data Management, works with vendors and internal teams, and contributes to a large $200M budget and one of the country’s largest transportation networks.