Routing & Scheduling Data Analyst - Transit Analytics

Boston Public Schools

Boston (MA)

On-site

USD 112,000 - 137,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Analyst, Routing and Scheduling
Data Analyst, Routing and Scheduling

Boston Public Schools • Boston (MA)

On-site
USD 112,000 - 137,000
Transit Planning & Operations Analyst — Data-Driven Impact
Transit Planning & Operations Analyst — Data-Driven Impact

RTA Transit Services Inc • Worcester (MA)

On-site
USD 58,000 - 62,000
Transit Systems & Data Specialist
Transit Systems & Data Specialist

Bi-State Development • St. Louis (MO)

On-site
USD 74,000 - 86,000
Medical, prescription, dental, and vis
4 weeks PTO
401(k) retirement plan
+3
Transit Systems & Data Analytics Specialist
Transit Systems & Data Analytics Specialist

Bi-State Development Agency • St. Louis (MO)

On-site
USD 74,000 - 86,000
Comprehensive health coverage (medical
PPO health plan
Paid time off 4 weeks
+8
School Transportation Routing Specialist
School Transportation Routing Specialist

Student Transportation Of America • Salem (NH)

On-site
USD 21,000 - 30,000
Fleet Analytics & Transportation Lead
Fleet Analytics & Transportation Lead

UMass Amherst • Amherst (MA)

On-site
USD 65,000 - 95,000
Transit Systems Analyst - Scheduling & Optimization
Transit Systems Analyst - Scheduling & Optimization

Haalufa USA • Washington

On-site
USD 75,000 - 110,000
Transportation Operations Leader – Public Schools
Transportation Operations Leader – Public Schools

Transdev North America, Inc. • Boston (MA)

On-site
USD 94,000 - 117,000
Vacation: minimum two weeks
Sick days: 5 days
Holidays: 12 days (8 standard, 4 float
+5
Dispatch Product Analyst for School Transportation SaaS
Dispatch Product Analyst for School Transportation SaaS

Tyler Technologies, Inc. • New York (NY)

On-site
USD 42,316 - 80,000
Competitive benefits
Great workplace environment
Analyst, Transportation Routing
Analyst, Transportation Routing

Shelby County Schools • Memphis (TN)

On-site
USD 70,000 - 100,000