Data Analytics Intern: Supplier Relations & Automation

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

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.