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

Metropolitan Transportation Authority (MTA); New York (NY); On-site; USD 22,000 - 31,000; Full time

Job summary

Metropolitan Transportation Authority (MTA) in New York is offering an Emerging Talent Internship focused on Data Analysis within Supplier Relations. The intern will transform the VENDEVAL workflow by standardizing data and automating processes to improve efficiency and accuracy.

The role emphasizes building dashboards, integrating systems, and supporting reporting modules, with regular onsite attendance at 2 Broadway, New York, NY.

Qualifications

• Proficiency with Microsoft Office Suite and Adobe Acrobat.
• Strong knowledge of Power BI, Power Automate, and Microsoft Access.
• Familiarity with SQL queries, relational databases, and data cleanup.
• Excellent communication with project managers and ability to coordinate follow-ups.
• Ability to analyze data, build dashboards, design workflows, and automate processes.
• Strong organizational, analytical, and communication skills; able to work under pressure and independently while being a team player.

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.
• Develop clean, standardized datasets; create interactive dashboards for Management and leadership; build data pipelines and automation algorithms.

Skills

Analytical thinking

Communication

Education

Undergraduate student in good standing, GPA 2.5

Majors: Computer Information Systems / Computer Science / Project Management

Tools

Power BI

Power Automate

Microsoft Access

SQL queries

Job description

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

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.

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.

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.