Transit Data Analytics Co-Op: Tableau Dashboards

Massachusetts Bay Transportation Authority; Boston (MA); On-site; USD 28,000 - 41,000; Part time

Job summary

The Procurement & Logistics Data Analyst Co-Op at MBTA provides undergraduates with hands-on experience working with large, complex datasets spanning contracts, vendors, purchase orders, invoices, vouchers, and inventory to support daily transit operations and long‑term programs.

You will collaborate with staff and leadership to turn raw data into insights, build dashboards in Tableau, validate data, and help modernize processes so procurement and logistics decisions are data‑driven,

Qualifications

• Enrolled in undergraduate program in data analytics, information systems, business analytics, supply chain or related field.
• Above-average proficiency in Excel for data analysis and reporting.
• Strong analytical and problem-solving skills with interest in data analysis and project work.
• Proficiency in at least one programming language and experience with Git, SQL/No-SQL, CLI/bash, and R or Python/Pandas.
• Proficiency in BI/data visualization tools such as Tableau and/or Power BI to develop dashboards and analyses.
• Ability to explain analytical concepts to technical and non-technical audiences.
• Strong written and verbal English communication; highly organized and detail-oriented.
• Interest in public service, transit, or transportation; able to work in a fast-paced, collaborative environment.
• Ability to commute to assigned MBTA locations; authorized to work in the United States (no visa sponsorship).

Responsibilities

• Support staff and leadership by conducting data analysis that informs strategic decisions.
• Build, maintain, and enhance dashboards, reports, and visualizations (Tableau).
• Collect, clean, validate, and reconcile procurement and logistics data across systems.
• Assist in maintaining data pipelines and analytical tools; identify trends and anomalies.
• Analyze data pertaining to contracts, purchase orders, vendors, and procurement processes.
• Perform data pulls from enterprise systems when automation is unavailable.
• Support data quality efforts by comparing data between enterprise systems and documenting findings.
• Assist with documentation, process mapping, and modernization initiatives.
• Collaborate with Sourcing, Non-Inventory, Inventory, and Compliance on projects.
• Attend team meetings and participate in fieldwork or other duties as needed.

Skills

Excel for data analysis

SQL/No-SQL

Python/Pandas

Tableau and/or Power BI

Data visualization

Communication

Attention to detail

Organizational skills

Public service interest

Team collaboration

Education

Undergraduate program in data analytics / information systems / business analytics / supply chain

Tools

Tableau Desktop

Tableau Prep

Power BI

Git

SQL

CLI/Bash scripting

Python/Pandas

Job description

The Procurement & Logistics Data Analyst Co-Op at MBTA provides undergraduates with hands-on experience working with large, complex datasets spanning contracts, vendors, purchase orders, invoices, vouchers, and inventory to support daily transit operations and long‑term programs.

You will collaborate with staff and leadership to turn raw data into insights, build dashboards in Tableau, validate data, and help modernize processes so procurement and logistics decisions are data‑driven,