Data Analysis (Supplier Relations), Emerging Talent Intern (Spring)

Department: Procurement. Location: 2 Broadway, New York, NY 10004.

About the role

There are 3 groups within Supplier Relations (Vendor Relations): Vendor Performance, Procurement Accountability and Inspections & Testings, tasked with determining if a vendor is responsible to be considered for as an MTA vendor‑ based on its business experience & stability, past performance & technical ability, financial condition, moral integrity & ethics, and its safety record. The intern will primarily focus on transforming the VENDEVAL workflow—including automation, data standardization, reporting, and system integration—to improve efficiency and accuracy.

Responsibilities

• Conduct outreach to project managers to obtain outstanding VENDEVAL evaluations (2022‑2024).
• Standardize data across Access, Excel, and Archer to eliminate duplication and ensure consistent formatting.
• Build automated Power Automate flows to process VENDEVAL data, send notifications, detect delays, and escalate overdue evaluations.
• Organize digital folders and create structured filing systems for rapid retrieval of evaluation documents.
• Develop weekly analytic dashboards showing current evaluation status and progress metrics.
• Test reporting integrity, verify data accuracy, troubleshoot automation functions, and ensure end‑to‑end reliability.
• Assist with maintaining Access databases, running SQL queries, and supporting reporting modules.
• Create workflow algorithms that route evaluations based on evaluator assignment, review status, and contract year.

Projects

• Develop clean, standardized datasets that reduce duplication, inconsistencies, and data quality issues.
• Create interactive visual dashboards for reporting to Management and MTA leadership.
• Build workflow logic, data pipelines, and automation algorithms that ensure timely routing, evaluator assignment, reminders, and record validation.

Required Qualifications

• Proficiency in Microsoft Office Suite and Adobe Acrobat is a must.
• Strong knowledge of Power BI, Power Automate, and Microsoft Access.
• Familiarity with SQL queries, relational database concepts, and dataset cleanup.
• Comfort communicating with project managers and coordinating evaluation follow‑ups.
• Ability to analyze data, build dashboards, design workflows, and automate manual processes.
• The candidate should possess organizational, analytical and communication skills.
• The candidate should be able to work well under pressure and prioritize tasks effectively.
• The candidate should have a keen eye for detail and be able to work independently while being an active team player.

Required Education

• Matriculated in an undergraduate program in good standing with at least 2.5 GPA.
• Major(s) Preferred: Computer Information Systems, Computer Science, Project Management, or a related Business/Technology field.
• All applicants must be authorized to work in the United States at the time of application.
• Students’ transcript must be submitted.

Pay

Hourly Rate: $19.00 (Undergraduate)

Schedule

Minimum 20 hours per week, onsite, regular in‑person attendance required.