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

Description

Department: Procurment

Location: 2 Broadway, New York, NY 10004

Position Title: Data Analysis (Supplier Relations), Emerging Talent Intern

Hourly Rate: $19.00 (Undergraduate)

All internship positions are onsite and require regular, in-person attendance at the designated work location with a minimum of 20hrs per a week.

OVERVIEW OF DEPARTMENT:

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.

Equal Employment Opportunity

MTA and its subsidiary and affiliated agencies are Equal Opportunity Employers, including with respect to veteran status and individuals with disabilities. The MTA encourages qualified applicants from diverse backgrounds, experiences, and abilities, including military service members, to apply.