Data Analyst Co-Op (Procurement & Logistics) - Undergraduate Students

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 is designed for undergraduate students seeking hands‑on experience working with large, complex operational datasets in a mission‑driven public‑sector environment. Procurement & Logistics holds some of the MBTA’s most critical and information‑rich data, spanning contracts, vendors, purchase orders, invoices, vouchers, and inventory that collectively support daily transit operations and long‑term programs. As a result, there is a constant need for improved reporting, system validation, and process modernization to turn raw transactional data into meaningful insights.

Co-Ops work directly with staff and leadership within Procurement & Logistics to support data‑driven decision‑making and improve how essential goods and services are planned, tracked, and delivered. The role offers exposure to real enterprise systems, imperfect data, and evolving business processes, providing an authentic analytics experience beyond classroom exercises. Co-Ops are encouraged to think critically about how data can be structured, visualized, and automated to increase transparency, efficiency, and accountability across the organization.

This position requires the ability to manage multiple workstreams simultaneously, collaborate with stakeholders across the MBTA, and communicate analytical insights clearly to both technical and non‑technical audiences. While gaining exposure to state and federal procurement regulations in a live operating environment, co‑ops produce tangible analytical tools and improvements that are used by leadership and operational teams, directly contributing to stronger decision‑making and better outcomes for the MBTA.

• Support staff & leadership by conducting data analysis that informs strategic and operational decision‑making.
• Build, maintain, and enhance dashboards, reports, and visualizations (primarily in Tableau).
• Collect, clean, validate, and reconcile procurement and logistics data across multiple systems to ensure accuracy and reliability.
• Assist in maintaining and improving data pipelines and analytical tools, including compiling historical and current data to identify changes, trends, or anomalies.
• Analyze data pertaining to contracts, purchase orders, vendors, and procurement processes.
• Perform invoice, voucher, and payment data pulls from enterprise systems when automated solutions are unavailable
• Support system validation and data quality efforts by comparing data between enterprise systems and documenting findings and recommended updates.
• Assist with documentation, process mapping, and modernization initiatives within Procurement & Logistics.
• Collaborate with Sourcing, Non‑Inventory, Inventory, and Compliance on projects.
• Participate in team / staff meetings, organization events, fieldwork, project teams, or other duties as needed.
• Additional responsibilities may include focusing on one or more departments or locations. See applicable addendums or hiring manager for department or location specific functions.
• Provide internal and external customers with courteous and professional experience.
• Perform all other duties and projects that may be assigned.

* The statements contained in this job description are intended to describe the general nature and complexity of the work being performed by staff assigned to this job and do not represent an exhaustive list of all duties, tasks, and responsibilities required of staff assigned to this position. The physical demands and work environment characteristics described here‑in are representative of those an employee may encounter while performing the essential functions of this job. Reasonable accommodations can be made to enable individuals with disabilities to perform essential functions.

• Enrolled, for the entire duration of employment, in the undergraduate / bachelor’s program of an accredited college or university; preferably in data analytics, information systems, business analytics, supply chain, or related field.
• Above average proficiency in Microsoft Office, particularly Excel for data analysis and reporting.
• Above average analytical and problem‑solving skills, with an interest in data analysis, and project‑based work.
• Above average proficiency in at least one programming language and work with tools such as Git, SQL/No‑SQL, CLI/bash scripting, and R or Python/Pandas.
• Above average proficiency in business intelligence and data visualization tools, such as Tableau and/or Power BI, to develop insightful visualizations and perform in‑depth data analysis.
• Above average ability to explain analytical concepts to both technical and non‑technical audiences.
• Above average ability to communicate effectively in English, both in written and oral forms.
• Highly organized, motivated, and have great attention‑to‑detail.
• Strong interest in public service, transit, or transportation and how it operates.
• Above average ability to work effectively in diverse, collaborative, fast‑paced environments as well as independently.
• Ability to independently commute to assigned work locations in the Boston, MA metro area, as required by the role.
• Authorized to work in the United States (international students in CPT, STEM, or OPT programs through a university are eligible to apply). The MBTA does not provide visa sponsorship, such as H1‑B status.

* The above statements are intended to describe the general nature and complexity of the work being performed by staff assigned to this job and do not represent an exhaustive list of all duties, tasks, and responsibilities required.

• Tableau Desktop Experience
• Tableau Prep Experience